Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt Fi

Hi,
In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me

Question Posted / guest

2 Answers
5270 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastnam..

Answer / swamy

Hi,
from gosales&retailers,
1.drag first name, workphone,email data items into list report,
2.double click on first name data item,
type as ||' ||
3.in expresin windw left side drag last name,
clik validate,ok.

[gosales_goretailers].[Sales reps].[First name] ||' '|| [gosales_goretailers].[Sales reps].[Last name]

Is This Answer Correct ?

4 Yes

2 No

Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastnam..

Answer / suresh

Hi,
Its just simple. Create 2 data items and name it
first_name & last_name. write a code like
substr(fullname,postion,end).

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Cognos Interview Questions

Can you define materialized view?

0 Answers

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers

i was asked what are the caluclations done by you in your report? plz give reply

0 Answers IBM,

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers

What snowflake and Starschema?

2 Answers HCL,

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers HCL, Wipro,

is there any difference between operational database and data base?if yes what r they?

0 Answers

how u will determine the performence tune will occur either in report or system

0 Answers Ness Technologies,

Wt is the Diff between Business Key & member caption?

2 Answers

plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 Answers

What you mean by drill across and what is the difference between drill through, drill across?

0 Answers

What are the different kinds of panes included in cognos?

0 Answers

For more Cognos Interview Questions Click Here