Selection criteria of canned reports

Epicor ERP 10
1

All –

Is there a place for a non-programmer to see the selection criteria for the canned reports from Epicor? We are testing data loads and the Open Receivers query from our legacy system does not math the Received Not Invoiced Epicor report. Going through each record to try and reverse-engineer the logic is extremely time-consuming.

Thanks for whatever insight you can provide.

—sam

2

Hi Sam,

Do you know how to look at the report data definitions? The system ones tell what tables are used to provide the data. They are under company maintenance / report data definition.
Another thought that could help would be to export the report as crystal .rpt and then look at the data in the report parameters, rptParameter table in the report, Click on fields to browse the passed parameter data.

Hope this helps a bit!
Nancy

3

Thanks, Nancy.

Is the rptParameter table a Crystal thing or is there a corresponding SSRS table. We don’t have Crystal.

4

Hi Sam,

Sorry, yes, the rptParameter table is passed for Crystal reports. We haven’t migrated any to SSRS I’m sorry to say, cannot help with those!

Nancy