[RESOLVED] Stopping a Crystal Report using VB6 when there is no data

[kevchadders]

Hi,

I am building a SQL formula dynamically to pass to Crystal Reports RecordSelectionFormula property so that i can generate a report with different criteria.

This means that occasionally the search criteria will return nothing. So instead of getting back a blank report with just the column headings showing, is there a quick way to check to see if there is any data being passed back to the crystal report so that i can intercept this in code and hide the report from being shown to the user.

I am aware of a event called NoData, which seems perfect for this but i cannot seem to be able to access it in VB6. (Grrrr)

Its Friday, so maybe i'm missing something obvious here!

Any help would be appreciated on how to do this or a piece of code on how to trap the NoData event in VB6 as i cant seem to do it!