I want to set up a drop down input box on a report for a customer to select an available sales date from the database where I want the value of each available date in the database to appear in the drop down selector as one per row.
On the constraints tab I have the following setup:
Input Constraints = Predefined Values Only -- nothing else is selected or checked.
Value List = Predefined Values in Drop-down -- nothing else is selected or checked.
Predefined Values has the listed box checked with the following formula (-- nothing else is selected or checked):
=Concat( {1} DISTINCT SALES_DATE, chr(10) & chr(13) , SALES_DATE )
This doesn't work and wants to give a linear list of the SALES_DATE field. I want the list to place one date per line of the drop down input box.
Any help?
