Runtime Assign Date Parameter

30 Views

I have searched through Google and this forum and have been unsuccessful in finding an answer. Maybe someone can help.

I have designed a report that uses a date range and the datasource is a stored procedure connected to SQL Express through SQL Native driver. When I try to preview the report I get an error involving CONVERT. Regardless of how I set up the CONVERTDATETIMETYPE it converts using a 120 type in the SQL statement. I thought that may not cause an issue in running the report from my code so I decided to move forward.

Now I am trying to assign the date range in code. These are parameter fields and they show up properly in the report. I believe that I am supposed to use the PARAMETERFIELDDEFINITION but cannot get it to work properly. Has someone experienced and conquered either of these?