Build a cross-tab by myself

[dabrattom]

Hello,

I'm a newbie at Crystal Reports, let me explain my problem:

I have the following fields and records in a table:

PERIODE PRODUCT QUANTITY
------- ------- --------
P A 2
P B 3
P-1 A 1
P-1 B 1

I would like to obtain following display in my report:

PRODUCT P-1 P P Vs P-1
------- --- - --------
A 1 2 1
B 1 3 2

No problem to group products by name and to build totals for the "P-1" periode for example using "Select Expert".

The problem is : when i apply a restriction on the value of the "periode" field, it applies to the whole report. So i can't have for both "P-1" and "P" periods quantity totals.

I know i can obtain this kind of result with a crosstab, but i'm not able to add the "P Vs P-1" column in it for example. Is there a way to construct this kind of crosstab by myself ?

Thanks in advance.
Greg.

 

[Madawc]

If you want two different sorts of groupings and totals, consider using a subreport. Or a running total with a selection condition.

You also need to say which version of Crystal, 8.5 or 9 or whatever. Solutions that work in recent versions may not be available in older ones.

Madawc Williams
East Anglia, Great Britain

 

[dabrattom]

Thanx for your answer. I finally found the solution there:

http://support.businessobjects.com/library/kbase/articles/c2008472.asp