How do I date span fields 1

[vb6rookie]

I want to create a report where the data from one field is from the previous days data and the rest of the fields from the table are for the curent day, in a drill down report

I.e. Begin + received + Transfers - end = usage
Yesterday + current+current - current = formula

 

[kenhamady]

Can you define who goes into these four categories, using your data values?

Begin
received
Transfers
end Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[vb6rookie]

Thanks for the response. In the drill down report imight have the following data:
date begin in rec end
1/1/2001 100 5 0 100
1/2/2001 201 0 0 201
1/3/2001 125 0 2 125

What i need to display is
1/2/2001 100 0 0 201
1/3/2001 201 0 2 125
I cannot figure out how to make the 2nd column go back to the previous record date

 

[kenhamady]

I am not sure that I follow, but you can write a formula using the Previous() function to get the value of a field from the previous record. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[vb6rookie]

Thank you
I bet the previous function will do the trick
Thanks!

:-D