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

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

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  


What is Cardinality b/w Fact to Fact?

4 Answers   IBM,


Explain difference between powerplay transformer and power play reports?

0 Answers  


What is Cognos Powerhouse and what is it used for?

2 Answers   IBM, M Care,


hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,






What are the batches and it’s details?

0 Answers  


How Metrics Studio is better than Report Studio?

0 Answers  


What is metric store database?

0 Answers  


What is difference between informatica power mart and power center?

0 Answers  


can we create master detail report where master and detailed container is separate?

2 Answers   JPMorgan Chase,


Write some methods to apply securities in framework manager model?

0 Answers  


Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

7 Answers   Blue Cross Blue Shield Association, TCS,


Categories