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

Hide Blank columns in the list report

Started by Kutti, 15 Dec 2010 11:39:09 PM

Previous topic - Next topic

Kutti

Hi All,

Can anyone tell me how to hide blank columns in the list report.

If all the rows in the column are blank then that column should be hidden at run time and if it has atleast one value then it should not be hidden.

Thanks

Lynn

You could try creating a query item that computes the total value of the columns and then use a render variable.

For example:
1) create a query item "TotalColumn" with expression: total([MyNumber] for report)
2) set a boolean render variable on the list column with expression: [Query1].[TotalColumn] > 0

Using a conditional style is another method instead of the render variable.

If the column is not a number, you can try the count function instead of the total function. This will automatically exclude null values from the count. If a blank value isn't actually a null value (e.g., an empty string vs. null) then create a data item that says if ([value] = '') then (0) else (1). You could then total this column as the basis for the render variable.

jahnavi

if you are using 8.4 then there is a function in the properties pane called supresstion just click on that and select what type of values you want to hide

Or else

in the filter write an expression like [dataitem1]<>0 .

Let me know if you are still facing the issue