How to create a dynamic column name in Cognos?

Answer Posted / nasa

for example i have the date items like 'first name' and
'last name' now i want to display 'full name'. so here 'full
name' became as a dynamic column bcz its not available in
packages.

steps:

report studio->create new report->list-> drag and drop
'firstname' and 'lastname' from staff_names query table.

now drag a QUERY CAL from toolbox and drop next to last
name.
it will ask a column name, give as a FULLNAME
in expression window write expression like firstname|| ' '||
lastname -> ok

save and run it...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain how to create powerplay reports?

688


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

1671


What do you mean by Drill down and Drill Up?

648


What is catalog and types of catalogs in cagonos and which is better?

599


What is the difference between a cascading report and drill through report?

744






What is cognos reporting tool?

699


What is the difference between Open Connection command ang Open Session Command?

1996


Explain what is the difference between native sql and cognos sql?

632


in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1508


What is model filter?

717


What is difference between primary key and unique key constraints?

658


----------------------What are the User Securities?

1541


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1768


What are the services provided in cognos 8?

667


i have one file i saved in csv how can i take these file into framework manager

1646