Report with sub-reports

[cobalt]

I have designed a report and within this a sub-report. The link between the two reports is National Stock Number (NSN).. My problem is that within the sub-report there can be anywhere from 1 to countless records linked back to the main form, creating very large reports. I have four(4) fields printing within the sub-report for each linked NSN. Is there a way to have this information print horizontal across rather than vertical ???

Example of type of output:

OH-QTY LOC OC DLA OH-QTY LOC OC DLA
3 AED AA 1284 5 AES HA 1256
2 B53 BB 1193 10 C3U FF 1301

Header and data value's repeated across page several time..... Thanks for any help on this......Dennis

 

[Rohdem]

Go to the 'page setup' of the report and change the number of columns. This will work only for the detail portion of the report, you will have to put the headings accross the top for each column you have. It will take a little trial and error, but it will work. Mike Rohde
"I don't have a god complex, god has a me complex!"

 

[cobalt]

Thanks Mike, will give that a closer look.... Have a good one...Dennis