Monday, March 19, 2012

Displaying RowCount from DataSet in Report TextBox

What is the expression for displaying the rowcount from a dataset in a textbox report item?

On a related note, if how can I access the error code I am sending back from Stored Proc using Return statement, to show up in a text box on report?

.. uspSomeStoredProc...

If error occured

Return -1

elseif some other error

Return 1

else

Return 0

End

Is there a way to display that? In general, how can the values that are returned by stored procs such as RowsAffected or some err code using RETURN or Output Variable be accessed in report? I don't see any properties exposed by datasets in the expression window for doing that.

Any input on this will be appreciated.

Thanks.

|||Any one? Any suggestions or input on this?

No comments:

Post a Comment