hi all,
is there a way to determine if the chart's recordset is empty?
i have bar chart (based upon a separate query datasource) on a report that displays items waiting approval. if there are no items awaiting approval the chart does not appear and there is a big void space in the report. i'd like to create a label that only appears when the chart's underlying recordset is empty.
something like
If (Me.Chart.HasData = 0) Then
Me.lbl.Visible = True
Else
Me.lbl.Visible = False
End If
Is there an easy way to do this?
I thought about opening the recordset in VBA on the report's OnOpen event and determining the number records from the recordset, but was hoping to find an easier way to do this via a Chart property or something.
many thanks for the help
is there a way to determine if the chart's recordset is empty?
i have bar chart (based upon a separate query datasource) on a report that displays items waiting approval. if there are no items awaiting approval the chart does not appear and there is a big void space in the report. i'd like to create a label that only appears when the chart's underlying recordset is empty.
something like
If (Me.Chart.HasData = 0) Then
Me.lbl.Visible = True
Else
Me.lbl.Visible = False
End If
Is there an easy way to do this?
I thought about opening the recordset in VBA on the report's OnOpen event and determining the number records from the recordset, but was hoping to find an easier way to do this via a Chart property or something.
many thanks for the help
