Hi, from gosales&retailers, 1.drag first name, workphone,email data

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 / swamy

2 Answers
5272 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of folder present in cognos?

1049

What are the considerations regarding performance kept in mind while setting up cognos?

919

What is the enterprise class platform architecture of cognos 8?

972

What is defined as catalog and types of catalogs in Cognos?

1043

what is a prompt value in report studio and variables ?

2630

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1879

Can you define metrics designer?

1012

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2325

How create measures and dimensions?

1009

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

2079

What are the advantages of cognos?

918

What is the complex report you faced in real time?

2124

What is meant by junk dimension?

1102

Which studio is used to create reports?

1061

Can you define cognos impromptu?

980