AnsweredAssumed Answered

How can I use stored procedure in jasperreport of UR server

Question asked by dokyun on Sep 3, 2015

Hello~~

 

How can I use stored procedure in jasperreport of UR server

 

I used MSSQL DB and created stored procedure

and then wrote query in jasper report (ireport)

 

1. main query

캡처_2015_09_03_15_36_52_564.jpg

 

 

2. data set query (CPU Usage)

 

캡처_2015_09_03_15_47_36_237.jpg

 

3. Preview (Success)

캡처_2015_09_03_15_37_44_324.jpg

 

4. But occured Error - Error occured. Ask system administrator (6632)

캡처_2015_09_03_15_38_42_950.jpg

 

 

 

As you saw in the picture, Preview success using stored procedure in jasper report

But fail UMP - Unified Report

 

why...??

 

How can I use stored procedure in jasperreport of UR server?

Please Help me

 

Thanks in advance

Outcomes