Focal Point
[CLOSED] Is it possible to convert the Stored proc into Webfocus Report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6017002576

March 19, 2015, 04:02 AM
Sujata Udgata
[CLOSED] Is it possible to convert the Stored proc into Webfocus Report
Hi,
Can anybody let me know if it is possible to directly using/converting stored procedures into web focus reports which is somewhat similar to report migration from SSRS to Webfocus.

Thanks in advance.

Regards,
Sujata

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6
Windows, All Outputs
March 19, 2015, 05:27 AM
Avinash
quote:
Hi,
Can anybody let me know if it is possible to directly using/converting stored procedures into web focus reports which is somewhat similar to report migration from SSRS to Webfocus.


Yes, You can use , After creating the Synonym of your stored procedures.


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
March 19, 2015, 06:06 AM
Sujata Udgata
Hi Avinash,
Thank you for your quick response. Can you please elaborate on this or can you please provide me some web links for reference.

Regards,
Sujata


WebFOCUS 7.6
Windows, All Outputs
March 19, 2015, 06:38 AM
Avinash
I used below way to use stored procedure of SQL server and Oracle database.

Select the configured adapter from 8121 port, right click on that-> create synonym-> select 'stored procedure' form 'Restrict object type section to' -> choose your database ->apply filter if needed -> click next -> select your SP click next-> Add default input value and click create synonym. After creating this synonym , You can use this as a report synonym applying with where filter.

I am hoping that this will work for you.


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs