I am a bit confused with report preparation, and need some help.
My report must have information for 8 machines: 4 columns: Machine Nr., Batch, Output (SQL query) and Working Minutes (SQL query). I have to use Table, since it can be exported to excel file. At first I tried to fit all the info in a single Table. It did not work. Then I tried with 8 different tables:
The preview it looks like:
The big space I have left between the rows is due to the fact that sometimes the batch SQL query may return more than 1 row (if only one row is left in the Table, Designer crashes).
So, briefly, the exported excel file does not seem nice and easy for further data manipulation.
Which is the proper approach in this case?