We are trying to design a report using data from a relational database. Table 1 contains a Work_Order_ID. Table 2 contains all Codes associated with the Work_Order_ID. Table 3 contains all Technicians associated with the Work_Order_ID. Table 4 contains all Parts associated with the Work_Order_ID…

You will need joins, groups, and depending on the schema, the sql statement for the retrieve may also require subselects. Google any of these topics and you will get some good examples to start from.

You could have your master table results as selectable rows and have the sub tables be results of items selected from the master table maybe driven by any of the action events you seem to choose… onClick? Just an idea…

I figured this might be worth posting, as I assume I’m not the only person in the world who struggles with SQL now and again: I needed to report some basic Work Order data from our maintenance database, and show all involved assets, technicians/time applied, and parts used for each work order. In …

That looks like you have a good solution. You can also use Table Groups in the Reporting module to make data from completely separate datasets show up in one long list. In that case, you would have 3 datasets and each one would join your table1 to each of the other tables. ie SELECT * FROM table1 …

We tried using Table Groups, but ran into the following problem: Col1 Col2 Col3 Col4 data data1 NULL NULL – from table 1 data NULL data2 NULL – from table 2 data NULL NULL data3 – from table 3 Table Grouping on the a…

Using a table group you should be able to get something like this: Col1 Col2 data data1 – from table 1 Col1 Col3 data data2 – from table 2 Col1 Col4 data data3 – from table 3 If that isn’t right, you can always make 5 datasets and use a propertyChange event to mash the 4 together in scripting…

Inductive Automation Forum

Report Design

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled