/ReportEngine

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

ReportEngine

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

  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.