constant number of columns in a crosstable

building reports desktopintelligence
1

Hi,

I have a crosstable with the months in the columns und several costs in the body. The number of the columns should be constant, even if the query is about the costs of one month. How could I realize it?

Thanks for help,

Marco Popp

Listserv Archives (BOB member since 2002-06-25)

2

Hi,

Marco Popp wrote:

I have a crosstable with the months in the columns und several costs
in the
body. The number of the columns should be constant, even if the query is about the costs of one month. How could I realize it?
The simplest way of achieving this is having a dataprovider which gives back all possible months. If not coming from the same universe (like from an excel sheet), you have to manually synchronize the two on this month. After this, use the variable with all months to go across, this should work.

Success,
Marianne Wagt,
IDETA, the Netherlands

Listserv Archives (BOB member since 2002-06-25)