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

Can rows be conditionally rendered?

Started by cogb, 14 Jun 2016 09:02:37 AM

Previous topic - Next topic

cogb

Good morning:

I built a report where I was able to hide certain rows based on the selections the user makes on a prompt page.  I use a conditional style with the box type set to None if the condition is true.  However, when I tried to calculate totals on what was displayed, the result included the hidden rows.  Reading through the Report Studio documentation, I learned that this is by design, but with conditional rendering, even hidden rows will not be counted.  But, it seems that this functionality is intended for columns and not rows.  Am I right?

Is there another way that I can accurately count the number of displayed rows, while ignoring hidden rows?

I am by no means an expert at Report Studio.  So, I appreciate your expertise and help.

Thank you,
cogb

dougp

The tool used to conditionally render a row is called a query filter.  If you want to display one thing and count another, you'll need two, different queries.

cogb

dougp, thank you very much, it worked!  I misread a statement in the manual regarding the use of query filters.  I thought a case statement wouldn't work since it's essentially going to be placed in the where clause of the query being executed anyway.  But, it works and is the simplest solution to the issue I had.

Thanks again!   :)