Report Wizard

I am trying to use a stored proc in the report wizard with parameters
Exec usp_AgentSessionSummary @.StartDate, @.EndDate, @.ProjectID, @.AgentID
I get the error below. I want to use the wizard for ease, how do I get
around the error?
There is an error in the query. Implicit conversion from data type
sql_variant to datetime is not allowed. Use the CONVERT function to run this
query.You could try first hard coding the parameters, use the wizard and then
switch it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:E1ADCFEF-E23F-41F7-8327-BB5B10C11008@.microsoft.com...
>I am trying to use a stored proc in the report wizard with parameters
> Exec usp_AgentSessionSummary @.StartDate, @.EndDate, @.ProjectID, @.AgentID
> I get the error below. I want to use the wizard for ease, how do I get
> around the error?
> There is an error in the query. Implicit conversion from data type
> sql_variant to datetime is not allowed. Use the CONVERT function to run
> this
> query.

Report Viewer - tell it not to run until parameters are entered

I have this reportviewer control in an asp.net page -
I've added a parameter of startdate
How do I change the properties of the ReportViewer control so that it waits
for the date input, and doesn't try to run when the page is loaded?
I keep getting this error when running the page:
a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
have the expected type.On Jan 18, 12:05 pm, "Elmo Watson" <s...@.here.com> wrote:
> I have this reportviewer control in an asp.net page -
> I've added a parameter of startdate
> How do I change the properties of the ReportViewer control so that it waits
> for the date input, and doesn't try to run when the page is loaded?
> I keep getting this error when running the page:
> a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
> have the expected type.
The easiest way to control the automatic running of the report is to
modify the SSRS report itself to not have a default value (set Default
Values to Null) for the startdate parameter. This should follow
through to the report viewer control. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql