Difference Between Query Parameters and Report Parameters

Hi Guys,
Can somebody explain me cleraly the difference between Query and Report
Parameters.
Report Parameters r automatically created when u put some variable in a
query.
2)
One more thing is there a way we can hide query string in the IE as I dont
want the users to see the report URL.
3)
My Stored Proc expects 2 parameters but I dont want to pass them in the URL
string is there any other way I can pass parameters to the report from the
front end other than URL strings
Many Many Thanks
Chandra
--
Message posted via http://www.sqlmonster.comwell report parameters r used to get input from the user for the report
and report parameters got attached with query parameters to pass on
input from the user to query in order to build query at run time when u
define query parameter in ur query report automatically generates a
report parameter and attach that report parameter to the specific query
parameter to see further details click EDIT DATASET option n click
parameters tab u ll c how report parameters r getting associated to
query parameters
as far as ur question of hiding parameters is concerned u got to use
reporting services class (SOAP API) n make ur own application to access
the reports instead of accessing reports through URL or u got to set
any property of Ineternet explorers in the registery to hide the
address bar and status bar as well
hope this answers
take care
regards|||Go here:
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_interactive_v1_50fn.asp?frame=true
It will tell you all you need to know about parameters.
"Chandra Kotha via SQLMonster.com" wrote:
> Hi Guys,
> Can somebody explain me cleraly the difference between Query and Report
> Parameters.
> Report Parameters r automatically created when u put some variable in a
> query.
> 2)
> One more thing is there a way we can hide query string in the IE as I dont
> want the users to see the report URL.
> 3)
> My Stored Proc expects 2 parameters but I dont want to pass them in the URL
> string is there any other way I can pass parameters to the report from the
> front end other than URL strings
> Many Many Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com
>|||Others have answered most of your questions. Just a little bit more about
query parameters versus report parameters. RS does automatically create a
report parameter when you put in a query parameter. However, you do not have
to use it. You can set the query parameter to a different report parameter,
you can set it to an expression (which means that if you want you can first
have some custom code massage the report parameter first). A very common
scenario where there is not a one to one relationship between report and
query parameters is when you have several datasets in a report. Let's say I
have several datasets that all use a fromdate and todate. I sure don't want
the user to have to put in the same date multiple times. So, I delete the
extra report parameters and have all the datasets query parameters point to
the same set of report parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chandra Kotha via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:698d0fc48f2b42f69c5c9fdc8632204a@.SQLMonster.com...
> Hi Guys,
> Can somebody explain me cleraly the difference between Query and Report
> Parameters.
> Report Parameters r automatically created when u put some variable in a
> query.
> 2)
> One more thing is there a way we can hide query string in the IE as I dont
> want the users to see the report URL.
> 3)
> My Stored Proc expects 2 parameters but I dont want to pass them in the
URL
> string is there any other way I can pass parameters to the report from the
> front end other than URL strings
> Many Many Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks Guys for ur responses
--
Message posted via http://www.sqlmonster.com