CR 9
SQL server 2000
I created a 'Crystal' report which uses parameters to select correct data.
1) Parameter ?Period (number)
2) Parameter ?start_date (date)
3) Parameter ?end_date (date)
I want the user to have an option to select by Period or Date Range. When I enter start date and end date and click ok (without putting any number in Period parameter) it gives me a error 'You must enter a value for this field'. If I blank it out I get 0 results.
What is the best way to get results either by Period or Date Range? At the end of a period users will run a report by Period # and during the Period it's by Date Range. If it's a period report they want to see the Period # in the report not a date range and visa versa.
Thanks in advance for your help.
brxmas
SQL server 2000
I created a 'Crystal' report which uses parameters to select correct data.
1) Parameter ?Period (number)
2) Parameter ?start_date (date)
3) Parameter ?end_date (date)
I want the user to have an option to select by Period or Date Range. When I enter start date and end date and click ok (without putting any number in Period parameter) it gives me a error 'You must enter a value for this field'. If I blank it out I get 0 results.
What is the best way to get results either by Period or Date Range? At the end of a period users will run a report by Period # and during the Period it's by Date Range. If it's a period report they want to see the Period # in the report not a date range and visa versa.
Thanks in advance for your help.
brxmas