ReportEngine

Example of Rerx, ReSQL, Xtra, XML and Unit4 Report Engine reports and code

0. AllARWFiles
   All the standard ARW files in Unit4.

1. CreateFakeJSONFiles
   This created a "fake" JSON file.

2. DataExtraction
   Different ways o exporting data from U4.

3. DataExtractionMethods
   Different ways o exporting data from U4. Simplist.

4. SplitReportsDifferentLayouts
   This shows how to have two different files being used. From the on data file.

5. PasswordsExcel
   This will put a password on an excel sheet when it has been run.

6. PasswordsXtra
   This will put a password on an PDF (via Xtra) report when it has been run.

7. XmlOutput
   Outputs a XML file.

8. IcsExport
   Output a ICS for a view.

9. SplitReportDiffOutputSameFileType
   Splits report on attrubute. Has different layouts per attrubite.

10. TxtExport
    Output file as a Txt file.

11. GetDocumentFromArchive
    Gets document from the document archive.

12. WorderatorMailMerge
    Uses Word to do mail merges.

13. CreateCsvAndTextFiles
    Outputs files to Txt and Csv.

14. DataSourcesSQLlite
    SQL Lite output database.

15. MultiIf
    Example showing how paramaters work with IF statements.

16. FixedWidthGrouping
    Shows an example of a BACS file with groupings.

17. DifferentFilesStructures
    Show three txt files being created and with different data Structures within them.

18. MultiReportDifferentTypes
    Different files exporting in one report. Files are PDF, XLSX, XML and DOCX file.

19. DataDictionary
    Downloads and formats the tables structure of Unit4 ERP.

20. BrandedEmailing
    File produces the HTML to create a well-branded email for you customers/suppliers etc.

21. DataExport
    This shows how to place files into the Unit4 ERP data export folder.

22. MultiDifferentFilesColumns
    Show's an export to csv. Each file has a differnt data structure.

23. FlexiFieldsviaLoop
    Shows how to loop over data and get Flexi-Field data.

24. InListQuery
    Shows how to create a inlist query using server report spaced with commas.

25. PDFContent
    Shows how you can embed PDF files for the document archive within Xtra report. Think T&Cs.

26. RowCounterAddColumn
    Adds a new row counter using the $$rowcounter command.

27. CloudDatabaseSize
    Show the database size in MB of any system.

28. CB10AllReports
    All the CB10 reports made in to one PDF output.

29. Bookmarks-TOC
    Example file using bookmarks/TOC in a Xtra file.