Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 DateTime Parameter Issue

Author  Topic 

murray002
Starting Member

1 Post

Posted - 2009-02-26 : 15:27:03
Hello!

I'm *very* new to SSRS (...and SQL in general...). Please, bear with me!

I'm trying to set up the ability to enter a StartDate and EndDate for a report I am writing. I can execute the SQL expression in the Data tab, enter my date values, and the information I'm expecting appears in the Results pane - which is great! But when I go to the Preview tab and enter my date values, I'm getting an error message:

An error occurred during local report processing.
An error has occurred during report processing.
Cannot read the next data row for the data set XYZ.
Conversion failed when converting the nvarchar value '2/3/2009' to data type int.

What I find strange is the date is what I entered for my EndDate. I would have thought if there was an issue with the dates I entered, it would give me an error on the StartDate as well.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-02 : 13:18:30
were you trying with same parameter values which ran successfully in data tab?
Go to Top of Page
   

- Advertisement -