Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Issue with Stored Procedure
shilpibh
<p>Hi</p>
<p> </p>
<p>I have designed a report in Birt <span style="font-size:12px;">Version: 3.7.1 and database in MSsql 2008.This report is calling a stored procedure which is writing data in temp table and getting</span><span style="font-size:12px;"> data from temp as output. and this output is being used in fetch of data set in report.This works absolutely fine.</span></p>
<p> </p>
<p><span style="font-size:12px;">Now I have another report using the same method to get data but that stored procedure works in database but not in Birt . In Birt it opens data set and calls exec SP (parameters) but then fails in fetch.</span></p>
<p><span style="font-size:12px;">is it that this version has some restictions in calling complex stored procedure?</span></p>
<p> </p>
<p><span style="font-size:12px;">Regards</span></p>
<p><span style="font-size:12px;">Shilpi
Find more posts tagged with
Comments
JFreeman
<p>Are you receiving any errors when the failure occurs?</p>