Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Subreport but on same record

edited March 2003 in General
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

Comments

  • edited 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

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited 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

This discussion has been closed.