M
Margaret D via AccessMonster.com
I searched this site for a solution to printing a subreport even if there is
no data. None of the solutions fit well in my circumstance, so I came up
with this solution:
I left joined in a table to my stored procedure that I knew would always have
a record, and assigned that field to a hidden textbox in the subreport. For
example: the link field is PrsnID, but a record may not always exist in the
subreport view for a particular PrsnID. However, the PrsnID will always
exist in tblPrsn, so I left joined tblPrsn to my subreport view.
The subreport prints, which happens to be a demographic data chart that needs
to be filled in by hand if the data doesn't exist.
I hope this helps someone.
no data. None of the solutions fit well in my circumstance, so I came up
with this solution:
I left joined in a table to my stored procedure that I knew would always have
a record, and assigned that field to a hidden textbox in the subreport. For
example: the link field is PrsnID, but a record may not always exist in the
subreport view for a particular PrsnID. However, the PrsnID will always
exist in tblPrsn, so I left joined tblPrsn to my subreport view.
The subreport prints, which happens to be a demographic data chart that needs
to be filled in by hand if the data doesn't exist.
I hope this helps someone.