How to shift field down one row

[capronton]

Is there a way to shift "actHdwy" field down one row?

actHdwy schHdwy hdwyDev cmta_Status
14 15 -1 OnTime
15 15 0 OnTime
16 15 1 OnTime
14 15 -1 OnTime
15 15 0 OnTime
15 15 0 OnTime
15 15 0 OnTime
15 15 0 OnTime
15 16 -1 OnTime
14 14 0 OnTime
11 14 -3 OnTime
10 11 -1 OnTime
11 11 0 OnTime
12 11 1 OnTime
13 11 2 OnTime
9 11 -2 OnTime

 

[capronton]

Actually, I need all four columns above shifted down one row.

Can I do this in the report without having to export to Excel and then shift the four columns down one row?

 

[Charliy]

Not sure exactly what you mean, I can interpret that question 2 ways.

1. They all just need to be lower than everything else:
Just split your Detail band into 2 parts and place those fields in Detail B.

2. You need the value of row 1 in row 2, and so on.
Create a formula for each field like: If onfirstrecord then ' ' else previous({table.field})

 

[capronton]

Thanks Charliy.

Yes, I need #2 above the value or row 1 in row 2. However, the formula below
gives me the "This field has no previous or next value". Can you explain?

If onfirstrecord then ' ' else previous({@minArrival})

 

[Charliy]

I'd need to see what your minarrival formula looks like.

 

[capronton]

minArrival formula is pasted below. Thanks.

WhilePrintingRecords; //Place in Group Footer
if {command.vehicle_id} <> Next({command.vehicle_id}) then
(
Time(next({command.incident_date_time})) -
Time(Minimum ({command.incident_date_time}, {command.vehicle_id}))
)/60
else 0;

 

[Charliy]

That's what I was afraid of - your formula is at the group level. We're going to need to get into shared variables. I've got meetings the rest of the day so I really can't get in depth on that until tomorrow.

 

[capronton]

Okay, shared variables may be the only way to do this.

Thanks for all your help!