I'm working on Crystal Reports 2008 with an Oracle database. In the report is a SQL-command (a complicated union) used. To prevent this command transferring all the data from the server I have

- moved this logic to a sub-report to be able to use parameters

- introduced some parameters in main-report to carry on DateTime

- created corresponding parameters to the sub-report

 

I tested this by placing those parameters in the sub-report header, they print just fine.

 

Now, I'm trying to modify the SQL-command. I have added a where-clause to test the date like this ... WHERE STARTTIME>={ts '{?PmBeginTime}'}

The trouble is, when I click OK, the sub-report prompts to give PmBeginTime (it shouldn't do this?)

The worst thing here is this: although I have defined in options/fields of the sub-report that the dateTimes and dates must be in ISO-format (yyyy-mm-dd), the prompt does not accept anything but yyyy/mm/dd -format. If I give the dates in this format Oracle database returns an error. In either case, my parameters disappear and the sql command resets to the previous state.

 

How should I give those dateTime-parameters to it?