How Can I combine 2 BAQ Query Epicor Into 1 SSRS Report

Hi, All

First I will explain the case that I experienced when I made a report in ssrs, when I used the baq report in epicor why I could only use one dataset when in ssrs . Even though I want to make a different query from one table to another. Is there a way to create new queries in different baqs to be combined in one report? Please help so I can combine 2 different baq into one report.


Thanks a lot,
I hope someone will help and answer my questions

Just make a RDD with the two BAQs and you are off to the races

2 Likes

can you show me step by step that way ,please ?

You should check out EpicWeb. Look at the Documentation section. There are tons of PDFs with useful reference information. There is a User Guide called EpicorERPImplementation. Look at the Report Data Definitions chapter. That should get you pretty close. Post back with any specific questions!
https://epicweb.epicor.com/doc/Docs/EpicorERPImplementation_UserGuide_102700.pdf
(You will need an EpicWeb Login for this link!)
Good Luck!
Nate

4 Likes

Take a look at KB0114676 on Epicare, that gives a good example also.

1 Like