So I got some great advice about using the DynamicQuery adapter - really does make returning data so much easier!
This is a simple grid that I’ve populated using BAQ. Question is how to control the decimal format - can’t specify it in the customisation because the grid is blank and has no columns at runtime. (the headers aren’t shown at least until it’s run).
I’ve edited the post - can’t work out how to get it to display the images though, even though they are local to the forum site now that they are uploaded.
Another option is to cast the BAQs result to a string, then you dont have to worry about it. If you ever need to edit this field then this is not a good option (if it ever was)
So if you add the word “infragistics” to about any formatting question you have, a solution usually shows up using google. It’s a pretty widespread control platform, and what Epicor is built on.