I have a macro that sets a number of store1,,store2 variables. The macro then calls a SQL report. Can I use one of the 'store' variables as part of the query in the sql report (as a column to display).
For example, in the sql report I want to have something like:
SELECT T0.ItemCode, T0.ItemName, @store1 as 'Qty' FROM OITM T0
Please sign in to leave a comment.