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.
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? |
|
|
|
|
|