Running total problem in Crystal Report 8
I am wondering you are working with VB. Isn't it easier to be done with VB?
I mean, it to do the queries from VB instead of doing it from CR.
If so, I suggest you tu try Rpv Printing System, a new concept tool for
reports.
A freeware Rpv version is available, but Rpv PRO Trial.
If you want, I can send you a free of charge user manual and VB examples.
Visit http://www.rpvreport.com
Regards,
Tomas
Quote:
> Hi,
> my problem is that I get multiple lines for an ID and I want to know
> the sum of a field for a givin category. Example:
> ID Category nb_days
> 1 ADM 7
> 2 SFP 9
> 2 SFP 9
> 2 SFP 9
> 3 APR 4
> 4 ADM 3
> 4 ADM 3
> It's a simplify version of my problem but I get multiple lines for an
> ID so I make a group by and it work fine. But when I want to know the
> total for a category, I get the wrong number (Example: SFP = 27). I
> want to know the total for each category in the report footer section.
> ADM = 10
> SFP = 9
> APR = 4
> In the "evaluate" field of the running total I specify for example
> "category = ADM" in the formula field and with that I get the wrong
> value of 13. If I choose "On change of field" ID than I get the global
> total for all ID. Is there a way to specify in a formula field to
> calculate "on change of field" and for a givin category?
