Passing Parameters -- sql server reporting services

sql server reporting services : Passing Parameters

Woody Splawn
8/13/2004 2:12:30 PM

I am wondering if it is possible to pass parameters to a report at runtime,
in code, as opposed to having the user select parameters from drop downs
while in the View mode of the the Report. That is, for the kind of reports
I do there may be numerous combinations of parameters that need to be passed
to the report at runtime. For me and the user the entering of these
parametes is better done in a Winform than in the report itself. That is, I
would like for the user to be able to make selections from a winform that I
have created (where I have greater control) and then, depending on what the
user entered, pass that information to the report at runtime.

Is this possible?

Ravi Mumulla (Microsoft)
8/13/2004 2:18:48 PM

Yes. Take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_7vqa.asp?frame=true
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_6x0z.asp?frame=true

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

Woody Splawn
8/13/2004 3:18:15 PM

OK, let me ask the real question..

I see from the links you mentioned that it is possible to pass parameter
information to the report at runtime that has been gathered ahead of time by
the developer, say, in a Winform. But you must admit that method for doing
so is rather complex.

My intention is to use SSRS as a report writer for non web applications. I
understand that this functionality is not really available right now using
VS 2003, but that it is going to be available in VS 2005. In a post in this
newsgroup on 8/5/04 titled "SSRS VS 2005 & Desktop Reporting" Lukas
Pawalowski [MSFT] said:

"We are working on a WinForms control for the VS 2005. It will allow you to
execute reports in your desktop application without a server"

My hope is that with this functionality passing parameters to the report at
runtime that you've gathered from a winform will be a lot simpler.

There is no Reporting Services newgroup in Whidbey. Could someone here tell
me if they think what I want to do will get easier in VS 2005?

Just one final note:

I realize that right now the big attraction for Reporting Services is the
fact that you can indeed use a Report Server but another of the real
advantages of Reporting Services in VS 2005 is going to be that it is likely
to replace Crystal. I mean Crystal no ill will but I really dread using it
and really hope SSRS will make for a replacement. A good report writer for
non web applications is really needed. Active Reports is nice but there is,
for example, no ability to do crosstabs and Microsoft has the potential to
do it better than anyone else.

Bruce Loehle-Conger
8/14/2004 9:32:21 PM

Just a quick point, there is no newsgroup for RS for Widbey because the new
controls are not part of Beta 1.

Bruce L-C

[quoted text, click to view]

Linnysee
8/27/2004 10:25:01 AM

If you are still reading this: I don't see anything wrong with Crystal - it
is a very simple package to work with. Even setting parameters. At least
passing parameters' values from the main to subreport is lot easier that RS.
Especially, when you are using wildcards.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn