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, …

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 = […

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

Thanks so much. I was able to get the data displaying how I wanted. [image] [image] I’m trying to add a graph at the bottom using the @AvgPct@ from my list, but it’s showing two data points for each X 1-19 on the chart. One is for item1 (Mushrooms) and the other is for item2 (Onions). I have …

In my experience, I always have a separate data source for charts to make sure it gets the exact data and format it needs to render the way I want. Review the dataset structuring needed for the chart in the user manual carefully.

I already have a second data source but I’ve having trouble getting just the data for the current page. I thought I would have been able to grab data from the first datasource for a filter value for the next. [image] I can test it by manually entering a string into the selected_item value. But …

I don’t think you can filter the data source this way. I think you’ll need to remove the ChartData source and add it as a nested query to AllItems. What this will do is run the ChartData query once per key in the parent query, which should do the filtering that you want. Nested Queries | Ignition…

Alright, I’ll try that. Thank you.

There’s no reason it has to be collected all in one query. I just did one query and grabbed all the data did null checking and percentage calculating all in the SQL query. I guess I don’t know a better way. I guess I’m still trying to understand how everything is linked in the report.

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

Ignition

pturmel September 2, 2025, 1:27pm 9

If there are DB performance reasons to collect all the chart data in one query, consider constructing the required nesting in a script data source. Like so: