Skip to main content

need to extract excel format from ifs pdf file 

Hi,

IFS application supports multiple layouts for operational reports. But as a standard, the Product Development Team currently  provides the Report Designer layout and the output as a PDF file.

If there is a requirement to use Excel as the output file, you will need to create your own report plugin layout. Please refer the below documentation section for additional information regarding the report plugins.

Foundation1 / Development Guide / Operational Reporting / Using Report Plugins / This page

Or else, you could use Crystal Reports for this purpose.

Another manual workaround available for this requirement is, using the below query to extract data in a SQL tool and then exporting to an Excel sheet.

select * from <report_id> where result_key = <result_key> 

 


In addition to Sachin suggestion by using sql query select * from <report_id> where result_key = <result_key>. 

You can use this query as quick report and replace the <result_key> with &result_key. This will allow a prompt to user to enter the report_id.

You can find out the report id in ‘Report Archive’ screen.