Solved

Use next row in calculation in crystal reports

Posted on 2008-10-22
3
504 Views
Last Modified: 2013-11-15
I have a cystal report that I need to use data from the next row to do a calcualtion in the row before it.  Is this posible?
0
Comment
Question by:jeremyj54
3 Comments
 
LVL 13

Accepted Solution

by:
crgary_tx earned 250 total points
ID: 22778115
use next(field_name) function..
0
 

Author Comment

by:jeremyj54
ID: 22778970
That worked great thank you
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22779275
One thing to do is to make sure you also check if you are on the last record

If Not OnLastRecord then
  Your evaluation using Next

mlmcc
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question