This might be the simplest thing to do but I am having a heck of a time with it.
So you can get a picture of this,I have a card ticket stock with a top portion that is 8" wide and about 6" high (that corresponds to the Page Header section of the report). Below that are 3 rows of 2 business card sized tickets (that correspond to the Detail section).
I have a recordset keyed by order number and record type. There is one HEADER record and one or more TICKET records. The tickets are things like dinners, events, etc. I want all records to print on the same sheet. The HEADER record data goes onto the Page Header while the TICKET records go into the Detail section. The detail section is a two column area to accomodate the tickets. I have been trying everything I can think of to do this. But I get two sheets. One with the header and one with the tickets.
I currently do:
1. Suppress the details based on record_type <> 'TICKETS'
2. Added a Group around the detail on a change in order number.
I don't know what else to do. Does anyone have an idea?
Thanks in advance,
Jerry Scannell
So you can get a picture of this,I have a card ticket stock with a top portion that is 8" wide and about 6" high (that corresponds to the Page Header section of the report). Below that are 3 rows of 2 business card sized tickets (that correspond to the Detail section).
I have a recordset keyed by order number and record type. There is one HEADER record and one or more TICKET records. The tickets are things like dinners, events, etc. I want all records to print on the same sheet. The HEADER record data goes onto the Page Header while the TICKET records go into the Detail section. The detail section is a two column area to accomodate the tickets. I have been trying everything I can think of to do this. But I get two sheets. One with the header and one with the tickets.
I currently do:
1. Suppress the details based on record_type <> 'TICKETS'
2. Added a Group around the detail on a change in order number.
I don't know what else to do. Does anyone have an idea?
Thanks in advance,
Jerry Scannell