Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


How to shift field down one row

How to shift field down one row

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

RE: How to shift field down one row

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?

RE: How to shift field down one row

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})

RE: How to shift field down one row

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})

RE: How to shift field down one row

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

RE: How to shift field down one row

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}))
else 0;

RE: How to shift field down one row

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.

RE: How to shift field down one row

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

Thanks for all your help!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close