If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

hybrid section report

Started by blom0344, 20 Apr 2008 04:14:16 PM

Previous topic - Next topic

blom0344

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

almeids

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?

blom0344

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