Subreport Visible 1

[naturalsn]

Good Monring

I hope someone could possibly assist.

I have a report that I am generating with 1 subreports embedded in it. When the subreport has no data , the subreport does not show when I run the main report.

Now i know i need data to display the report.

But at some stages the report will be printed without any data to allow the user to complete it, and will then be completed in the DB. Is there a way that i can display the subreport to be displayed, regardless if there is underlying data or not.

Thank you very much in advance

Regards
Sn

 

[dhookom]

If there is no data, the subreport will not display. You could create another subreport with a similar format that could be printed in the main report to allow the user to complete it. Use code in the On Format event of the main report section to set the second subreport visible or invisible based on the original subreport having data.

Me.subrptSecond.Visible = (Not Me.subrptOriginal.Report.HasData)

Duane
Hook'D on Access
MS Access MVP

 

[naturalsn]

Absolutely Perfect.

Thank you very much