Reports
Hi
Is there any way to call ootb report from an external web app?
We have a requirement where the users want an external web app, connected to dB which fetches the where used report.
Any idea how the reports are stored in the DB?
May be if we can find them in DB, we can reuse them.
Thanks
KE
Hi KE,
The OOTB reports can’t be called using Web-Apps. Over the period of last few years i have seen similar demands from PLM user base.
As Karthik said, the way to go about that is formatting sql query for the reports like Where-Used and BOM-Explosions etc. for single or multiple input. On how to format these reports you can follow the following threads
https://myagileplm.com/question/query-to-fetch-bom-upto-nth-level/
https://myagileplm.com/question/sql-query-to-get-where-used-upto-nth-level/
Also, i would suggest you to write a stored procedure to utilize these report outputs as per your needs.
Regards,
Arif
Hi KE,
One possible way to handle the request is by building SQL Query to fetch the Nth Level where used data ,format it and generate the Report in the required format.
Thanks,
Karthik
Hello
Starting in 936, SDK provides IProductReport which has support for BOM Comparison and BOM Explosion. For others, SQL would be the way to go
– Raj
