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

 

Report Studio - Different Filter on each page using one query and Table of Conte

Started by usjse, 14 Mar 2014 09:24:55 AM

Previous topic - Next topic

usjse

I am new to Cognos and need help with a report I am using a Table of Contents in Report Studio PDF output using one query and 4 pages in the report.  I am using the same filter on 3 pages but the last page I need to filter one data item to show only if the date item has data in that column.  My question is:  is there such thing as a report filter (page filter) using a filter on a list report that will not affect the other pages?   I tried using another query just for that one page and it messed up the Table of Contents.   

Report or List filter for one query?

Thanks,

jse :(

anjidwh.cognos

create render variable based on data item like...char_length(dataitem) ..use this one in boolean variable and assign to a page in render variable property.

Hopefully it works for you!!!

SRK

usjse

I created a booleen render variable for the page:  character_length ([data item]) is not null and it gives one page with the item I'm trying to filter with data with that item on it and the other page with nothing (Table of Contents).  I even tried selecting  the entire page and it will give me no data at all on the page.  The one page shows the first column with the filter item on the first row with data and on the other columns  several rows of data.   ???  It sure would be nice to just be able to filter one page at a time and the table of contents would reflect that.

jse