Hi
I need to write a query based on sales orders but there are quite a few criteria
The user wants the ability to enter a date range, order number range and business partner range
The query I have is I want the report to produce all info if they leave the criteria blank
I am not sure how to do this.
Not sure if I need to use some sort of IF statement which basically says if a BP range has been entered then use it else ignore it, etc
Can anyone help me please ?
Thanks
Regards Andy