Subreport but on same record

rbuser · March 2003

Hi.
I have too many fields to fit on one page. The fields are all from the
same table.
When I create a sub-report and put the remaining fields on it, I get
fields from all records from the table in the subreport. I only want the
current record's fields.

For example, the table contains 80 fields per record.
The main report contains:
Table1Record.field1 ... field 40.

I create a subreport and put in
Table1Record.field41 ... field 80

But I end up with the subreport performing fields41 to 80 for all the
records in the table, not just the record I am sitting on.

How do I get it so the subreport only shows fields from the current record
without looping through the table once for every record in the main report?

ReportBuilder 7. --> today's release..
Thanks.

pl

nicocizik · March 2003

Paul,

Below is a link to an example that will help you with this issue. It uses a
technique that uses two subreports to generate the two sets of fields on the
same dataset twice and then reorders the pages for the actual output device.

http://www.digital-metaphors.com\tips\spreadsheetstylereport.zip

--

rbuser · March 2003

Thanks Nico, I'll try it.
I did figure out that if I duplicated the table component and set up the
duplicate table as a master detail to the original table, and then accessed
that second table from a sub-report, it works fine. But your method might be
better..

Thanks again.
pl

Subreport but on same record

Comments