Saturday, February 25, 2012

Delete subreport at runtime?

Is it possible to delete a subreport from a main form at run time? I am trying to find a work around for the inability to conditionaly format a page break.

I have a main form that has 10 subforms. Some of the subforms won't have any data (depending on the parameter values). When I export the main form to excel each subform needs to be in it's own excel tab. Obviously, I don't want a tab if there is no data.

Any suggestions?

Did you try setting the "NoRows" property on the subreport reportitem in the main report to e.g. =" " (one blank)

-- Robert

|||

Setting the no rows property to " " (one blank space) still brings back a blank page for that subreport.

No comments:

Post a Comment