Rob wrote:
> Peter,
>
> Do a search for "parameter oracle" in the search box above, you will get
> more than a couple of good hits regarding this.
>
> I had the same issue 2 weeks ago (and I also forgot to do a search as well).
>
> Basically, use : instead of @; but do the search and read some of the
> replies, it helped me.
>
> I hope this helps.
> Rob Cuscaden
>
> "Peter" wrote:
>
> > Hello,
> >
> > I'm using SQL Server 2000 Reporting Services.
> >
> > I need to create a report based on a simple query:
> >
> > SELECT SUM(DISC) AS DISC, IMPACT, ADDDATE, YEAR, MONTH
> > FROM RPT_DRS_BY_MONTH_VU
> > GROUP BY IMPACT, ADDDATE, YEAR, MONTH
> > ORDER BY YEAR DESC, MONTH
> >
> > The user must be able to select a Year to view the report. So I need to
> > add a parameter.
> >
> > This should be no problem, should I use SQL Server. But I'm using
> > Oracle. So when I add a parameter to a datasource - it doesn't work.
> > For instance, in SQL Server it would look like this:
> >
> > SELECT SUM(DISC) AS DISC, IMPACT, ADDDATE, YEAR, MONTH
> > FROM RPT_DRS_BY_MONTH_VU
> > WHERE (YEAR=@Year)
> > GROUP BY IMPACT, ADDDATE, YEAR, MONTH
> > ORDER BY YEAR DESC, MONTH
> >
> > But in this case the parameter is treated as a string value and
> > automatically enclosed in the single qoutes, like this:
> >
> > SELECT SUM(DISC) AS DISC, IMPACT, ADDDATE, YEAR, MONTH
> > FROM RPT_DRS_BY_MONTH_VU
> > WHERE (YEAR='@Year')
> > GROUP BY IMPACT, ADDDATE, YEAR, MONTH
> > ORDER BY YEAR DESC, MONTH
> >
> > In other words, it doesn't work.
> >
> > I'm new to the Reporting services, so I'm stuck.
> >
> > Could anyone give me a hint how to achieve this in Oracle? I would
> > really appreciate it.
> >
> > Thank you,
> >
> > Peter
> >
> >