Problems with crosstab

Hello all

I try to make a crosstab with (Month X Indicators) and i have a problem because all my months are not in the fact table.

Example

Fact table = Month 1 to 6
Calendary month = Month 1 to 12

I want to have a crosstab like follow

1 2 3 4 5 6 7 8 9
10 11 12
xxx xxx xxx xxx xxx xx - - -


is somebody have an idea to help me

thanks by advance

Philippe Vivier


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

My suggestion is to create a flat file with all of the months you want to see in your crosstab. Create a second query in your report using this flat file as your data provider. Then link this DP with the DP of your report. Create your crosstab from the result.


Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

I try to make a crosstab with (Month X Indicators) and i have a problem because all my months are not in the fact table.

I want to have a crosstab like follow

1 2 3 4 5 6 7 8
xxx xxx xxx xxx xxx xx - -


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