Multiple Cross-Tab group by

[mmurdock]

Here is the situation. I'm writing a report that shows a teachers grade book. I have students down the left column, assignments across the top and grades in the middle. This works great if I just bring in the data for one class. However I would like to bring in all of classes for the whole semester. When I do this It dumps all of the students and assignments into one huge cross tab table. I would like it to generate one cross tab table for each class. If I was writing a standard report I would use the group by data bands. Any help would be appreciated.

Thanks,

Mat Murdock

[Brendan]

Yes, something like this is possible.

You can use a crosstab within a databand to achieve grouping. It will depend on the structure of your Datasource.
Is your data coming from 1 table or multiple tables? For example, do you have tables for Classes, Assignments, Students and Results?
Or does it all come back as 1 table from your DB?

If it's all one table you can still create a Datasource based from another one using the "Data from other Data-source" option.

See the Sample Here
This sample only has 1 table with registered data but creates another Datasource based on the original to achieve Class grouping.


Also check out the Cross-Tab on Databand report in the Demo application.

What you must do is set the Data Source and Data Relation properties of the Cross Tab to achieve grouping.



If you already have 2 tables in your datasource, 1 for Classes and 1 for Results then you can just place a Classes Databand on your report page, place a crosstab inside the databand and set the datasource and datarelation properties of the crosstab. Assuming the Results has a relation to Classes.

[mmurdock]

I have a query that brings in all of the data, but using your first example I brought in a second query that had just the course numbers. With the help of your example I was able to get it working!

Thanks,

Mat