Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dynamically alter position of subreports on main report

Status
Not open for further replies.

af390

Programmer
May 24, 2004
12
US
my main report has 10 sub reports - each reporting differeing data for a specific account. Occasionally, some of the subreports have no data.

Is there a way to cause the NO DATA report to hide (I know the HasData and NoData) while causing a report WITH data to be displayed in the hidden (no data) reports position?

Any help is much appreciated.

Thanks
 
You can set the sub report size to shrink and grow. The more data in the sub report, the more space it takes, up, all the other reports would get moved down, so it would all fit. If there was no data, the report should shrink, so all the reports should move up.

This should get you the result you need.

Mark P.
Providing Low Cost Powerful Point of Sale Solutions.
 
Thanks. That should do it. I do it for fields....forgot you can do it for reports also!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top