Real good issue

[aproddut]

I have a report with 2 parameters from date and to date. I am using an oralce table with couple of millions of records.
I want the user to enter the from and to dates in the parameter and if the difference between the 2 dates is greater than 10 then the report should not access the database and terminate right away. Assuming the reason is if the difference between the dates is greater than 10 it takes too long to access the oracle database. If the difference between the dates is 10 or lesser the report should run and print the data. Is there a way I can achieve this without using Ora procedures?

 

[IdoMillet]

The best way of handling user errors is not letting them happen in the first place... )

Create a single-value date parameter for specifying the starting date. Then create a numeric parameter (limited to 1 to 10) for specifying how many days after the first date.

Then create your record selection formula based on these two parameters.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com