How to Display Previous Field on Report

[KARMENDRA]

Hi!I'm using Crystal 9.0,Data Access .DAT File with Dataflex connectivity.My Data is like this

ID Date Status
1 01/01/04 D
1 01/03/04 E
1 01/04/04 F
2 01/01/04 P
2 01/02/04 Q
3 01/01/04 S

I wanted to dispaly Previus staus like this
ID DATE STATUS
1 01/01/04
1 01/03/04 D(Previous)
1 01/04/04 E(Previous)
2 01/01/04 (No Previous Record So It should be blank)
2 01/01/04 P
3 01/01/04 S
(I used Previous(Status) but it gave me previous record of other unit id)
If Selection Criteria is by Date it should display only 01/01/04 data but with Previous Status.I cannot write Store Procedure or SQL Statement for this.
What I did:Create Main Report-Sub Report-Shared Variable from Main to Sub to get Previous Staus.But by some reason didnot work.I'm still thinking that there may be other way to do it.Any Idea???
Thanks

 

[IdoMillet]

Use something like:
--------------------------------------------------------
IF OnFirstRecord OR Previous({ID}) <> {ID} THEN &quot;&quot; ELSE Previous({Status})
--------------------------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[KARMENDRA]

Sorry for late response.It won't work because If i select parameter to run this report for 010304 it will generate blank for unit id 01 date 010304.
I want if select date parameter is 01/03/04 it should
generate report like this
1 01/03/04 D(Previous status of last visited record).

 

[lbass]

You cannot get the previous value without the previous record being selected for inclusion in the report. You could include all records and then use a suppression formula (as in your other post) to suppress details outside of the parameter range. This would allow you to still access the value of a previous field for display, and Ido's formula should then meet your needs.

-LB