I have a simple report showing pump name, a simple table related to that pump, and a timeseries chart. I have 10 pumps and have used one parent query and two child queries to populate the data. I have created one tablegroup “Pumps”. I then have it go through each pump pulling data from a database to populate the pump name, table, and chart for each pump one after another.
Everything is populating correctly except the spacing. I can’t fit two pumps on one page unless I make everything alot smaller.
If I increase the overall size of the tablegroup itself it only provides information on the first pump.
If I make the table group smaller information on the second pump starts to show up on the bottom of page 1 and continues on page 2 but thats not what I want.
I have also tried configuring the tablegroup by checking and unchecking both ‘Start on new page’ and ‘New page per row’. I would think having both of those checked would be exactly what I want but does not work. It ends up only showing information for pump 1.
I also tried checking and unchecking ‘Page Break’ under the Options section of the Configure Table section where the Data Key and Grouping is shown.
I am out of ideas…how can I make this work?