I currently have a report that lists out in one line all of the details of an airplane trip quote. I need to join this to another table that contains multiple entries, it is a one to many join. I was able to do this, however it reproduces the entire first half of the line for every entry in the second table.
As an example"SwiftWind","NY-NJ","Estimated Flight Time","2 Hours","Cost for time:$2,000"
"[Empty cell]","[Empty Cell],"Catering","5 people","$1,000"
Currently, instead of a blank cell for the first half of the line, it is duplicating all of the information above it for each unit Type/Units/Total from the second table in the one to many relationship. Is there a way to keep the first half of this blank?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
I'm not sure there is a way to do exactly what you want, but you can get close. You can change your first, left-most NL(Rows) replicator to NL(Rows=2) or NL(Rows=3) and then you can move the next NL(Rows) replicator down to the next row. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hey, thanks again. Yeah that is not exactly how I wanted but it is more than good enough.
Please sign in to leave a comment.