PDA

Click to See Complete Forum and Search --> : [RESOLVED] Sub Report Question CR


Besoup
Aug 10th, 2006, 03:27 PM
Hey,
I have a report that lists the detail of a table. In each detail line I need to display data from another table that will display the records matching an ID number from the main reports detail line....

Do I need a subreport to do this? If so how would I pass the criteria to the subreport from the main report?

Any ways to do it without a sub report?

Here's a psuedo example of what I am trying to accomplish:

IDNumber IDDetail MoreIDDetail
IDNumber IDDetailFromOtherTable
IDDetailFromOtherTable
IDDetailFromOtherTable

pnish
Aug 10th, 2006, 05:26 PM
One way to do it would be to insert a Group section based on IDNumber from your main table, the group header would contain "IDNumber IDDetail MoreIDDetail", then the details section would contain the related data from the other table. Does that make sense?

Besoup
Aug 11th, 2006, 07:03 AM
Thanks, that probably the best way to go.