[Running Totals] - inconsistent data up refresh

[jpcallea]

Hello,

Thank you in advance for your help, you all know your stuff here...which is awesome. This is my first post. I'm using Crystal Report 2008 v12.0.0.683 at my workplace. I access Crystal via the administration software our company uses. Crystal attaches to an Oracle DB via the adminstration system.

Does anyone know how you contact Crystal Reports for software support? If so please let me know. I'm having a problem and am looking for support on the issue.

As per you all seem pretty dang smart I bet you can help me just as well too. Currently I am having an issue with Running Totals displaying inconsistent data upon refresh. I have one group in my report, it's over SSNUM. I'm doing a running total summarizing over SSNUM, collecting a distinct count & using a formula in the evaluate section of the RT. Formula is [Sum ({RPTEEACCT.CONTRAMT}, {RPTEEACCT.SSNUM})<>0]. I drop the RT in the report footer.

The result I should recieve on my participant count is 1,110. However, when I first click from design to preview I get 22 pages of SSNs and a RT result of 1,107. When I scroll back through a few pages of the output and then refresh the data, I get 1,109. If I scroll back again say six pages or so, & then refresh, I get 1,111. Argh! I haven't added anything or modified anything, I just scrolled from one page to the next then hit refresh and the data keeps changing. When I export to Excel, I get the correct count of 1,110 even though the count at the time of export was listed as 1,107.

Also, of note, the data I am dealing with has been remainig static the whole time, so when I hit refresh, the results should have been identical and the result should have been 1,110.

Has anyone experienced anything like this before? Could this be a bug or is it because of how I've set up the RT and where I've placed it?

Thank you for you patience with the long post, and if anyone knows how I can get to Crystal support that would be great too. Our vendor no longer supports us with Crystal issues so I have to go to Crystal direct.

Thanks,
Jim

 

[IdoMillet]

What is accumulation frequency you set for the running total?

You can gain full control over the process by declaring a global variable and incrementing it (in a GF1 formula) if the condition is True. Then, simply declare the variable in a report footer formula to display the final result.

hth
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jpcallea]

Thanks Ido,

Your help is greatly appreciated.

I am confused by your question:

"What is accumulation frequency you set for the running total?"

I don't understand where to find this. In the [Evaluate] part of the RT formula I clicked the radio button for [Use formula] and put in:
Sum ({RPTEEACCT.CONTRAMT}, {RPTEEACCT.SSNUM})<>0

Also, I tried using global variables with formulas as suggested but I get inconsistent data upon refresh using that method as well. I'm using the following formula setup with shared variables.
Report Header:
Contrb:=0;

Group Footer of SSN:
If Sum ({RPTEEACCT.CONTRAMT}, {RPTEEACCT.SSNUM})<>0 then
Contrb:=Contrb + 1
Else
Contrb:=Contrb;

Report Footer
Formula to Display Contrb

I still am having issues of inconsistent data everytime I scroll through a few pages of data then hit refresh. I very much appreciate your thoughts and comments. Thanks for responding.

Jim

 

[lbass]

SugarCRM1,

It is against site policy to post e-mail addresses. Potential solutions should be posted in the thread.

jpcallea,

You mention using shared variables, but did not declare the variables as such. Is there a subreport involved in your report? Also, is your group set to "repeat group header on each page"? In v.8.0, there was an issue with running totals appearing incorrectly in the Crystal report, but appearing correctly when exported to Excel, and if I remember correctly, the repeated group headers were somehow causing the inserted running totals to calculate incorrectly. This was corrected by a service pack.

The SAP (owner of BO) website is not easy to navigate. Try the following link for technical support:

https://www.sdn.sap.com/irj/boc/support

-LB