December 19th, 2012, 07:59 AM
Don't show records in main if subreport for the record shows no data
So here is a problem I have that I can't figure out.
I have a main report, one record pr line, place in a group footer.At the end of that same record line is a subreport. Is there any way to not show records in Main if the Sub does not contain Record? If Main returns 20 records, but 10 of them don't return anything in the Sub, I don't want those records included. I can't for the life of me see any way to do this. Any hints and ideas?
December 19th, 2012, 10:11 AM
Re: Don't show records in main if subreport for the record shows no data
You should give more details about the tables from where the data is coming
Describe the tables for the main report and the tables for the subreport
Is there a relationship among them?
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!