Conditional subreport

[CTR]

I have a final report that has 5 subreports on it.

I want to suppress one of the subreports based on it's value.

The fianl report is "Donor Summary Report".

If the value of the subreport "Donor loss 56 query" is less than 200 I want it to have some default text instead, say "Not required".

Is this possible?

_____________

Cliff

 

[THWatson]

Cliff
You might try the following approach.

1. Put an extra text box on the report. Let's call it txtNotRequired

2. In the Format event for the Detail section of the report, put something like...

If Me.YourSubreportName.Report!TextBoxNameThatContatinsTheValue < 200 Then
Me.YourSubreportName.Visible = False
Me.txtNotRequired = "Not Required"
Else: Me.rsubBreakdownFoodshelf.Visible = True
Me.txtNotRequired.Visible = False
End If

See if that will do it.

Tom