By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,237 Members | 1,162 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,237 IT Pros & Developers. It's quick & easy.

blank page when subreport is no data

P: 18
I have a main report which it has two subreports (rpt_pyrovola & rpt_fysiggia). When I run the main report and fill the parameter id with 1, then it gives me a blank page for the subreport(rpt_pyrovola is no data). So, I dont know how can remove the blank page.
Thank in advance.
P.S.: I have tried to change the cangrow and canshrink fields:yes but nothing happens.
Attached Files
File Type: zip db_automdoc.zip (338.4 KB, 44 views)
Jun 17 '14 #1

✓ answered by twinnyfo

freedemi,

What is the size of your subreport on your main report? If you establish a set size for your subreport, even if it has not data, that much report space will be taken up.

What I have done on some of my reports which have subreport data that may or may not be there, I set the height of the subreport to 0 (essentially shrink the height to nothing) and then set the CanGrow property to True, so that the subreport will use up only as much space as it requires (if it has data).

Try that and let us know what happens.

Hope this hepps!

Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,482
freedemi,

What is the size of your subreport on your main report? If you establish a set size for your subreport, even if it has not data, that much report space will be taken up.

What I have done on some of my reports which have subreport data that may or may not be there, I set the height of the subreport to 0 (essentially shrink the height to nothing) and then set the CanGrow property to True, so that the subreport will use up only as much space as it requires (if it has data).

Try that and let us know what happens.

Hope this hepps!
Jun 17 '14 #2

P: 18
Twinnyfo, thanks for your answer. Can you tell me how can set the subreports height to zero, so as try it.
Jun 17 '14 #3

twinnyfo
Expert Mod 2.5K+
P: 3,482
Simply resize it on your main form. Or, when you are editing your main form, click on the Subreport, and set its height to 0 in the properties dialog.
Jun 17 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.