Report Studio....?

[shri]

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

[goose]

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

Code Select Expand

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

[shri]

Thanks Angus.