In order to report data in Tabidoo, it is necessary to create individual reports that you will use further. Thanks to a simple extension, you can prepare reports regularly and without much effort.
Our tip: You can use reporting, for example, to easily create invoices from orders. All you need to do is to set the parameters once and then use them for all tables.
For reporting, you will need to get a Reporting system extension from Tabidoo extensions.
In the section "Basic":
In the section "Designer":
In this section, you can prepare your reports. You can find detailed help to it on the website of the publisher of the Stimulsoft software we use.
Want to create an invoice in Tabidoo? Click HERE and follow the easy steps.
In the "After load" tab, there is a place for user script, which is called after load/before rendering the report.
It enables to change or adjust the data which are sent to report.
You are able to change values, reformat them, add columns or tables or even completely change the data source.
In case you do not see the option, you may have an older version of the Reporting extension. Please, choose Add new table. Choose the option Import from templates. Import the Reporting system again into the application. The current Reporting system will be updated.
The data can be found in doo.report.current.data
. Apart from using the data, you can also use or set the report name using property doo.report.current.name
.
Scripting intellisense for doo.report.current works after the data is loaded (e. g. you go to Designer first). When using this property, the table(s) or data source(s) used for the report will be suggested. Please, be mindful, that the data to the report are loaded as an array, so before specifying a property, you have to select from which row are the properties going to be used.
You can see below an example how to set your report name. Either you can set a fixed name, or you can use a dynamic name based on some value in your report. If the name of your table is not one word, you may have to use bracket notation.
doo.report.current.name = doo.report.current.data.Invoice[0]?.InvoiceNumber;
doo.report.current.name = doo.report.current.data["Incoming invoices"][0]?.InvoiceNumber
doo.report.current.name = 'Incoming invoice.pdf';
If you create reports according to the previous steps, you can then easily view, print, or save them.