At Dumaco, producing a report for an order meant opening Crystal Reports, choosing the template, entering the order and job order number, finding the matching material certificates on a shared drive, merging everything into one PDF, and uploading the result into Ridder. This library does those steps from code, so any of Dumaco's internal tools can produce and file a report with a single call.
From an order number to a report filed in Ridder.
The library opens an existing report template, connects it to the ERP database, filters it to the order and job order, and saves the result as PDF, Excel or RTF. Where someone needs to choose, a small dialog lists the report variants and output formats, so the operator does not have to work in Crystal Reports itself.
A material report for production has to come with the certificates for the material used. The library runs the summary report, looks up each material batch on the job in the ERP database, and finds the certificate filed against it. The summary and the certificates are merged into one PDF, or saved as separate files next to each other if that is preferred.
The finished document is then filed in Ridder. A report is filed against the job order, a drawing against a specific work activity with the right document code, or one document against both. The connection to Ridder is opened for each filing and closed afterwards.
When a report has to go to a customer, a supplier or quality control, the library opens an Outlook draft with the recipients, subject, text and attachments filled in. The operator checks it and sends it from Outlook, so the email is kept in their sent items with their signature.
The library has no interface of its own. The drawing exporter, the bending automation and several smaller tools at Dumaco call it when they need a report or have to file a document. The database queries, credentials and Ridder connection are in one place, so a change to the database or a new report variant is made once for all of those tools.