Subreport not working right

  • Thread starter Thread starter Pele
  • Start date Start date
P

Pele

I created a Subreport within a Main Report and the links
were done correctly i.e. Customer ID. I only have a Page
Header in the Main Report (i.e. no Report Header).

The problem is that, while the Main Report now shows a
separate page for each customer, the subreport list all
the records that will fill a page; instead of limiting the
list to the relevant Customer ID.

I don't know what is going on.

1) Why is the subreport only stopping after listing a
pages worth of detail. Why is it even showing all these
detail records.
2) Why isn't the subreport just limiting the list to the
pertinent Customer ID displayed in the Main Report (which
is what I want).

Pele
 
Other than just a page header, wouldn't you rather use a
groupheader and than place the subreport in the detail or
group footer. I think this shoul fix the problem.
Fons
 
Fons,

Thanks very much for your insight. I deleted the Page
header and created the groupheader as you'd suggested.
That seem to work since each group is now only affiliated
with the relevant data in the subreport. The problem
though is that now, all the individual customer reports
are on the same page i.e. I would prefer if I had a report
per each customer.

How can I force the report for each customer to show on
separate pages.

Pele
 
Pele, make sure that the subreport is either in the
applicable group header or group footer, this should
restrict the data with the proper link to only display
related data.
Hope this helps.
Fons
 
Fons,

As I'd mentioned earlier, I had created the Customer ID
Groupheader and I put the subreport in the detail section.
Like I mentioned, the subreport was now displaying the
relevant data for each customer, but there are multiple
customers per page of report. As per your advice below, I
have moved the subreport into the Group header (and tried
the GroupFooter), but I still keep on getting the report
showing multiple customers per page.

In summary, the subreport is presently showing only the
records for each customer, but the Main report is still
showwing multiple customers per page. I will prefer a
separate report per customer.

Please advice. I feel like you are so close to solving
this problem.

Pele
 
Fons,

Ignore my last posting; I was able to figure out what to
do to ensure that I print separate customers on separate
pages. I just used the FORCE NEW PAGE option in the
section property. Thanks for your help though; that was
the breakthrough I needed.

Toks
 
I am glad you worked it out. I had not thought of the
force new page, sorry it took so long.
Fons
 
Back
Top