DX Unified Infrastructure Management

  • Private Community
Back to discussions
Expand all | Collapse all

How can I use stored procedure in jasperreport of UR server

  • 1.  How can I use stored procedure in jasperreport of UR server

    Posted Sep 03, 2015 02:53 AM

    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