Thoughts and Insights around using:
Okay Epicor has the BAQ, BAQ Report Designer, and the converted Crystal Reports into SSRS which is a major process.
In my past I have used the SQL Management Studio, Visual Studio to create SQL Views to drive SSRS reports.
- Are you able to take the views created and import them into a BAQ or do you need to create a new BAQ?
- Can SQL views be used in SSRS reports directly in Epicor and added to a menu for the end user to run?
No. A BAQ adds in security logic to preserve tenant, company, site, and territory security.
There can be some issues with accessing the database directly. This post from the former Epicor/ERP architect explains.
Thank You for the info. I know path forward now
Lots of work.