Is there any way to call an input value from the configurator in the ssrs report?

Yash, somewhere in this forum there is a post that contains the answer to where this info is stored. I had something written a couple years ago to try and use this data in a similar way, but never ended up using it. I think it is possible though.

Do you possibly have a reference to that post for me to go look at it?

I will try and locate it for you, I didn’t have time when I replied earlier.

I believe the table names are PCInput and PCInputValues

And the information is stored in xml format so it is a little tricky to extract into SSRS/SQL data. It would be very nice though if that was easily possible because it would make any analysis easier.

I went down that road before and ended up just making a UD column on the table I was working with (JobHead in my case) and writing a copy of the pertinent data there at the time of configuration. Usually just a delimited string for simple data or an HTML string if it gets hard to parse in the report…

@ypatel this is what I have been told to do from consultants as well. @jstephens 's approach seems great.

SSRS Report using Config

Epicor ERP 10

utaylor (Utah Taylor) April 5, 2021, 4:01pm 6

@ypatel Where are configuration values / smart strings stored? - ERP 10 - Epicor User Help Forum (epiusers.help)

Topic		Replies	Views
Can We Report On Individual Configurator Inputs? Kinetic ERP	6	568	December 20, 2023
Where is the Configurator Information Stored? Epicor ERP 10 e10	4	2073	March 23, 2022
Configurator Input Value Epicor ERP 10 configurator	5	900	February 13, 2024
Where are configuration values / smart strings stored? Epicor ERP 10	63	9692	February 16, 2023
External Configurator Epicor ERP 10	8	2140	August 16, 2018

SSRS Report using Config

Related topics