Thank you for the help. I tried to resolve the issue by using your code. It doesn't work. Here is the sample data .. may be this will help to...

Thank you for the help. I tried to resolve the issue by using your code. It doesn't work. Here is the sample data .. may be this will help to...

Thank you for your help .. But, I need one more help from you...

I have 2 more conditions to satisfy for this report.

I need patients who have lab orders...

I solved the problem of calender control by using to_char(to_date(:1),'DD-MON-YYYY') which would and when I set the format as datetime in reportparameters it shows the calender control.

The other problem I...

Yes , I did check the username and password on the datasource after they were deployed. They are saved and they are correct. Yet, this issue still continues. Any thoughts...

Yes, I did check for the OLEDB provider and I can create a linked server using the Oracle 64 bit client. Yet, the issue remians unresolved. Is there anything else...