Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multi record to print on the same line

Status
Not open for further replies.

victora

Programmer
Feb 11, 2002
118
US
I have 2 files in a 1-to-many relationship. Say, multiple details per header. I want to print a field(ProcCode) from my detail on the same line, next to each other. How can I do this?

the detail line should look like this:

hdr.field1 dtl.field1 dtl.field1a dtl.field1n..

thank you

 
Place columns in the detail (as many wide as you want). Group by the header table, place the header field in the group and then format the group header to overlay following sections (so that it "looks" like it is in the same row as the detail)

It will give you something that looks like:

hdr.field1 dtl.field1 dtl.field1a dtl.field1b
dtl.field1c dtl.field1d dtl.field1n..


Lisa

 
If you mean that you want all of the same fields detail records to show up in columnar format per group, with the Group Header alongside, consider using a multi column report.

Right click the details and select Format Section->Format with multiple columns->Layout->Width 2.5 or so.

Now do as Lisa suggested"

"Group by the header table, place the header field in the group and then format the group header to *underlay* following sections"

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top