Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number Records , Displayed at the Report

Status
Not open for further replies.

svagelis

Programmer
May 2, 2001
121
GR
I m using CR4.5 Visual basic 6
Does anyone know how can i detect the number of records that will be displayed at the report before i display it through Active-X Control?
I want to display a msgbox if no record will be returned
thnks
 
The easiest way would be to write an ADO query in VB that mimics your Crystal query with just a SELECT COUNT(*) FROM ... WHERE ...

If you get back 0 from the query, put up the message box and don't run the report. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
(Currently available for consulting in Chicago)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top