Hive Minds.....
I am having trouble converting a MS Access report into Ignition. I have tried several of the nesting options and cannot get it to come out right. I have grouped just about everything in every order possible. Below is the table I need to recreate and the MSAccess equations use to get them. I only need the "Bar Loaded" Status for each of the Production Hours. There are a lot of other Status markers that I do not need. I have the Data source all set up, but the formatting of the table is throwing me off. What am I missing. Thanks for the help.
What I need to look like.
The MS Access Info in the Background
The Report Data
Maybe a better question... is there a way for me to just pull the Bar Loaded information like Access above? I cannot find anything in IU about only using specific criteria from a data source?
OR would just setting up the "parameter" in the stored procedure of the SQL code be a more elegant option?