BAQ Subqueries (Report Designer)

Kinetic ERP
, , , ,
1

Hi all,

I’m looking for some advice on how best to approach using a BAQ as a subquery within an already BAQ Report. In the BAQ Report Designer it looks like you can only select a single BAQ as the main data source, which is where I’m getting stuck.

My current BAQ (TTEJobComplChk) looks at JobHead joined to Part and JobOper, and this is working as expected, but I now need to bring in related JobMtl data as a separate BAQ/sub report within SSRS.

image
image2432×1152 96.4 KB

Is it possible to link a second BAQ into the report somehow? Do I need to set up parameters in both so I can link them together? How would those be set up so the two BAQs can be linked correctly (for example I’m thinking via JobNum/AssemblySeq)? I appreciate all the guidance or advice. Thanks

2

You can’t add a second BAQ to this type of BAQ Report. The newer way is by creating the RDD and putting the BAQs there, there is a thread here on how to do it via Classic UI and I’ll see if I can find the link.

Another option is to modify the TTEJobComplChk BAQ and add the second BAQ as a reference. Adding a BAQ to a BAQ.

1 Like