BAQ for InspResults table

[arizonaplr (Patti H)]

Has anyone created a BAQ for the InspResultsChar, InspResultsCheckBox, InspResultsDate, InspResultsNum, and/or InspResultsShortChar tables?

I’m looking to capture the value in InspResultsShortChar.ShortChar001, 002, 003, etc. from one row and split into multiple rows.

[jkane (John Kane)]

Inspection Report --- FINALLY!

Incoming book😊 I have been wanting to really try this one for a few years now but never got the opportunity. I recently was able to start working on it and I can now say that I was successful. I have created an Inspection Report that dynamically returns the data based on the Specification and the user entered description (not the Number001). The method I use only needs Epicor functionality to accomplish it. No Stored Procedures, Table Valued Functions, or code. I have seen multiple posts lookin…