Re: [birt-report-designer-dev] Generate report from StoredProcedure/Func

["Kranti Parisa" <kranti.parisa@xxxxxxxxx>]

Hi,

 

Happy to see someone replying to my post.

I am using birt-report-designer-all-in-one-2.1.2 version.

 

Will it work with stored procedures?

 

Why i need to use them is, say for example i have 2 tables one is transaction table another is price master table.

what i need to do is, generate a report with that transaction details and an additional column with the price. but the price should come from another table which is based on the record i am going to get from transaction table.

 

Hope it gives some description of my problem.

 

Please suggest

 

On 4/10/07, Lin Zhu <lzhu@xxxxxxxxxxx> wrote:

Hi,

 

Which version of BIRT are you using? BIRT support store procedure ref cursor only after 2.2M4.

 

For output parameter, you can simply use them in report by using _javascript_ object outputParams["paramName"]. For ref cursor, you can use them as ordinary data set.

 

Thanks.

Lin

 

---

From: birt-report-designer-dev-bounces@xxxxxxxxxxx [mailto:birt-report-designer-dev-bounces@xxxxxxxxxxx ] On Behalf Of Kranti Parisa
Sent: Tuesday, April 10, 2007 5:51 PM
To: birt-report-designer-dev@xxxxxxxxxxx
Subject: [birt-report-designer-dev] Generate report from StoredProcedure/Function

 

 

Hi,

 

I am able to design reports with simple SQL queries. but not able to find any information related to reports based on stored procedures. means the stored procedure is returning cursors or some other OUT parameters then how can we render them into the report.

 

Please  suggest something.

Thanks in advance
--
------------------
Best Regards
Kranti

 

_______________________________________________
birt-report-designer-dev mailing list
birt-report-designer-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/birt-report-designer-dev

-- 
------------------
Best Regards
Kranti Kiran Kumar Parisa
Mobile: +91 - 9849 - 625 - 625             +91 - 9391 - 438 - 738