display records from both tables A & B

[santosh1]

I made a sub-report to display data from table B. The main report shows the report from table A. When the sub-report
is placed in the page footer, the report displays data from both table A & B which is what I wanted. I want sub-report to be displayed below main report. The page footer is way at the bottom and creates a lot of blank space when I put the sub-report at page footer. But, when I put the sub-report below the main report in the detail section, it repeats records from table B as follow. How can this be fixed? Thanks again.
For eg.

In main-report detail section

tableA.ItemID tableA.itemDescription tableA.Qty

sub-report_tableB


will displays:

tableA.itemID_1
tableB.itemID_1
tableB.itemID_2
tableB.itemID_3
tableB.itemID_4
tableA.itemID_2
tableB.itemID_1
tableB.itemID_2
tableB.itemID_3
tableB.itemID_4
tableA.itemID_3
tableB.itemID_1
tableB.itemID_2
tableB.itemID_3
tableB.itemID_4

 

[lbass]

It sounds like your report is less than one page long. To nest the subreport under the main report and eliminate the gap between the main report details and the subreport, create a group which contains all of the main report records by grouping on a formula like:

{table.IDfield} > 0

Then place the subreport in the group footer.

-LB