[Last Call] Learn how to a build a cloud-first strategyRegister Now


Crystal reports-get previous database field

Posted on 2006-04-04
Medium Priority
Last Modified: 2008-03-04
I have a crystal report showing deal numbers and their corresponding cash flows. It looks something like this:

Deal no       Cash flow amount         Cash flow date
1                 5,555                             2006-03-01
1                 6,899                             2006-04-01
1                 5,000                             2006-04-03
2                 300                                2006-02-01
2                 55                                  2006-04-01
3                 428                                2006-01-01
3                 300                                2006-02-01

In the report I need to include an additonal field indicating on which date the previous cash flow of the deal took place, i.e. something like this:

Deal no       Cash flow amount         Cash flow date            Previous cash flow date
1                 5,555                             2006-03-01                        -
1                 6,899                             2006-04-01               2006-03-01  
1                 5,000                             2006-04-03               2006-04-01                
2                 300                                2006-02-01                       -
2                 55                                  2006-04-01               2006-02-01                      
3                 428                                2006-01-01                        -
3                 300                                2006-02-01               2006-01-01  

How do I "save" the previous cash flow date to appear as information in connection with the next cash flow?

Kind regards
Question by:i98petku
LVL 28

Accepted Solution

bdreed35 earned 2000 total points
ID: 16374170
Create a formua like this and place it next to Cash Flow Date:

if not onfirstrecord and previous({table.dealno}) = {Orders.dealno} then

Author Comment

ID: 16374327
You have really saved me some time there. Thanks! It works great!


Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

831 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