Report parameter with datetime

Hi,

Anyone can help me?

I created a store proc with @.startdate and @.enddate

in query analyser - I run it as Exec SP_Admission '2006/01/01','2006/01/25' and it is ok.

Then I created a report in VS2005 and set the parameter as datetime in report parameter.

if I manually force to fill startdate and enddate with ‘yyyy/mm/dd’ format in preview, it works.

However if I choose the date from the given calendar(Date Time Picker), it doesn’t work

it is said that "The value provided the report parameter 'enddate' is not valid for its type.

Of course it not valid because it always comes with ‘dd/mm/yyyy’ format

I didn't setup the date time picker, it will automatically when I choose datetime as datatype.

any idea what should I do?

thanks,

Susan

Hi Susan,

not exactly brilliant, but

Exec SP_Admission convert(datetime,'12/10/2006',103),convert(datetime,'12/11/2006',103)
should work in your case, so put your parameter instead of '12/10/2006'
|||

Thanks...

someone suggested that in my SP -

I declare as varchar then in where statement I convert it as you mention.

however in report para - I can't set it as datetime but set to string.

it works ok but I can't use the date time picker .

well at least works that way...

Thanks so much

Report only generates 1 page output

I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?

Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?

Thanks,
Albert

Report only generates 1 page output

I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?

Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?

Thanks,
Albert