I have a crosstab report that looks like this:
A B
1 x
2 x
3 x
1 x
2 x
3 x
It should look like this:
A B
1 x x
2 x x
3 x x
I have been unable to get it to display correctly. Does anyone know how to fix it?
Linda Caron
lcaron@ti.com
Regards, Linda Caron
Andersen Consulting at Texas Instruments (972) 927-6339
lcaron@ti.com
Listserv Archives (BOB member since 2002-06-25)
Are the x’s measure objects with qualification functions other than NONE? If they are not, this is the type of behavior to expect. For example
Robert
Schmidt Interactive Software, Inc.
I have a crosstab report that looks like this:
A B
1 x
2 x
3 x
1 x
2 x
3 x
It should look like this:
A B
1 x x
2 x x
3 x x
Listserv Archives (BOB member since 2002-06-25)
At 02:26 PM 06/07/98 -0500, you wrote:
I have a crosstab report that looks like this:
A B
1 x
2 x
3 x
1 x
2 x
3 x
Hi Linda:
We had a similar problem while creating a product catalogue. We got around it by creating a view on the database side. However, whether our solution makes sense for your situation would depend on the size of your tables and how many values you have going across the columns (i.e. A,B…n). Is the number of values in the columns and the size of the table realitively small? Also, is X a measure (with a qualification function of none) or a dimension?
Regards,
Chander Aggarwal
The home of BusinessObjects Essentials
WORLD’S FIRST AND ONLY FULL MULTIMEDIA
COMPUTER BASED TRAINING FOR BusinessObjects!
Listserv Archives (BOB member since 2002-06-25)
Linda Caron schrieb:
I have a crosstab report that looks like this:
A B
1 x
2 x
3 x
1 x
2 x
3 x
It should look like this:
A B
1 x x
2 x x
3 x x
I have been unable to get it to display correctly. Does anyone know how to fix it?
Check, that you use an aggregation function (like sum() or …) on the ‘x’ values…
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)