Re: Data Prompt

On Tue, 29 Apr 2008 19:46:00 -0700, James Terrington wrote:

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.
(snip)

Hi James,

You can't include parameters in views. You'll have to either make a
user-defined function, use a stored procedure, or send a paramterized
query from reporting services.

Since I'n not familiar with reporting services, I suggest you repost
your question in a newsgroup or forum focused on reporting services,
such as for instance microsoft.public.sqlserver.reportingsvcs.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

Relevant Pages

  • Re: SSRS und ReportViewer
    ... Reporting Services, daher geht's von RDLC nach RDL eher automatisch, als umgekehrt. ... Schon mal dran gedacht, den SQL Server 2005 Express Advanced Edition zu installieren, und damit dessen Reporting Engine. ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Re: Reporting Services Clustering ?
    ... We're using the Enterpise and I don't think SQL server ... SQL but not Enterprise edition. ... Reporting Services to be clustered, I would essentially have to buy all 4 to ...
    (microsoft.public.sqlserver.clustering)
  • 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: Installing Reporting Services and IIS 7.0
    ... Jasper Smith (SQL Server MVP) ... did not install Reporting Services. ... IIS is required by some SQL Server features. ...
    (microsoft.public.sqlserver.setup)
  • 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)