For simplicity, I will just list the basic settings.
- Oracle 10 DB
- Crystal Reports XI
- Visual Studio 2008 C#

The Crystal Reports, rpt file has
- cross tab
- two 'date' parameters
- selection using 'date' parameters (formula is like
table.datevalue <= start_date and table.datevalue <= end_date)

The implementation is :
- C# DLL Class library that converts rpt to pdf file.
- take two parameters from users and send it to rpt file
- rpt file is supposed to generate a report using two 'date' parameters. (the data consists of falls between start and end date) (used Export())
- to send parameter values to rpt file, used
Convert.ToDateTime(string value)

Problem is :
- I can successfully convert a rpt file to pdf file if I just send two date values and print them on the report. However, when I try to generate a report that consists of data that falls in two different dates (start and end), it gives me the database load error.

Is that because of the type (Date and DateTime) difference?
I am pretty sure that it is not about the connection problem as I can get the pdf file with the default values on start and end date.

Thank you