Print Page | Close Window

No Previous Value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20503
Printed Date: 02 May 2025 at 2:11pm


Topic: No Previous Value
Posted By: Tompong
Subject: No Previous Value
Date Posted: 20 Feb 2014 at 12:34pm
I created a report that compares two group total(Ex. 2012 & 2013), when I use the command "previous" its giving me an error "No Previous Value" cause basically there is no data for 2012, is there a work around on this?


Replies:
Posted By: DBlank
Date Posted: 21 Feb 2014 at 5:11am
previous is in reference to the prior row of data.
You will need to explain your data set and what you are trying to accomplish to get any more help on a possible solution

Posted By: Tompong
Date Posted: 26 Feb 2014 at 4:54am
I grouped my data into quarters then comparing it with previous years(same quarter) but the is there is no data for the previous years.

Posted By: DBlank
Date Posted: 26 Feb 2014 at 9:49am
Grouping does not matter with a crystal previous() function other than it impacts your sorting.
What do you mean 'comparing it'?
That is pretty vague...

Posted By: DMD45
Date Posted: 29 Jul 2014 at 8:50am
You would need to first put in an IsNull condition. For example, If PreviousIsNull() then 9999 else ....

Dianne

-------------
Dianne


Print Page | Close Window