Groups | Blog | Home
all groups > sql server reporting services > february 2006 >

sql server reporting services : Link to a report with parameters


Pasquale
2/13/2006 11:57:07 PM
I need to create a report with some parameters for filtering data.
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is the format of link for passing parameters to filter data?

Wayne Snyder
2/14/2006 5:21:28 AM
1. Try leaving the parameter Prompt blank... This should prevent the
parameter from displaying, (but you must provide a default value...)

2. Search for URL Access in Books on line and you will get an entire list
of all of the things you can do via URL in reporting services.

Hope this helps..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


[quoted text, click to view]
Pasquale
2/14/2006 8:59:26 AM
I tried passing parameters in URL address successfully,
but I see some parameters that the user hasn't change!
Moreover, if I change the parameter property "User request"
by setting to false value, the call of report dumps!

The issue is partially solved! I need to pass a parameter by Url
and these parameters cannot change by a user.

Can I solve this problem URGENTLY?

Many thanks


[quoted text, click to view]
Pasquale
2/14/2006 10:01:27 AM
I have executed several tries modifying the parameter settings.
I have followed your suggests, but the solution isn't complete:
or I see the parameter or I cannot modify the parameter
that I pass via URL (an error occurs!!!)!

Many thanks


[quoted text, click to view]
Bruce L-C [MVP]
2/14/2006 11:45:38 AM
Read the rest of Wayne's post. He is telling you how to hide a parameter so
the user doesn't see it.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
2/14/2006 12:37:55 PM
Two different things. First is getting the parameters to work. Then making
them hidden. Do you have them working properly so you know your URL is
correct. Be sure that your parameter is with the correct case since RS is
case sensitive with parameters. Once you know your URL is correct because
your report works properly then you can deal with hidding the parameters.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

Pasquale
2/15/2006 1:18:29 AM
My issue has two aspects:
1. passing a parameter via URL to call my report filtering data by the
parameter;
2. hide or protect parameter inside report manager to avoid any user's
changes.
The first step is solved. The report is called correctly and I see the
correct value
of parameter (the same written in the URL). I have written correctly the
name of parameter.
Now, when I set user request for the parameter, inside report manager, to
false
in order to hide the parameter, this message error occurs:
"sReadOnlyReportParameter" and I cannot the value of parameter by the value
in the URL.
This strange behaviour represents a limit of RS!
Moreover, I have specified a default value of parameter with a particular
value.

Now, is it really possible to solve completely this issue?
Do I have a particular SP (SP1, SP2, ...)?

Many thanks


[quoted text, click to view]
Pasquale
2/15/2006 2:23:27 AM
I have controlled all settings of the report; then I try to set to blank
the user request string inside report manager (maintaning a default
value for the parameter): so, I can modify the parameter by passing it
via URL and simultaneously hide it in order to avoid any user's changes.
Finally, the issue is solved!!!

Many thanks



[quoted text, click to view]
Bruce L-C [MVP]
2/15/2006 9:10:31 AM
Making parameters hidden is much more straight forward in RS 2005. I don't
hide parameters so I have not had that issue.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

AddThis Social Bookmark Button