Sub Report Name Displaying Instead Of Data


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
 
Ad

Advertisements

S

Steve Edwards

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

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
 
Ad

Advertisements

H

HB

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top