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

Multiple pages in a report

Started by cognosmanager, 24 Apr 2012 02:38:24 AM

Previous topic - Next topic

cognosmanager

I have made a report having 4 pages and one query. Each page has different set of data items in it. I have a filter in query for eg. City = 'Delhi'. But when I run the report the filter effect is not taking place instead all 'City' are pulling up. 'City' column is in the query and not on the page. But when I show 'City' on the page then filter is working. What is the reason behind this?

wyconian

Hi sounds like you need to sue the properties property fucntion.  If you add soemthing into the query (not the report page) and then try to filter on it the report can't always see it.

Click somewhere on the list and you use the ancestory button to naivgate to the list (this is found between the insertable objects and the properties pane).  Then scrill down to you get to the properties property,  Click on this and you should see a list of all the items in the query.  Make sure you tick next  to City.

That should alolow the report page to see the query item.

Good luck

cognosmanager

Thanks for the help.

But how come one would know whether filter is working or not, without getting into the data?
I have seen in single page reports that even though the data item is not present in report, filter has been found working.

cognosmanager

Hi All,

Please help me out with this.

wyconian

That's a really good question.  Sorry I don't have the answer.  I think the only way you're going to be able to tell if the filter is working or not is by looking at the data.