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
Passing an Integer into a Stored Procedure call
Migrateduser
<p>Hi,</p><p>SQL database</p><p>I've a stored procedure that I can call in a Birt Stored Procedure dataset</p><p>{call proc (2603}</p><p>And, I get the expected data in my preview.</p><p> </p><p>I've a data set with a parameter and one of the resultant columns contains the list of Integers.</p><p>I've a second dataset, with an additional parameter.</p><p> </p><p>When I join these two datasets on a common key and the parameters are processed, the preview will have only one line as the output, and the ID column will have the integer 2603 (say).</p><p> </p><p>How do I pass this resultant output to my stored procedure call please?</p><p> </p><p>Thanks</p>
Find more posts tagged with
Comments
There are no comments yet