Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: No Previous Value Post Reply Post New Topic
Author Message
Tompong
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 11
Quote Tompong Replybullet Topic: No Previous Value
    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?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
IP IP Logged
Tompong
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 11
Quote Tompong Replybullet 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.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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...
IP IP Logged
DMD45
Newbie
Newbie
Avatar

Joined: 28 Jul 2014
Location: United States
Online Status: Offline
Posts: 5
Quote DMD45 Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.094 seconds.