Problem with Displaying Data in details & How to get Record Count

[Videla]

Hi All,
I have an ASP.Net page which will pass paramters to Crystal report and based on the parameter passed, Crystal report will show the Output(Records). My problem is, If parameter supplied doesnt fetch/Match rows, My Crystal report shows the Heading part alone. Is it possible to get the Record count so that I can hide Crystal reports from showing to the user with blank details and also i want to hide the whole crystal report view if no rows selected.

Other Details
-------------
Crystal Report Version : XI
ASP.NET ver 1.0

Is there any special fields/variable to know about the record count.

 

[synapsevampire]

Sometimes Crystal will display 0 for the recordnumber when there aren't any rows, this seems to depend upon the dtaabase, which you didn't post.

More often the approach is to check for the existence of a null of a field which can never be null, such as:

isnull({table.primarykeyid})

If that has a null, then you didn't get any rows returned, and you can conditionally unsupperss a section to state that no rows were returned, and display the parameters that were passed as well to help the user resolve.

Also use this to suppress the details, that way they just get a section saying nor rows returned.

Or you can use the File->Report Options->Suppress Printing if no Records.

-k