Totals per Data in Footer

[EdelMarkus]

Hello,

I'm using Crystal Report in Visual Studio 2005.

I want totals in the reportfootersection per data from details:

In the details I have taxrates 0, 10, 20 and a pre-tax per taxrates. I get this from SQL.

Group1:
Taxrate | pre-tax
0 | 10
10 | 200
20 | 500
---------
Group2:
Taxrate | pre-tax
10 | 30
20 | 10
---------

In the reportfooter I want a total from pre-tax per Taxrate.

I want a total from all pre-tax with taxrate 0, then a total from all pre-tax with taxrate 10, and so on.
A difficulty: the taxrates are not fixed to 0, 10, 20.

Footer:
Taxrate | Total of pre-tax
0 | 10
10 | 230
20 | 510

How can I solve my problem?
Can I solve this with a formula or a running total?
Can someone help me?

Thanks a lot.

Markus

 

[Madawc]

Try a crosstab. You find this option under Insert and it is a useful option to get familiar with.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[EdelMarkus]

Hello,

thanks a lot.

It's that simple, I was thinking to complex.
Shame on me

Markus