Hi all
I have requirement to , display total number of stores in the header. for example, i have a list report it shows region and stores, and also i have filter for region, if select particular region, the report will display stores in that region and at the same time total number should change in header as well..?
thanks in advance
For a list report you can create a new data item in your query subject in RS and add that to the header - heres how
1. Add data item to your list query in RS. The data item should use the count function
Example
count(distinct [Location].[Stores].[store_no] for report)
2. Set this new data items aggregate function to calculated in properties
3. Assign the query property of the page object to this query in page explorer
4. Drag the new data item onto the header where you want it
Thanks Angus.