checking for empty data from within .net

[ratjetoes]

hi,

i want to check if the report has empty data so i can display a custom message instead of showing an empty report.

t.i.a.,
ratjetoes.

 

[cjlarue]

You could execute the sql or stored procedure for the report and then read the result and display the message if no records are returned before calling the report.


Regards
Chuck LaRue
ADRS Computer Services

 

[lbass]

You could use a formula like the following in the report header:

if isnull({table.ID}) then "No Report Results"

...where {table.ID} is a field that recurs with each record.

-LB

 

[FVTrainer]

Alternately, look at this KB article:

http://support.crystaldecisions.com/library/kbase/articles/c2013862.asp

 

[ratjetoes]

hi,

tnx 4 your responses. i like the third option best, but the thing is, i can't find the method???

code:

Me.oRpt = New CrystalDecisions.CrystalReports.Engine.ReportDocument
Me.oRpt.Load(Server.MapPath("reportName.rpt&quot)

According to the article, something like Me.oRpt.ReadRecords should be available. Anyone an idea to what namespace the method belongs?

t.i.a.,
ratjetoes.