Multiple crosstabs grouped/sectioned by a data item?

[Phoebe]

Hi there,

I am working on a report that consists of three crosstabs in a table container, all of which are connected via master/detail.  I would like to group/section so that the cluster of crosstabs is generated for each staff member. 

This works fine when I use the section/unsection function with a single crosstab, but when I try to do this with the multiple crosstab layout, it doesn't work correctly (I only get one cluster of crosstabs, not a cluster for each staff member).

Can anyone suggest something to try? 

For what it's worth, each crosstab has been sectioned individually. 

Thanks!

[Lynn]

I would try using a list that returns a row for each staff member and then have each crosstab within the list. Each crosstab would be connected to the list via master/detail.

I'm not quite sure what your current connection between the crosstabs is with regard to master/detail, so not sure if this is going to suit your purpose or not.

[Phoebe]

Thanks Lynn, I'll try that.

The current master/detail relationship is Staff_ID.  I have the page query set, then master/detailed the three crosstabs to that.  The cross tabs are in a table.

I'll give your suggestion a try now and report back...

[Phoebe]

Hey Lynn,

That worked :)

No I just need to work on the formatting some, to get rid of the grid lines that the list generates. 

Thanks for the tip!

I wonder though, if it's still possible to do this with the crosstabs in a table instead of a list...

[Lynn]

Glad it worked! You could try a repeater or repeater table instead of a list which might simplify formatting.

You could also try associating the master query to the page (instead of using a layout container on the page) and then try your idea of using the table to contain the detail crosstabs. Just a guess since I've not done quite that same thing before.

Enjoy the weekend!