Hide Subreport if no data and remove the Blank Space

[HIMANSHU]

I have a report which contains 3 subreports. Now I require to do the following:
1. Hide the subreport if there is no data.
2. Remove the Blank space created when the data in subreport is null.

I tried to Set Can Grow and Can Shrink to Yes but still the blank space was not removed.

When I reduced the height of the subreports in the design view the blank space was reduced but it was still there.

What can be done so that the complete report auto adjusts itself if any sub-report is null? Something like the whole page auto fits itself in the available space?

The option of reducing the size of sub report in design view to minimum is there but it makes the report very un-handy for future reference.

 

[DavidG3276]

I am running into the same problem and it's disappointing that HIMANSHU was told to start a new thread in a similar post and then no one responded to him here. I have tried setting the can shrink property to YES and it makes no difference. If anyone has any ideas, I would be very grateful.

 

[DavidG3276]

Boy - do I feel dumb. The shrink option was working but I had a bunch of white space at the top of the report which made it look as if it wasn't. My apologies.

 

[HIMANSHU]

Hi David,

I don't know if they is a set way of doing it but I could remove the blank spaces by a trick.

The can grow and can shrink does not make any difference if the sub report is null as it leaves blank spaces.

So I went to the design view of the main report and reduced the height of each sub report to the least possible and removed all the blank spaces between the sub reports. Now if the sub report value is null the blank space still exists there but its very very thin to be visible. And if the sub report value is not null the can grow expands it.

However there is a draw back. The report becomes very un handy for future reference. But this is the only solution I have found out so far.