Topic: Previous Value Posted: 03 Jul 2013 at 6:51pm
Hello All,
my name is Motib. I am vb6,vb.net developer. i am using crystal report 8.5, 2008, 2012 for reports. I am making a report which have rate column. but i want to check last rate of the vendor.... i am trying to do this with previous({@CreditRate})..... but it is not working correctly..... this report is grouped by item id.
basically it is item wise ledger...
item: Pepsi
vendor name rate last rate
abc 13 12
xyz 32 31.5
is any here here who help me in this.......
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 10 Jul 2013 at 4:48am
You can use the Previous, you just need to check that the grouping criteria is correct.
Say you are grouping on {table.Group} and you are looking at {table.Value}
you can use the Previous({table.Value}) but you probably want to do something like:
if Previous({table.Group}) = {table.Group} then //in the same group
Previous({table.Value})
else
0
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
IP Logged
