An application written in C# is passing parameters to a stored proc and it's returning an XML recordset.

 

If one of the checkboxes is checked I apply a filter in Crystal to show only those records with a difference > 0. If in the recorset all records have difference = 0 I'd like to display a message that says [No Data Found].

 

Usually I create two "Details" sections. One is to display records (when available) the other one is to display a message when no records are available.

 

The details section with [No Data Found] has a formula which suppresses the section when: Not IsNull({xxx.xxx}).

 

this solution works when the filtering is done in the database or middle-tier.

 

I believe that in this case the formula is not working for Crystal sees that the recorset is not empty

.

How can I handle this issue?

 

thanks so much for your help.