SSRS 2005 error message

When I run a sql in sql server 2005 I can return results. The sql requires parameters.

When I run the same sql and declare my parameters in SSRS I get the following error message (attached):

I have declared my startdate as a datetime datatype in the paraemeters section.
SSRS-dstartdtae-error-message.GIF
SanjeetAsked:
Who is Participating?
 
ValentinoVBI ConsultantCommented:
"Aren't the parameters declared in the layout tab? I attache an earlier screenshot."

That screenshot did indeed show that you've created some report parameters.  But these parameters still need to get linked to the parameters in your query.  The report doesn't know this automatically, even when they've got the same name.

(I don't have 2005 around and the interface has changed a lot since then but I'll try to guide you based on screenshots.)

If you read through the article that I mentioned earlier, it shows a Dataset popup window with five tabs: Query, Fields, Data Options, Parameters, Filters.  That's the window you need to find.

If I remember well, you need to click those three dots (...) to the right of your dataset name to get that window (this is in the Data tab which you've shown in your last screenshot).
Another option might be to right-click inside the query window and choose something like "properties" but I'm not sure about that.

Once you've found it, switch to the Parameters tab and ensure all your query parameters are linked with your report parameters as shown in that same screenshot in the article.  The Name column is your query parameter, for instance @dStartDate.  And the Value column is your report parameter, for instance =Parameters!dStartDate.Value.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
... and how are you populating it with a value when you run the report?
0
 
ValentinoVBI ConsultantCommented:
I assume @dStartDate is the name of the parameter in your query, right?  If that's the case, you probably forgot to link it with the parameter in the report.  That can be done through the Parameters tab on the Dataset properties.

See following article for a screenshot and some explanation: Designing Reports with SQL Server Reporting Services 2005

The chapter you'll be interested in is called Datasets and Parameters.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
SanjeetAuthor Commented:
I am using a datecalendar variable to populate the start and end dates (screen shot attached, How startdate get populated).

I have declared variables for the parameters to run the report and link it in the parameters in the report (screen shot attached, Parameter declaration). I did not use a dataset but a custom query to bring back the data.
How-startdate-get-populated.GIF
Parameter-declaration.GIF
0
 
ValentinoVBI ConsultantCommented:
"I did not use a dataset but a custom query to bring back the data."

How do you get a custom query in your report without using a dataset?
0
 
SanjeetAuthor Commented:
I am modifying an existing query. When I click on the data tab I see the custom query and no graphical interfaces with table joins. I may be misunderstanding data sets. (screen shot attached). Aren't the parameters declared in the layout tab? I attache an earlier screenshot.
Data-tab.GIF
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure the Same name parameter is exists .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.