Hi,
Is there any way that the parameters passed from the URL is not shown to the users. Making the "Prompt User" unchecked and passing the parameter through the URL gave some error. Is there a work around.
Thanks.
--
Message posted via http://www.sqlmonster.comTry appending this to your URL:
&rc:Parameters=false
"Prashanth Rao via SQLMonster.com" wrote:
> Hi,
> Is there any way that the parameters passed from the URL is not shown to the users. Making the "Prompt User" unchecked and passing the parameter through the URL gave some error. Is there a work around.
> Thanks.
> --
> Message posted via http://www.sqlmonster.com
>
Showing posts with label url. Show all posts
Showing posts with label url. Show all posts
Friday, March 30, 2012
Hide Parameter with SP1
Installed SP1, still finding not possible to hide a parameter. Can someone provide the process please. The parameter is an ID that is send via URL to the report server. I created a Report Parameter for it, then created a queary parameter setting that to the incoming value of the Report Parameter. Help pleaseYou can hide a paremeter after you have deployed your report.
But hiding a parameter disallow you to pass any value to this parameter
through the URL!!!
The parameter is not simply hide to the user, is also completly inaccessible
to the user through any URL, but just available to the administrator to
change the default value of the parameter.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> Installed SP1, still finding not possible to hide a parameter. Can someone
provide the process please. The parameter is an ID that is send via URL to
the report server. I created a Report Parameter for it, then created a
queary parameter setting that to the incoming value of the Report Parameter.
Help please|||According to another post by Brian Welcker,
"This is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL."
with SP1, you should be able to specify in URL
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||From the SP1 Read Me:
4.3.1 Hiding Parameters in a Published Report
In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
Hide the parameter fields in a published report.
Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||mmmm...
I'll test this.
maybe this doesn't works for me because I have a default value.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A3AD4330-FF88-46BD-97B8-58AB215F4507@.microsoft.com...
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that
allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription
that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt
User check box in the Parameters properties page. However, a side effect of
clearing the check box was that you could no longer specify a parameter
value for the report at run time. This limitation has been removed. In SP1,
you can clear the Prompt User check box to hide the parameter fields and
values in the report. Doing so does not introduce restrictions on how you
subsequently set the parameter value externally at run time.
>
> "Jéjé" wrote:
> > You can hide a paremeter after you have deployed your report.
> > But hiding a parameter disallow you to pass any value to this parameter
> > through the URL!!!
> > The parameter is not simply hide to the user, is also completly
inaccessible
> > to the user through any URL, but just available to the administrator to
> > change the default value of the parameter.
> >
> >
> > "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> > news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > > Installed SP1, still finding not possible to hide a parameter. Can
someone
> > provide the process please. The parameter is an ID that is send via URL
to
> > the report server. I created a Report Parameter for it, then created a
> > queary parameter setting that to the incoming value of the Report
Parameter.
> > Help please
> >
> >
> >|||Ok..
Now i have to create a subscription with specific parameters for this subscription and then i should uncheck Promt User checkbox?
Is that right?
The result report i'll use the parameter without problems?
"Eddie" wrote:
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.
But hiding a parameter disallow you to pass any value to this parameter
through the URL!!!
The parameter is not simply hide to the user, is also completly inaccessible
to the user through any URL, but just available to the administrator to
change the default value of the parameter.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> Installed SP1, still finding not possible to hide a parameter. Can someone
provide the process please. The parameter is an ID that is send via URL to
the report server. I created a Report Parameter for it, then created a
queary parameter setting that to the incoming value of the Report Parameter.
Help please|||According to another post by Brian Welcker,
"This is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL."
with SP1, you should be able to specify in URL
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||From the SP1 Read Me:
4.3.1 Hiding Parameters in a Published Report
In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
Hide the parameter fields in a published report.
Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||mmmm...
I'll test this.
maybe this doesn't works for me because I have a default value.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A3AD4330-FF88-46BD-97B8-58AB215F4507@.microsoft.com...
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that
allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription
that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt
User check box in the Parameters properties page. However, a side effect of
clearing the check box was that you could no longer specify a parameter
value for the report at run time. This limitation has been removed. In SP1,
you can clear the Prompt User check box to hide the parameter fields and
values in the report. Doing so does not introduce restrictions on how you
subsequently set the parameter value externally at run time.
>
> "Jéjé" wrote:
> > You can hide a paremeter after you have deployed your report.
> > But hiding a parameter disallow you to pass any value to this parameter
> > through the URL!!!
> > The parameter is not simply hide to the user, is also completly
inaccessible
> > to the user through any URL, but just available to the administrator to
> > change the default value of the parameter.
> >
> >
> > "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> > news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > > Installed SP1, still finding not possible to hide a parameter. Can
someone
> > provide the process please. The parameter is an ID that is send via URL
to
> > the report server. I created a Report Parameter for it, then created a
> > queary parameter setting that to the incoming value of the Report
Parameter.
> > Help please
> >
> >
> >|||Ok..
Now i have to create a subscription with specific parameters for this subscription and then i should uncheck Promt User checkbox?
Is that right?
The result report i'll use the parameter without problems?
"Eddie" wrote:
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
> Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.
Monday, March 26, 2012
Hidden Parrameters
Hi,
I want to send to my Report hidden parameters by Url.
I read that in order to do so I need to check the Prompt User checkbox
and clear the Prompt string.
But I can't find the Prompt User checkbox in the Report Parameters window.
I installed SP1, but still I can't find this checkbox.
Where is it?
Thanks,
LimorHi Limor,
You can define a parameter as a hidden parameter on the Report Server where
you deploy it.
Unfortunately this is a minus point for RS since the hidden parameters are
first introduced with Service Pack 1
You just go to the Report Properties Tab on the Report Server for that report.
Select Parameters from the left menu.
When you click it then the list of parameters will be displayed. You will
see the "Prompt User" checkbox there.
Eralper
http://www.kodyaz.com
"Limor Bellison" wrote:
> Hi,
> I want to send to my Report hidden parameters by Url.
> I read that in order to do so I need to check the Prompt User checkbox
> and clear the Prompt string.
> But I can't find the Prompt User checkbox in the Report Parameters window.
> I installed SP1, but still I can't find this checkbox.
> Where is it?
> Thanks,
> Limor
>|||Hi eralper,
Thanx for your fast response.
I did exactly what you told me and get into the Parameters window,
but there is no "Prompt User" checkbox.
Do you want me to send you a print screen of this window to your email?
Limor
"eralper" wrote:
> Hi Limor,
> You can define a parameter as a hidden parameter on the Report Server where
> you deploy it.
> Unfortunately this is a minus point for RS since the hidden parameters are
> first introduced with Service Pack 1
> You just go to the Report Properties Tab on the Report Server for that report.
> Select Parameters from the left menu.
> When you click it then the list of parameters will be displayed. You will
> see the "Prompt User" checkbox there.
> Eralper
> http://www.kodyaz.com
>
> "Limor Bellison" wrote:
> > Hi,
> > I want to send to my Report hidden parameters by Url.
> > I read that in order to do so I need to check the Prompt User checkbox
> > and clear the Prompt string.
> > But I can't find the Prompt User checkbox in the Report Parameters window.
> > I installed SP1, but still I can't find this checkbox.
> > Where is it?
> >
> > Thanks,
> >
> > Limor
> >|||Hi Limor,
I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
subject and attached two images. One for the settings and the other is for
sending the hidden parameter by url
"Limor Bellison" wrote:
> Hi eralper,
> Thanx for your fast response.
> I did exactly what you told me and get into the Parameters window,
> but there is no "Prompt User" checkbox.
> Do you want me to send you a print screen of this window to your email?
> Limor
>
> "eralper" wrote:
> > Hi Limor,
> >
> > You can define a parameter as a hidden parameter on the Report Server where
> > you deploy it.
> >
> > Unfortunately this is a minus point for RS since the hidden parameters are
> > first introduced with Service Pack 1
> >
> > You just go to the Report Properties Tab on the Report Server for that report.
> > Select Parameters from the left menu.
> > When you click it then the list of parameters will be displayed. You will
> > see the "Prompt User" checkbox there.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> >
> > "Limor Bellison" wrote:
> >
> > > Hi,
> > > I want to send to my Report hidden parameters by Url.
> > > I read that in order to do so I need to check the Prompt User checkbox
> > > and clear the Prompt string.
> > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > I installed SP1, but still I can't find this checkbox.
> > > Where is it?
> > >
> > > Thanks,
> > >
> > > Limor
> > >|||Thank you, this is exactly what I needed.
My mistake was that I was trying to do it from the visual studio instead of
the Report Manager. Now it's working.
Thanx,
Limor
"eralper" wrote:
> Hi Limor,
> I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
> subject and attached two images. One for the settings and the other is for
> sending the hidden parameter by url
>
> "Limor Bellison" wrote:
> > Hi eralper,
> > Thanx for your fast response.
> > I did exactly what you told me and get into the Parameters window,
> > but there is no "Prompt User" checkbox.
> > Do you want me to send you a print screen of this window to your email?
> >
> > Limor
> >
> >
> > "eralper" wrote:
> >
> > > Hi Limor,
> > >
> > > You can define a parameter as a hidden parameter on the Report Server where
> > > you deploy it.
> > >
> > > Unfortunately this is a minus point for RS since the hidden parameters are
> > > first introduced with Service Pack 1
> > >
> > > You just go to the Report Properties Tab on the Report Server for that report.
> > > Select Parameters from the left menu.
> > > When you click it then the list of parameters will be displayed. You will
> > > see the "Prompt User" checkbox there.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > >
> > > "Limor Bellison" wrote:
> > >
> > > > Hi,
> > > > I want to send to my Report hidden parameters by Url.
> > > > I read that in order to do so I need to check the Prompt User checkbox
> > > > and clear the Prompt string.
> > > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > > I installed SP1, but still I can't find this checkbox.
> > > > Where is it?
> > > >
> > > > Thanks,
> > > >
> > > > Limor
> > > >
I want to send to my Report hidden parameters by Url.
I read that in order to do so I need to check the Prompt User checkbox
and clear the Prompt string.
But I can't find the Prompt User checkbox in the Report Parameters window.
I installed SP1, but still I can't find this checkbox.
Where is it?
Thanks,
LimorHi Limor,
You can define a parameter as a hidden parameter on the Report Server where
you deploy it.
Unfortunately this is a minus point for RS since the hidden parameters are
first introduced with Service Pack 1
You just go to the Report Properties Tab on the Report Server for that report.
Select Parameters from the left menu.
When you click it then the list of parameters will be displayed. You will
see the "Prompt User" checkbox there.
Eralper
http://www.kodyaz.com
"Limor Bellison" wrote:
> Hi,
> I want to send to my Report hidden parameters by Url.
> I read that in order to do so I need to check the Prompt User checkbox
> and clear the Prompt string.
> But I can't find the Prompt User checkbox in the Report Parameters window.
> I installed SP1, but still I can't find this checkbox.
> Where is it?
> Thanks,
> Limor
>|||Hi eralper,
Thanx for your fast response.
I did exactly what you told me and get into the Parameters window,
but there is no "Prompt User" checkbox.
Do you want me to send you a print screen of this window to your email?
Limor
"eralper" wrote:
> Hi Limor,
> You can define a parameter as a hidden parameter on the Report Server where
> you deploy it.
> Unfortunately this is a minus point for RS since the hidden parameters are
> first introduced with Service Pack 1
> You just go to the Report Properties Tab on the Report Server for that report.
> Select Parameters from the left menu.
> When you click it then the list of parameters will be displayed. You will
> see the "Prompt User" checkbox there.
> Eralper
> http://www.kodyaz.com
>
> "Limor Bellison" wrote:
> > Hi,
> > I want to send to my Report hidden parameters by Url.
> > I read that in order to do so I need to check the Prompt User checkbox
> > and clear the Prompt string.
> > But I can't find the Prompt User checkbox in the Report Parameters window.
> > I installed SP1, but still I can't find this checkbox.
> > Where is it?
> >
> > Thanks,
> >
> > Limor
> >|||Hi Limor,
I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
subject and attached two images. One for the settings and the other is for
sending the hidden parameter by url
"Limor Bellison" wrote:
> Hi eralper,
> Thanx for your fast response.
> I did exactly what you told me and get into the Parameters window,
> but there is no "Prompt User" checkbox.
> Do you want me to send you a print screen of this window to your email?
> Limor
>
> "eralper" wrote:
> > Hi Limor,
> >
> > You can define a parameter as a hidden parameter on the Report Server where
> > you deploy it.
> >
> > Unfortunately this is a minus point for RS since the hidden parameters are
> > first introduced with Service Pack 1
> >
> > You just go to the Report Properties Tab on the Report Server for that report.
> > Select Parameters from the left menu.
> > When you click it then the list of parameters will be displayed. You will
> > see the "Prompt User" checkbox there.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> >
> > "Limor Bellison" wrote:
> >
> > > Hi,
> > > I want to send to my Report hidden parameters by Url.
> > > I read that in order to do so I need to check the Prompt User checkbox
> > > and clear the Prompt string.
> > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > I installed SP1, but still I can't find this checkbox.
> > > Where is it?
> > >
> > > Thanks,
> > >
> > > Limor
> > >|||Thank you, this is exactly what I needed.
My mistake was that I was trying to do it from the visual studio instead of
the Report Manager. Now it's working.
Thanx,
Limor
"eralper" wrote:
> Hi Limor,
> I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
> subject and attached two images. One for the settings and the other is for
> sending the hidden parameter by url
>
> "Limor Bellison" wrote:
> > Hi eralper,
> > Thanx for your fast response.
> > I did exactly what you told me and get into the Parameters window,
> > but there is no "Prompt User" checkbox.
> > Do you want me to send you a print screen of this window to your email?
> >
> > Limor
> >
> >
> > "eralper" wrote:
> >
> > > Hi Limor,
> > >
> > > You can define a parameter as a hidden parameter on the Report Server where
> > > you deploy it.
> > >
> > > Unfortunately this is a minus point for RS since the hidden parameters are
> > > first introduced with Service Pack 1
> > >
> > > You just go to the Report Properties Tab on the Report Server for that report.
> > > Select Parameters from the left menu.
> > > When you click it then the list of parameters will be displayed. You will
> > > see the "Prompt User" checkbox there.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > >
> > > "Limor Bellison" wrote:
> > >
> > > > Hi,
> > > > I want to send to my Report hidden parameters by Url.
> > > > I read that in order to do so I need to check the Prompt User checkbox
> > > > and clear the Prompt string.
> > > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > > I installed SP1, but still I can't find this checkbox.
> > > > Where is it?
> > > >
> > > > Thanks,
> > > >
> > > > Limor
> > > >
Subscribe to:
Posts (Atom)