Getting the no of records read from ASP

[mukhbens]

hi,
Is there a way to find out how many records have been fetched by the crystal report after passing the selection formula.
Actually I want to show the report only if there is data. otherwise I want to display only a message stating "no data found".
I want to export the report only if there is data.
I want to do all this from ASP.
have a look at the following code....

<%
session(&quot;oRpt&quot.recordselectionformula = SelectionFrmla
if (&quot;there is data&quot then
'Export the report in excel.
else
response.write (&quot;No data Found&quot
%>
thanking u in advance...
--Mukhben

 

[dcm]

Mukhben: You can use the following:

Report.PrintingStatus.NumberOfRecordSelected to enable you to do what you want.

Hope this helps David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[mukhbens]

Dear dcm,
I am sorry but I am not an expert at crystal reports.
Could u please be more elaborate?
what do u mean when u say
Report.PrintingStatus.NumberOfRecordSelected

I mean where do u set this? In ASP or in the rpt file?
Could u please tell me the exact syntax.
Thanks a lot.
--Mukhben