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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.