If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Representing greater/less than 300% as ++,(++)in Report studio

Started by san_challa, 14 Jan 2012 06:59:15 PM

Previous topic - Next topic

san_challa

Hi -

I am new to cognos and have the following query. Pl. help. I have a multi-page report in 8.4 report studio and I am using mostly crosstabs on all the pages and one of the column is delta(percent format).The user wants me to Represent greater/less than 300% as ++,(++).so these are the steps i followed. I changed 'Define contents-Yes' for delta brought in Delta from concerned query and then a textbox with ++ value.I defined a style boolean variable for condition delta>=0.3 and then depending on Yes/No I hid and showed values for both delta,++ present in the column now. This works but i have 2 diff delta values in each crosstab and there are like 7,8 crosstabs all using diff queries. I donot want to use the same approach for<=0.3 because i have to use&define many variables.

I am sure there might be an easier way to do this.There are few existing rep using this logic and i checked the passthrough sql used for the rep and variables in the report not a clue how the previous developer did it.
Any help will be greatly appreciated.
Thanks!


absriram

Hi,

If I understand your requirement correctly, you need to use a string variable instead of boolean. Use a case statement to define multiple ranges.

Then you can change the text for the individual values accordingly.

I have written an article for doing something similar. Check it out at:

http://www.cognosonsteroids.com/2012/01/crosstab-with-non-numeric-fact.html

If I misunderstood your reqs.. please give a couple of examples and I will try to answer it.

Thanks,
Sriram.