.
Using the DataTable to get a report like the one you specified, connect all the labels appearing on the report to constant strings. For instance, for the title of the report, you would make the following connection:
Table1.A1.txt = "System 4-Tk... "
You can make this connection to, say, cell A4 instaed if you want to center the title on the report.
Similarly, connect all other labels to the appropriate cells in the datatable.
Then, connect the variables (for data) to their appropriate cells. For instance, for the first value of SP you would make a connection as follows:
Table1.J2 = SP1
Where "SP1" is the source of your first value of SP. J2 is row 'j' and 2nd column.
When all these connections are done, you basically have a mapping
of your report in the datatable. All you need to do now is Export this as an Excel file. You can either have the user export this with a PushButton connected to the export datamember or you can connect a timer to it for periodic and automatic report generation!
Hope this helps..
Khalid 🙂
.
