What is the proper way to format query data for Report Tables?

[Kyle_Latzke]

I have an SQL query, it grabs all the daily test data from all the test lines for a date. The query works and grabs all the data I need, I can even get it on a Report in chronlogical order.

shiftdate,
time_produced,
TLC,
BLC,
linecode,
InitialWgt1,
InitialWgt2,
EndWgt1,
EndWgt2,
AvgWgt1,
AvgWgt2

I’m not pulling from multiple databases, all the data I need is there from one query.

I need to take the data and split the data from the selected date into reports grouped by TLC, then split the TLC into pages for each different item and have them in pdf or printable format

This would be an example of the data grabbed from the database:
All the reports would be for the selected date.
Date 8/28/25

There would be a report just for this TLC but split up into pages for each subItem. So 2 pages.
TLC: G5BE013A
ITEM:1
SUBITEM:A
time_produced
WGT1:60
WGT2:80
WGT3:95
WGT1_INSPEC:0
WGT2_INSPEC:1
WGT3_INSPEC:1
...
ITEM:1
SUBITEM:B
time_produced
WGT1:143
WGT2:216
WGT1_INSPEC:1
WGT2_INSPEC:1
...
ITEM:2
time_produced
WGT1:83
WGT2:116
WGT1_INSPEC:1
WGT2_INSPEC:1
...

It would look like this but separated by TLC, then by item.

Right now they’re all listed one after another. The “Time Produced” 2350 enteries are sub items from one item.

I’ve watched the videos on Table Header, Details, and Summary Rows Video at Inductive University

It feels like maybe Dataset Grouping or Table Grouping - Child Table videos were the closest to what I need but all my data is already grouped into one dataset.

This seems like it should be relatively easy and I’m missing something if I could get some help. Thanks.

[dkhayes117]

I threw this together to get you started. It may not be exactly what you want, but again , just to get you started.

Using a scripted data source in the report:

	
	headers = [
		'shiftdate',
		'time_produced',
		'TLC',
		'BLC',
		'linecode',
		'InitialWgt1',
		'EndWgt1',
		'AvgWgt1'
	]
	
	rows = [
		['8/28/2025','04:00:00','G5BE013A','1','A',60,80,70],
		['8/28/2025','04:15:00','G5BE013A','1','B',140,160,150],
		['8/28/2025','04:30:00','G5BE013A','2','A',140,160,150]
	]
	
	data['dataIn'] = system.dataset.toDataSet(headers, rows)

Here is the page layout

grouping below, dataIn has Header and Details the rest just Details checked. For the BLC grouping, Page Break is selected.

Result:

page 1

page 2

[Kyle_Latzke]

Wow thank you for the great response. I’ll try it out!