Add BAQ to Table Report?

Kinetic ERP
, , ,
1

I feel like I already know the answer to this, but I’m surprised I don’t see this question anywhere. Is there a way to add BAQ results to, say, the Sales Order?

I have a delimited string representing a 2D array I’m trying to display in a table on a sales order. I can slice it in a BAQ, join it to OrderDtl, and have it return as rows, but I can’t (figure out how to) do that in a regular report RDD. I do not want to recreate the entire sales order as a BAQ RDD/Report, but my current workaround for displaying this data is truly heinous.

Is there a trick to backdoor my data into the report somehow?

2

Not an answer, just that I would like to know if this can be done also. I have tried to do it in the past and never figured out a way. I hate RDD in general, it has too many limitations. (can’t alias tables)

3

Could you do a sub Report using a BAQ report?

4

To my knowledge you cannot BAQs to a system RDD report. As an alternative you can get the data into RDD using linked tables,UDDs etc. and then build the array directly in the SSRS report.

5

If it’s possible, I’d love to know how.

I don’t think it’s possible to add sub reports to built-in Epicor reports at least as a SaaS customer. If I could, I’m not sure how to use a different RDD for the subreport.

6

I have the data in the report as a delimited string and have built the array with VBA. But there’s no way to tie that to a table like a dataset as far as I know. If that’s possible I’d love to know how.

7

We have a few “system” reports that are customised to include subreports whose data source is connected directly to the Epicor SQL db rather than the ‘reports’ database.

It was the only way to access the data required. Put your the BAQ ‘SQL’ into the report dataset definition

Oh in the lands of fairies and unicorns all system reports are based data from multiple BAQs and easily editable…

8

If you are Epicor SaaS - I do not know of any way to add a BAQ to a standard report.

In just free thinking, if you are clever you may be able to use either REST or CDC to offer a second connection to your RDL. I have never done it - but it seems like it would work. Anyone done that before?

DaveO

9

Re: Subreports in system reports: Do you know if that’s possible for SaaS? I have attempted it before and did not have success.

I’ll have to see if I can direct ‘SQL’ into the db. Seems like something they would stop us from doing in SaaS.

10

We are an on-premise Epicor installation, so I couldn’t say.

11

I eventually created a data directive that slices my string to a UD table whenever it is edited on the order, then brought my UD table into the order ack.

This circumvents the need for the BAQ as in the title, but a BAQ could be written to a UD table in the same way if anyone in the future needs a way to handle this problem.