Hello,
just want to know if in the BAQ report, can I add multiple datasets.
thanks,
Eddy
No, not really. You would have to use Report Data Definitions and a Report Style.
Have not tried it yet but in 2023.2 CR - It should allow us to add other BAQ’s in the BAQ. So maybe with some subqueries you might be able to as log as you can join them.
no, at the end this is only query result as before
If you’re on prem you can add a second data source + dataset from SSRS hitting your Epicor Kinetic DB directly… I try to avoid this for security + maintenance reasons but it can come in very handy in a pinch.
Hello,
my solution is I create a BAQ. this BAQ is considered as Raw data. no any group by no any pivot or subquery no string_agg.
then i download the report from BAQ designer and in the SSRS report builder, I just use the same data source and create multiple dataset for my report. it runs well. i am happy.
by the way, it is a complicate report. just give you a example.
we need display 10 rows from the jobmtl for each workorder, if jobmtl only return 6 rows, I need fill in blank rows for the rest. how do you do in the BAQ? almost no way.
regards,
Eddy
regards,
Eddy
Maybe you could union the JobMtl result with ten empty rows and then take the top 10? 
I don’t have the bandwidth to try it but it’s something to try.
1 Like
Hello,
Union is not working, if union, 6+10, we have 16 rows.
all i need is 4 empty rows. you need union 4 rows. and the number is dynamic. how you decide in BAQ?
Regards,
Eddy
Use TOP in your subquery