Standard Epicor Report Parameters to SSRS Output

[BA-Quest (Bill Anthony)]

Might anyone know of a way to capture a report parameter from a STANDARD, out-of-the-box Epicor report so that it can be used in the final SSRS output?

Specifically, I am interested in a single checkbox parameter on the print dialog for the Cycle Count “Print Tags” report (see below):

Keep in mind, this is not a “BAQ Report” and there is no intention of building a “BAQ Report”. I am merely interested in seeing if there is a method for capturing parameter values from standard Epicor report dialog.

If this were a “BAQ Report”, the report parameter in this case might be:

• (Fields!Check01.Value, “BAQReportParameter”) or…
• (Fields!Check02.Value, “BAQReportParameter”)

However, in the case of a standard Epicor report dialog window, I don’t see where I might be able to reference a parameter value that exists there.

Can this be accomplished?

[bordway (Bruce Ordway)]

I wonder if this thread might apply?

How do I pass CallContextBPMData.Number01 to SSRS report?

Yeah, they won’t be listed (any place useful***), you just have to know they exist and then do the setup. i.e. insert into dataset expression(s) in your SSRS report Note per user comment in another, related thread, these may not be available on some of the earlier versions of E10. I’m not sure when they were added, can only verify they will work on 10.1.6 *** You can verify they exist if you browse the tables in the SSRS Query Designer [image]

i.e. if you look at the RptParameter_GUID… instead of CallContextBPMData_GUID?

[BA-Quest (Bill Anthony)]

Reading up on that thread now, @bordway. Thank you!

[BA-Quest (Bill Anthony)]

@bordway

i.e. if you look at the RptParameter_GUID… instead of CallContextBPMData_GUID?

Bruce - this was exactly what I needed.

I added in the left outer join to the “RptParameter” table and was able to pull in the “PrintBarCodes” field, like so:

Then, I simply referenced that field to [in my particular case] show, or hide Excel columns that contained barcodes, based on that report parameter selection.

When a user selects “Print Bar Codes”, the output looks like this:

When a user unchecks “Print Bar Codes”, the output looks like this:

Pretty slick.

Thanks again, Bruce. Perfect solution to my problem!