Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total Options

Status
Not open for further replies.

Ina

Programmer
Feb 7, 2000
41
US
Has anyone tried to use Running Total functionality in different version on CR?&nbsp;&nbsp;Have you experienced any difficulties?<br><br>In version 7, there are three methods to calculate Running Totals in the report: manual RT, RT functions, and RT Expert (which generates errors on page breaks and is basically very limited).<br><br>In version 8,&nbsp;&nbsp;Seagate has not tested the manual RT and RT functions, they claim that the RT expert has been &quot;fixed&quot;.&nbsp;&nbsp;Does anyone know if this is true?&nbsp;&nbsp;Does the expert really generate correct RT in v8?<br><br><font color=red><b><i><u>And most importantly, has anyone found an alternative/permanent fix to Running Total approach that does not have to be revisited when we go from one version to another? </u></i></b></font><br>
 
I never used the RT function until v8 (been working with CR since v1.1) because I didn't trust it.&nbsp;&nbsp;It does seem to work reliably now.<br>The manual approach will always work, but the RT feature does save a bit of time. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
I've had several reports that used running totals in version 6.&nbsp;&nbsp;They ran very slow, and in some cases caused &quot;System running low on resources&quot; errors.&nbsp;&nbsp;When we upgraded to version 7, I tried the &quot;Running Total Expert,&quot; only to find that some records were not counted if the detail lines were suppressed.&nbsp;&nbsp;But the reports did run much faster - just lost a little thing called accuracy.&nbsp;&nbsp;<br><br>The friendly support people at Crystal advised me to not use any of the running total functions, but to use variables instead (using 3 formulas; to reset, to accumulate, and to display).<br><br>When I got an evaluation copy of version 8, I tested all those reports using the running total expert again and they actually balanced.&nbsp;&nbsp;Thus, it is looking like they fixed the problems with accuracy in their &quot;Running Total Expert.&quot;&nbsp;&nbsp;&nbsp;The use of variables has worked well for me with every version though.<br><br>Crystal did direct me to a Running Total document that they created that seemed a little helpful, They had me go to this site:<br><br><A HREF=" TARGET="_new"> look for the file SCR_RunningTotals.zip<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top