A Sales table contains date, customer and amount.

Trying to create a report that, based on the start date and end date, user is presented a list of custmers. Based on the selected customers, the report shows only the transactions for the selected customer within the date ranges.

 

I use the 'Command' with query like

select * from Sales where date between {?StartDate} AND {?EndDate}+1

 

Then the record selection looks like {Command.customer} = {?cusomers}

 

However, the start date and end date parameters display twice. Any way to make it display only once? 

 

Thanks.

 

Dennis