Thanks a lot the helps, even with addtional choice!!!!

I got it.

It shoudl be just =:mydate.

Thanks anyway!

I got it!

I made it too complex. It shoudl be just use :mydate instead of @mydate. Only drackback is the user has to put in the correct date format ---...

Paul ---Thanks a lot for contiuning help me.

Your code works in the SQLPlus. How can I convert it into BIDS(SSRS) format, so I can create a report in BIDS(stripdown Microsoft...

Paul ---Thanks a lot for contiuning help me.

Your code works in the SQLPlus. How can I convert it into BIDS(SSRS) format, so I can create a report in BIDS(stripdown Microsoft...

during the passed days, I tried many times. However it still doesn't work for me.

The error message said: ORA-00900: invalid SQL statement

It looks like I may not declare the variable...

Where should I put below code:

DECLARE

param_bdate DATE;

param_edate DATE;

SET param_bdate = TO_DATE('01/15/2010','MM/DD/YYYY');

SET param_edate = TO_DATE('01/15/2010','MM/DD/YYYY');

When I put above in the Query text area. The error message below:

Could not update a...

Thanks your replying.

Follow your syntax, I received error message:

"An error occurred during local report processing,

An error has occurred during report processing,

Query execution failed for dataset "DataSet1"

ORA-01858: a non-numeric character was...