Friends, I have a report with subreports eight, but sometimes, some sub has no data. Are getting blank pages
prints how do I fix?
Thank you.
Friends, I have a report with subreports eight, but sometimes, some sub has no data. Are getting blank pages
prints how do I fix?
Thank you.
Google: Access VBA report no data don't print page
Maybe this will help: http://bytes.com/topic/access/answer...ble-subreports
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks for responding and helping. I had earlier in trying to google.
Put yes to can can expand and shrink,
for all sections of all subreports also placed time zero for all subreports.
In the event when loading the subreport I repeat this code for each sub:
Then if Me.Filho0.Report.HasData
Me.Filho0.Visible = True
else
Me.Filho0.Visible = False
end If
In the event if you are not given for each sub I put:
cancel = True
As I open the report it is all empty, but when I print, it prints perfectly,
if the subtree is not show no data
and also the sub fully expand.
Only when I open'm not seeing anything.
Thank you.
thank you for your help, Sorry for being slow to respond, I was without internet.
I was able to partially resolve. I put a button on the form to open the report.
Thus, it opens directly in Print Preview, subreports showing correctly and also printing correctly.
Again, thank you.