Variables to be seen throughout database

[theundergod]

I apologize I am too ignorant to know what to even search for to see if this had been covered in a previous posting. I am trying to get a variable used in one report (to represent wether or not all subreports are without data or not) to be seen by another main report which has the first report as a subreport. Hope that makes sense. I want to give the user an option to close the report if the subreport, and all of the subreport's subreports, is without data. The main report can't see the subreport's subreports to check by itself so the code used to check is in main's subreport and has to somehow 'tell' the main report that all of its subreports are without data.

Main Report(needs to know whether the 1st subreport's subreports have data or not)
{
1st Subreport (contains code to check data for all of the below)
{
Subreport a
Subreport b
Subreport c
etc..
}
}

I hope I have explained this well enough for someone to understand what I am doing.

Thanks a bunch for any info or suggestions.

-Jon

 

[THWatson]

Jon
Take a look at the HasData property, which you can use in a main report to see whether or not a Subreport has data.

This thread might help also...
thread703-1034924

Tom

 

[theundergod]

Excellent thanks for the post. I realized that I had not called on the other report's objects properly because the code had originally been for the main report without the middle subreport and then I decided I was making it too difficult on myself and just got rid of the subreport in the middle. Oh well, you live and you learn and sometimes that experience makes me feel like it idiot. Thanks

-Jon