I need to create one printing report for all records in section. I set up word report for this section. I set up button, but it makes separated report for every record.
As result i want to get literaly all records from section in my report. What should I do to get this result: ONE common report with all section records
Like
Hi,
Unfortunately, there is no direct way to perform such printing.
However, you can configure this logic using a workaround.
For example, if you want to export all records from the "Invoice" section into a single report, you can follow these steps:
1.Create an "Invoice report" object (optionally, you can create a section for it).
2. In the "Invoice" object, add a lookup column that references "Invoice report" (e.g., UsrInvoiceReport).
3. Create a single record in the "Invoice report" section.
4. Update all Invoice records, setting the UsrInvoiceReport column (from step 2) to the record created in step 3.
5. Create a report based on the "Invoice report" object and add a table section for the "Invoice" object, linking them as follows:
Invoice report.Id = Invoice.UsrInvoiceReportId
This way, you will generate a report that includes all records from the Invoice table, as they all reference the same record.
You can also use this same section for other objects like Document, Order, etc. by repeating steps 2-5.
Hope this helps! Take care! 😊