Using stored procedure output parameters to hide report elements

I'm attempting to hide one of two grids on a report depending on the outcome of a stored procedure call (boolean parameter). I know the output parameter is available as I've dropped a Data element within a table row and bound it to the output parameter. It's value is seen when previewing the report. 
 
However, I'd like to use that boolean value to alternately hide either grid/table. But when I add the following express to the table's visibility: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (outputParams["dspStatus"] {
true
} else {
false
}'
</pre>
 
I get the following error: 
ReferenceError: "outputParams" is not defined 
 
How can I reference the resulting stored procedure output parameter to control the visibility of the table or other report elements? 
 
Daron

Find more posts tagged with

Comments

mwilliams

Hi Daron,

If you've used it to drop a data element, couldn't you drop the table in the same fashion? Where are you accessing the parameter when you drop the data element?

canutri

I've figured it out. The outputParam is bound to the dataset as an entirely new Row value. All I had to do was use the name assigned in the dataset. It's kind of weird to think that the output parameter would become part of the the dataset itself.

Thanks

mwilliams

Glad you figured it out. Let us know whenever you have questions!

dchillman

<blockquote class='ipsBlockquote' data-author="'canutri'" data-cid="66417" data-time="1279117176" data-date="14 July 2010 - 07:19 AM">
I've figured it out. The outputParam is bound to the dataset as an entirely new Row value. All I had to do was use the name assigned in the dataset. It's kind of weird to think that the output parameter would become part of the the dataset itself. 
 
Thanks </blockquote>
 
Hi, 
can you post how you set up the dataset? i'm struggling mightily to get a dataset from a sql stored procedure that has both input and output parameters. 
thanks