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!
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.
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...
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...
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!