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
write a query to display the departments with no employee?
Why is auto-regression used in forecasting used on cognos platform?
what is hints in cognos and where we use it.
Explain what is the difference between native sql and cognos sql?
What are products of cognos?
Define cognos report net?
how you migrate reports to cognos 8 from previous versions?
What are the components of report net?
How do we drill through from a powerplay cube to reportnet?\
What is a Transformer?
What is Additive function?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
How to create a cube in Transformer? What is the process? Please mention process thank u
Can we test the report other than manual testing?
What are the methods by which it non-durable model could be changed into the durable model?