I need to have a special reportstructure that will show 8 different types in the following fashion:
Types are A-B-C-D-E-F-G-H (constituting the highest hierarchical level)
The first page should show types A&B side by side , the next page C&D side by side etc.
With sections alone this is pretty much impossible I guess.
My first thought was to assign a table with 2 colums and place a list in each cell , but that would require 8 separate queries (since a filter always effects the whole query)
The nature of the data precludes using crosstabs, but perhaps a repeater could solve this (reducing the number of queries to 4?)
Any advice appreciated..
GuIt does sound like a repeater is the way to go, I'm not sure why you anticipate multiple queries though? You'll just need somehow to page break on "odd" values - A,C,E, etc. A calculated data item (CASE A=1, B=1, C=2, D=2...) should do the trick?
Yep, a repeatertable with a normal table inside seems to work pretty good. And obviously, one does not need more than 1 query this way.
I had never before used a repeater, but in this case I seems to be best..