Skip to Content
Former Member
Oct 25, 2011 at 05:57 PM

New user coloumn with user variable input



I want a user defined coloumn in a new Query for Report and also it should prompt for user defined values.

Case scenario.

In a report for stock status ( Qty, rate , Total etc.) i need a new column " Forex Rate" which should prompt user to put exchange value manually as on the date of running this report anytime i.e this new column has variable input.

Since the items are purchased from various sources, the report has to display the value in respective purchase currency. The value on report generation date is based on input of exhange rate as explained. This should prompt before running the report.

I just need the query part for creation of such column and user prompt. Will integrate that into rest of query.