My Report is having 2 tabs and data is coming from 4 data provider, i need to set a global filter for the each tab of the Report.
FOR EX
SITE = 1 or site is null means First tab will populate the data
SITE = 0 means second tab will populate the data
how we can set the filter in the report level.
If am setting the global filter then its affecting the block where the filed taken from the data provider, its not affecting the other data provider query.
you’re going to have to provide more details. I can tell you this - you can set filters on the query level or on the report level. So say you have data in your four data providers that is grabbing data for 2 different companies. Then on your first report(tab) you want to show company A and on the second report(tab) you want to show company B. You could use a filter on the report level to accomplish this. report level filters can be applied to the entire report(tab), just a block or chart, or a section.
Query level filters control the data rows that will be returned from the query, and be available to show in the document as a whole.
Am using the Report level filter only, am using the filter that is near by the formula bar (first am selecting the report not a single block) , then also its affecting the block where the filed is taken, its not affecting the other blocks
If i want to set a query filter then i can set the condition in the back end itself.
(BOB member since 2012-07-30)