Grouping or Subreport?

[recon0302]

I have designed a report for printing based on multiple tables. This Main report contains two subreports that are linked by main report number. The sub reports are based upon tables and again are linked by main report number. When there is data in all of the reports for a particular record everything works and prints fine. However, if one of the linked tables (for one of the sub reports) contains no records then the entire report prints all of the fields but no data in the report or in either of the subreports.

To further exacerbate my problem, I would like the sub reports to print something to the effect that no records exist in the subreport for the report number selected. Any help is greatly appreciated. Thanx.

Marty

 

[llkhoutx]

Test your report's "OnNoData" event and take appropriate action.

 

[recon0302]

I tried that in the sub report NoData box and in the main report NoData box. Neither way works. I dont know why but it is buggin the s--t outta me. Help?

Marty

 

[Rich]

There is no NoData event for subReports, you have to use the HasData method on the main report to reference the subReport

 

[recon0302]

Not sure what you mean by the Has Data method. I dont find this on the main report. Could you further explain? Thanx.

Marty

 

[recon0302]

Can no one explain this? Surely I haven't stumped everyone. There must be a simple solution to this but I can't find it. Please help!

Marty

 

[recon0302]

This has been viewed 70-some-odd times. Someone must be able to help me out here? (Notice how I keep adding stuff to keep it on the front page - that's because I'm desparate) Please. Thanx

Marty

 

[recon0302]

I'll give it a try. Thanx for responding. This has been driving me nuts!!!!!!!!!!!!

Marty