Data Prompt

As a background:

1) I am using SQL 2005
2) Reporting Services.

In order to achieve certain report requirements I have created 2 VIEWS on
the SQL database.

What I want to be able to do is have a date paramater prompt on one of the
views.

I have created the following SQL but I get an error message when I try to
save it.

SELECT dbo.[Job].No_,

SUM(CASE WHEN dbo.[Job Ledger Entry].[Resource Type] = 2 THEN dbo.[$Job
Ledger Entry].[Total Price] END) AS LabourCost

FROM dbo.[Job]

WHERE (dbo.[Job].[Posting Date] <= @EndDate)

GROUP BY dbo.[Natural Solutions Pty Ltd$Job].No_

HAVING (dbo.[Natural Solutions Pty Ltd$Job].No_ = 'J07101')

I get the following error on saving this, can someone please tell me what I
need to fix..

"Must declare the scalar variable @"EndDate"

Thanks

James
.

Relevant Pages

  • Re: Reporting Services Clustering ?
    ... If I use Reporting Service Enterprise, with a 2005 SQL Standard back-end, is ... "Geoff N. Hiten" wrote: ... You can use a Reporting Services Enterprise Edition with a SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: Reporting Services Clustering ?
    ... The Reporting Services host must be licensed just like any other SQL Server, ... If I use Reporting Service Enterprise, with a 2005 SQL Standard back-end, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Reporting Services Clustering ?
    ... There are no Edition-specific CALS. ... then all you have to do is purchase the server software license. ... We're using the Enterpise and I don't think SQL ... Reporting Services to be clustered, I would essentially have to buy all 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Reporting Services Clustering ?
    ... You can use a Reporting Services Enterprise Edition with a SQL ... Microsoft SQL Server MVP ... SQL clustering is MSCS based and is a failover technology. ...
    (microsoft.public.sqlserver.clustering)
  • Re: side by side migration sql 2000 to sql 2005
    ... Thanks Andrew, I am scheduling myself some serious study time. ... Andrew J. Kelly SQL MVP ... I performed an inplace upgrade and my SQL Database upgrade went ... Reporting Services and then Installing Reporting Services 2005. ...
    (microsoft.public.sqlserver.setup)