Getting Record Count from Crystal Report 1

[syerin]

Hi,

I'm currently running CR 8.5 and using visual basic to access the database in my report via LogOnServer method. I need to find out whether the recordsets are empty and if so, display a msgbox informing the user about it. I tried the following but the number of records returned wasn't correct.

Dim crxPgEngine As CRAXDRT.PageEngine
Set crxPgEngine = Report1.PageEngine
MsgBox CStr(Report1.PrintingStatus.NumberOfRecordRead), , "recordsread"

Can anyone help? Any help is greatly appreciated. Thanks.

cheerios.

 

[balves]

Why not just take the query from the main report and execute it in VB before you get to Crystal, just changing the SELECT field,... to SELECT COUNT(*) FROM ...

If the record count is zero, then display the message, otherwise execute the Crystal report.

 

[syerin]

Hi Balves,

thanks for your help Really appreciate it.