How to call stored procedure?

Question

Hi All,

How to call stored procedure while creating input parameter in the report?

Also is there any limitation on passing the values from parent to child report while clicking the hyperlink in the report. Ex: I have parent report which shows the count as hyperlink while selecting the hyperlink i wanna to pass few values to child report query.

Thanks in advance.

Answer 1

Hi prasannag,

  it's not clear if you are talking about Knowage LOV and DRIVER or just report (ie. Birt, Jasper) parameters.

If you want call procedure from Knowage Lov I think it could be able if you can do this within  the standard sql 'select' statement.

For the second question I think you need to define an output parameter for each value that you want pass in cross and then define  a cross navigation through the specific GUI .

You can find more details on Knowage_6.x_CE_Manual.pdf downloadable from OW2 site.

Hope this help!