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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.