Producing Graphs on Running Totals

[EdwinBetar]

Hi,

I have produced a report on transactional data over the past 12 months. Part of that report produces a total transactions for each client. I have produced a graph in the report footer based on these total transactions in order to show each client on the x axis and the total transactions on the y-axis. However the results are incorrect with the transactional values instead of being 140,000 for one client they come out as 16000000000. The formula for finding the total transactions is:

count(datetime)

I have managed to get around this by altering the crystal figure manually but I can ot keep doing that. Is there anyway I can get Crystal to produce the figures right the first time around.

Cheers

 

[Guest_imported]

Might be having some type of unlinkable data situation or formulas pointing to running totals. Some type of subreport might be in order (I needed to use a subreport to link temp tables to pull data from perm tables). Try this link for a running total fix:

http://www.hammerapps.com/techtips/techtipsasp/techtipsdynamic.asp?TTID=69