Sanjeet
asked on
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
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
... and how are you populating it with a value when you run the report?
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.
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.
ASKER
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
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
"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?
How do you get a custom query in your report without using a dataset?
ASKER
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
Data-tab.GIF
Please make sure the Same name parameter is exists .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.