
August 6th, 2004, 08:42 AM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Does CanShrink not work for a subreport having a bound record?
Hi,
I have a subreport that contains several subreports. I don't want the overall subreport to display unless one or more of the contained subreports has data. The contained subreports are each based on their own queries, and the top level subreport is just used to show the headers and the totals.
What I did was base the top level subreport on a query that would *always* have data, and then implement the OnFormat event such that it calls 'SELECT COUNT(*)' queries to determine if any of the contained subreports have data. If one or more of them do, the top level subreport is set Visible=True, otherwise it is set Visible=False.
The problem I am seeing is that even though the top level subreport is hidden (Visible = False), there is still whitespace left in the main report for that subreport. I have checked *every single* place where CanShrink should be set TRUE, and that all checks out okay.
So, does CanShrink *not* work for a bound subreport when
that subreport has data?
TIA,
-jeff
|