Need Help To Figure Out My Sub-Report Problem

rbuser

I am using D7 and RB7. I have a single table with 7 records. Subreport2
will group this data by the tbl_id value. There are 3 unique tbl_ids. Each
group starts a new page.

I have a single report that contains 2 sub-reports. Subreport1 is just text
with a couple of labels. It contains no DB components. More or less it's a
title page. Subreport2 contains the data. The report and subreport1's
DataPipeline properties are empty. Subreport2's DataPipeline property is
filled. Both sub-reports have the PrintBehavior property to pbSection.
This setup works ok if I wanted only a single page of the subreport1 and
multiple pages of subreport2. I get a total of 4 pages. However, I need to
have the subreport1 page for each new unique record in subreport2 page. The
end result is that I should have 3 sets of 2 pages (1 title, 1 data).

I have also set subreport2's DataPipeline property to empty and this
provides me the title page and data page, but I only get one record of the
table shown in subreport2. The end result is 7 sets of 2 pages.
(Subreport2 only shows a single record, no grouping taking place.)

Any suggestions?

Jeff Kreider

digitalmetaphors

The main detail band will print once. The first subreport prints once. The
second subreport prints once, but it has records so it generates over the
entire dataset.

Use one subreport. Can you place the title in the page header? Since the
subreport prints once, the titleband only prints once, so that won't work.
The only other option is to create a group in the subreport, and force it to
not break by setting it to a label custom field instead of a datafield. Then
you can force the group toreprint hte group headers on subsequent pages.
Place the title info in the group header.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks Jim for the advice. I knew that how the things were being printed to
the screen was correct, but I wasn't coming up with anything that would make
the report behave the way I wanted it to. I never thought of using a single
subreport and a group band, but after you mention it, it makes sense.

Thanks for your assistance!
--
Jeff