how can you create a report like if country=india then true
if contry=spain then false?
Answer Posted / thanjairajan@gmail.com
1.Go to Report Studio
2.Select list container
3.Drag query item to the list container. i.e for example we take country,staff name,revenue query item from source tab
4.Drag query calculation from tool box tab to right side of the container.
5.In the box give new query item name. in this example Result is new query item name.
5.Expression definition window will show. in that we type like this.
case
when [country]='India'
then 'True'
when [country]='Spain'
then 'False'
end
6.Then run the report. u will see new column is result. in that true value will display equivalent of India country and false value will display equivalent of Spain country.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
which type of project we r going to snowflake schema
what is stitch query in reportnet?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What is defined as Cognos Impromptu?
What is a Framework manager?
What is the report studio?
How to Reset Pagenumbers in one report.
What is the model filter?
what are the filters in framework manager and report studio?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
How we check the errors before running the report?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
what are the dimensions that you have in your current project?list them?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.