My report wont work :-) with a date param

Hi All,
I have inherited a report that at the Dataset level works fine. It takes a
date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
The report page has the date param defined as Datetime and when I enter the
date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different date
formats
to no avail. kinda puzzled.
Any clues as to the cause of the problem.
Thanx in advancewell,i had kind of this problem.
I never use parm as datetime always as string and inside the dataset i use
CONVERT(datetime,@.FromTime,103) it works 4 me...
"Scotchy" wrote:
> Hi All,
> I have inherited a report that at the Dataset level works fine. It takes a
> date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> The report page has the date param defined as Datetime and when I enter the
> date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different date
> formats
> to no avail. kinda puzzled.
> Any clues as to the cause of the problem.
> Thanx in advance
>|||It sounds to me like your query parameter is not hooked up to your report
parameter. In the dataset click on the ..., parameters tab. Your query
parameters should be listed on the left and the report parameter they map to
on the right.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scotchy" <Scotchy@.discussions.microsoft.com> wrote in message
news:B64FE999-9EA6-40C0-896E-984BBDC4BDC4@.microsoft.com...
> Hi All,
> I have inherited a report that at the Dataset level works fine. It takes a
> date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> The report page has the date param defined as Datetime and when I enter
> the
> date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different
> date
> formats
> to no avail. kinda puzzled.
> Any clues as to the cause of the problem.
> Thanx in advance
>|||Thanks Bruse, but no, all params are mapped as required. Something else going
on here I think, might try a string param instead , although Ive not had this
issue before in Date param'd reps. Guess thats the problem when inheriting
others work. Thanx for your and others input. Much appreciated
"Bruce L-C [MVP]" wrote:
> It sounds to me like your query parameter is not hooked up to your report
> parameter. In the dataset click on the ..., parameters tab. Your query
> parameters should be listed on the left and the report parameter they map to
> on the right.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scotchy" <Scotchy@.discussions.microsoft.com> wrote in message
> news:B64FE999-9EA6-40C0-896E-984BBDC4BDC4@.microsoft.com...
> > Hi All,
> >
> > I have inherited a report that at the Dataset level works fine. It takes a
> > date param eg. 02-Dec-2005 and returns 3 rows as I would expect.
> >
> > The report page has the date param defined as Datetime and when I enter
> > the
> > date ie. 02-Dec-2005 it returns 0 rows. I have tried inputting different
> > date
> > formats
> > to no avail. kinda puzzled.
> >
> > Any clues as to the cause of the problem.
> >
> > Thanx in advance
> >
>
>