Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
MSSQL Stored procedure with output parameter
Migrateduser
<div>Hi all,</div>
<div> </div>
<div>I am using BIRT 3.7.1.</div>
<div> </div>
<div>I have designed a report with one dataset. The dataset is calling a stored procedure with one input and one output parameter.</div>
<div> </div>
<div>When I run the report I get the following error:</div>
<div> </div>
<div>[sharedmedia=core:attachments:11894]</div>
<div> </div>
<div>The procedure returns both a result set and an output parameter. I can successfully preview the result set when I select dataset - preview results. However, preview Output Parameter gives me the same error.</div>
<div> </div>
<div>I have noticed that when I remove the result set from the procedure, I can successfully pass the output parameter to the report. But when both a result set and an output parameter need to be returned, it fails.</div>
<div> </div>
<div>Does anybody have any idea why is this happening? </div>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet