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
explain how to create powerplay reports?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What do you mean by Drill down and Drill Up?
What is catalog and types of catalogs in cagonos and which is better?
What is the difference between a cascading report and drill through report?
What is cognos reporting tool?
What is the difference between Open Connection command ang Open Session Command?
Explain what is the difference between native sql and cognos sql?
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
What is model filter?
What is difference between primary key and unique key constraints?
----------------------What are the User Securities?
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
What are the services provided in cognos 8?
i have one file i saved in csv how can i take these file into framework manager