Sub Report Name Displaying Instead Of Data

  • Thread starter Thread starter Steve Edwards
  • Start date Start date
S

Steve Edwards

I have a database that is used for tracking customer survey data. Each
customer can have multiple products. I have a report that lists customers
that have not yet been surveyed )(rptCustomersNotSurveyed), and another
report that lists the customers that have been surveyed
(rptCustomersSurveyed). A survey can be done for each product, since many
times there are different contact people at the customer for each product.
Within rptCustomersNotSurveyed, for each customer I would like to show a
subreport that shows the surveys that have been completed for other products
for that customer. Each customer has a unique identifying field (lawsonID)
that is used to link the subreport to teh main report.

The problem I'm having is that instead of getting the data in the subreport,
I get the subreport name displayed in rptCustomersNotSurveyed. I've tried
to link the reports two different ways (using the subreport wizard): by
creating a report for the subreport and linkg that to
rptCustomersNotSurveyed, and by using the underlying query for
rptCustomersSurveyed. Either way, just get the name of the subreport
instead of the data. In addition, when I run the underlying query for
rptCustomersSurveyed and the report by themselves, they work fine.

Does anybody have an idea where the problem could lie?

Thanks.

Steve
 
Steve Edwards said:
I have a database that is used for tracking customer survey data. Each
customer can have multiple products. I have a report that lists customers
that have not yet been surveyed )(rptCustomersNotSurveyed), and another
report that lists the customers that have been surveyed
(rptCustomersSurveyed). A survey can be done for each product, since many
times there are different contact people at the customer for each product.
Within rptCustomersNotSurveyed, for each customer I would like to show a
subreport that shows the surveys that have been completed for other products
for that customer. Each customer has a unique identifying field (lawsonID)
that is used to link the subreport to teh main report.

The problem I'm having is that instead of getting the data in the subreport,
I get the subreport name displayed in rptCustomersNotSurveyed. I've tried
to link the reports two different ways (using the subreport wizard): by
creating a report for the subreport and linkg that to
rptCustomersNotSurveyed, and by using the underlying query for
rptCustomersSurveyed. Either way, just get the name of the subreport
instead of the data. In addition, when I run the underlying query for
rptCustomersSurveyed and the report by themselves, they work fine.

Does anybody have an idea where the problem could lie?

Thanks.

Steve
Click to expand...

One question has come to mind since I wrote this. Since I am using lawsonID
to link the two reports together, does lawsonID have to be displayed on the
main report (rptCustomersNotSurveyed in this case), or is it sufficient that
it is in the underlying query? It doesn't seem like it should have to be
displayed, but I'm just looking at everything.

Steve
 
Check that the subreport is sized appropriately. It may be only tall enough
to show the title.
 
Back
Top