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.
1 Like
@ypatel Where are configuration values / smart strings stored? - ERP 10 - Epicor User Help Forum (epiusers.help)
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.
1 Like
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 dataset. As @Schae235 pointed out it can get messy pulling from those tables directly.
1 Like
@ypatel this is what I have been told to do from consultants as well. @jstephens 's approach seems great.