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?
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
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.
Hi All,
Please help me out with this.
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.