We have a current report that has a condition to exclude under a certain condition and I am needing to delete that condition to allow all entries. I am new to epicor integrated with ssrs so am in need of some direction on where the logic is located. I am used to conditions being written directly in the sql code and using a direct query for ssrs reports to modify conditions and parameters ect. Where would I find the logic in epicor that is excluding certain entries for an ssrs report?
A report in E10 roughly follow the following flow:
-
Temp tables are created based on the Report’s RDD or BAQ. These hold the records that satisfy the RDD’s logic (table relationships, table criteria, prompt sets, etc…), or the BAQ’s (table relationships, criteria, BAQ Report options, etc…)
a. RDD reports typically, name temp tables based on the data sources or logic hidden in the RDD’s functionality. They’ll all have the same_<GUID>suffix.
b. BAQ Reports usuall just create temp tables named BAQReportResults_<GUID>, BAQReportParams_<GUID> -
The RDL has a query expression to create datasets based on the above temp tables.
The temp tables are in a DB specified in the App Configuration done in the EAC (Epicor Admin Console).
2 Likes