Does anybody know how to pass a parameter created within report builder to the oracle SQL statement? I have tried using the @var for SQL Server and %var for Oracle SQL Statements both are failing. I need to use the variable to filter the dataset by a date field. Is this even possible?

If you are using the Oracle SQL statement within the report builder, then it may due to the type conversion. Are you using a TO_DATE to convert your parameter value to a date value. Assuming your parameter value is TransDate, you would use your query as below SELECT * FROM MyTable WHERE MyDateField = TO_DATE(@TransDate,'DD-MM-YYYY') Note : you may have to change the format to MM-DD-YYYY or any other, depending on the date reading format. Please check and update. Feel free to discuss if you have any further questions.Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH