In an ssrs 2008 report, I would like to add the following to an existing report that contains data:
- Get a final total of all the control groups that are by school number,
- The columns each group of data contains counts by school number.
- The counts are not unique vy control groups. There is alot of redundant data.
Due to the above, I would like to know how to:
- Add counts for outside groups, and
- How use distinct values by school number.
The data is already obtained from a data source that the report uses. Since this is occuring,I cannot use a nhew dataset correct? If not, I have only been able to make the main dataset be used for the report. The other data sets I have used are only for parameter logic.
In my case, can you tell me how I can setup an outside group using an existing dataset and/or make the report use a different dataset that is actually the original dataset?