In pre-viewing the report I was able to see my text object field and a '0' (zero) printing for for the MarketValue field . Strangely, when I tried to pre-view the main report, this MarketValue field was suppressed and but the text object field shows up. I tried a few more test and found that if there is a number other than 0 then the field shows itself. I have checked the fields format and the "suppress if zero" is unchecked.

 

subreport  preview                main report preview

(eg 1)

------------------------                -------------------------------------

MarketValue       0                  Market Value                     

------------------------                -------------------------------------

 

(eg 2)

 

 

The link between the reports were fine, but you were right, there was no record therefore the result was not displaying. I have tried to use

 if(isnull(field)) then

    formula = 0

 else

    formula = sum(field)

 end if

 

Assuming that it will be 0 if there is no result, but it doesn't seem to work because its still showing blank. Is there another way to find out if the SP returns no records?

 

I have ordered the book but its taking its time on the roads. :)

 

Thanks, 

Is there a simpler way of finding out if a Store Procedure is returning a record?

 

It would be easier if I was able to control the backend of the report, but because a third party is supporting this, I would just need to check if the SP is returning any record in the front end.  

 

Thanks,