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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multiple details for a single parent group

Status
Not open for further replies.

FEROZKHAN

Programmer
May 30, 2002
12
US
Hi, I want to create a report which will have two details section in a master section . And I dont want to use subreport. The out put should look like this

MASTER ID - 1001

DETAIL - 1
A - 300
B - 200
C - 400

DETAIL - 2
X- 900
Y- 400
Z- 230

. I want the all the records of "DETAIL 1" to appear first and then all the records of "DETAIL 2" to print . How can I do this without using sub reports
Thanks for your help
-Feroz
 
From the report design tab, rightclick on the detail section on the left and click on "Insert Section Below". You could then place data from Detail 2 in this section.

-LW
 
Hi LW,
Thanks for your quick reply. I tried that option before, but the data is not priting together . Here how the data is getting printed.
MASTER ID -1001
A- 300 - OF DETAIL 1
X- 900 - OF DETAIL 2
B- 200 - OF DETAIL 1
Y- 400 - OF DETAIL 2
C- 400 - OF DETAIL 1
Z- 230 - OF DETAIL 2

AND if there is only one record for the DETAIL 1, then its repeating for each record in DETAIL 2. Here is how it comes out

MASTER ID -1001
A- 300 - OF DETAIL 1
X- 900 - OF DETAIL 2
A- 300 - OF DETAIL 1
Y- 400 - OF DETAIL 2
A- 300 - OF DETAIL 1
Z- 230 - OF DETAIL 2

. But what I want is the details from DETAIL - 1 should be printed first, and all details from DETAIL - 2 should be printed.
Thanks
-Feroz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top