My XI rpt accesses an SP to retrieve the data set.
I need to suppress a detail line if there are no rows returned from the SP.
This detail line contains a text field from the SP, and an inserted box.
When there is no return from the SP, I still get the detail line with the box, even though I use Section Expert : Suppress (No drill down), and set a formula to suppress the line if isnull(text). This is obviously insufficient for when there are no rows.

Can I setup a formula that will store the number of rows from the SP, so that I can test against a value of zero ?

Or is there a better way to achieve what I need ?

Many thanks