Hi All,

I'm trying to create a new subreport for an existing report. The main report is a customer report. The subreport will be a commodity report which will be linked by the customer number.

I tried linking the customer number from within the customer table in the main report to the customer number within the commodity table in the subreport. I went through the subreport Links window, selecting the customer number to link to, and the customer number in the commodity subreport table.

But when I run the main report, I only get the headings in the subreport, no other data. Not every customer number being displayed in the main report will have a matching record in the commodity table, which is probably part of the problem. How can I display the commodity information for customer numbers from the main report if it exists in the commodity table?

Thanks in advance for any advice!
Frank

Hi WSC27,

Thanks for your reply. Yes, I used the wizard to set up the subreport. I have the customer number as the Field to link to, and the checkbox for Select data in subreport is checked. Currently, I am only displaying two fields on the subreport, the customer number and the commodity code, which are both in the commodity table. I know that many of the customer numbers in the main report are not going to be found in the commodity table. I was hoping that the subreport would show the data if a match was found and just skip the ones that aren't in the table.

Thanks.
Frank

Thanks Lockwelle. This brought me closer to resolving my issues. I have one left ... the subreport is showing records for all the customers in the Customer table, not just the ones listed in the main report.

In the Database Expert of the subreport, I have the commodities table first, linked to both the customer and commodity description tables together at the same level.

How can I get the subreport to match the data (customers) from the main report, and not include all of the customers from the customer table? Am I linking them incorrectly?

Thanks!
Frank

Thanks for your reply!

I placed the customer table first linking to the commodities table. The join type is INNER JOIN, NOT ENFORCED and the link type is Equal.

In the Subreports Links window, Field(s) to link to: Customer ID, Subreport parameter field to use: Customer ID, checkbox (checked) for Select data in subreport based on field: customer ID.

Now the subreport is prompting for a customer ID as a parameter but not returning any data. I need the subreport to not ask for a parameter, just return all the commodities for the customers that reside in the main report.

Thanks!