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

 

Agile User Asked 7 days ago in Product Collaboration.
Add Comment
4 Answer(s)

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

Agile Talent Answered 4 days ago.
Add Comment

Not an ootb report.

Agile Angel Answered 3 days ago.
Add Comment

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

http://myagileplm.com/question/query-to-fetch-bom-upto-nth-level/

http://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

Agile Angel Answered 3 days ago.
Add Comment

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

Agile Professional Answered 2 days ago.

Yes Raj.

IProductReport  exists in previous versions as well.

 

Regards,

Karthik

2 days ago.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.