Subreports Help Needed from an Expert? (1 Viewer)

[mark curtis]

Anyone,

I have posted this problem many times but still can't solve the problem. I think I need my hand holding through this.

PROBLEM:
I have a report that uses many subforms, which return information by project or tech group or customer etc.

As you can guess sometimes some of the subreports may not have any data for the above criteria.

So I want to hide the whole subreport or at the very least hide the labels for the controls that have no data.

I need to be told where I have to place any code, whether in the main report or sub report.

I hope someone can give me a dig out.

Thanks
Mark

 

[Fornatian]

Mark,

Look at:
"Force a page break in a report if a condition is met" in access help.

This will get you started.

As for the reports, I have a large report similar to yours with an unbound form where users can choose what data to view or not view.

The way I deal with it is to put a conditional if statement in the OnOpen event of the report like:

If Me.MyUnBoundForm.ViewRep1CheckBox = True
Then
Me.Rep1.visible = true
End if

if you wanted to check and see if there were any records to view before viewing I suppose you could do something like creating a recordset clone of the subreports data and conditionally viewing/hiding dependent on whether the recordcount is >0

Ian