Friday, March 30, 2012
Hide Parameters issue : Where is the "Prompt User" checkbox
about the SP1 and the "Prompt User" check box. I have SP1 installed.
But I cannot see "Prompt User" checkbox anywhere either in the
ReportManager or the VS.NET Report Designer.
I've been pulling my hair all day. Please let me know how can I get to
that "Prompt User" checkbox. Where is it ?
thanks
Anand SagarThere is not a check box. Make sure your report is highlighted. Click on
the Report option in the menu. Select properties. To set a parameter as
hidden, you have to delete all the text in the "Prompt:" textbox. Once you
do that, you will not see a prompt for the user to enter data for that
parameter. This is all that is needed to "hide" parameters from the end user.
"Anand Sagar" wrote:
> I have a problem of hiding a few of my parameters. People are talking
> about the SP1 and the "Prompt User" check box. I have SP1 installed.
> But I cannot see "Prompt User" checkbox anywhere either in the
> ReportManager or the VS.NET Report Designer.
> I've been pulling my hair all day. Please let me know how can I get to
> that "Prompt User" checkbox. Where is it ?
>
> thanks
> Anand Sagar
>|||There is a "Prompt User" check box in SP1. When you've uploaded your report
to the Report Manager, you'll need to edit the "Parameters" properties.
Check the "Prompt User" check box, then empty out the Prompt String text
box. This allows the parameter to be hidden from the user, but still
updateable by the report.
HTH,
Brian
"bspann" <bspann@.discussions.microsoft.com> wrote in message
news:1F78D438-DDE9-4725-A474-A7BC7FDE880D@.microsoft.com...
> There is not a check box. Make sure your report is highlighted. Click on
> the Report option in the menu. Select properties. To set a parameter as
> hidden, you have to delete all the text in the "Prompt:" textbox. Once
you
> do that, you will not see a prompt for the user to enter data for that
> parameter. This is all that is needed to "hide" parameters from the end
user.
> "Anand Sagar" wrote:
> > I have a problem of hiding a few of my parameters. People are talking
> > about the SP1 and the "Prompt User" check box. I have SP1 installed.
> > But I cannot see "Prompt User" checkbox anywhere either in the
> > ReportManager or the VS.NET Report Designer.
> > I've been pulling my hair all day. Please let me know how can I get to
> > that "Prompt User" checkbox. Where is it ?
> >
> >
> > thanks
> > Anand Sagar
> >|||In Report Manager, select the report, select the properties tab, select the
parameters sub-tab.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"bspann" <bspann@.discussions.microsoft.com> wrote in message
news:1F78D438-DDE9-4725-A474-A7BC7FDE880D@.microsoft.com...
> There is not a check box. Make sure your report is highlighted. Click on
> the Report option in the menu. Select properties. To set a parameter as
> hidden, you have to delete all the text in the "Prompt:" textbox. Once
you
> do that, you will not see a prompt for the user to enter data for that
> parameter. This is all that is needed to "hide" parameters from the end
user.
> "Anand Sagar" wrote:
> > I have a problem of hiding a few of my parameters. People are talking
> > about the SP1 and the "Prompt User" check box. I have SP1 installed.
> > But I cannot see "Prompt User" checkbox anywhere either in the
> > ReportManager or the VS.NET Report Designer.
> > I've been pulling my hair all day. Please let me know how can I get to
> > that "Prompt User" checkbox. Where is it ?
> >
> >
> > thanks
> > Anand Sagar
> >sql
Hide Parameters from User.
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
>
Monday, March 26, 2012
Hidden Parrameters
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
> > > >
Friday, March 23, 2012
hidden parameters are not hidden
I've created a report with a parameter with no prompt ( hidden ) and a
second one with a prompt. When I switch to preview in Visual Studio only the
second parameter appears. This is OK.
When I launch the report in IE :
http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&Param2=2
both parameters appear in the parameter section !?!From the SP1 readme:
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.
--
| Thread-Topic: hidden parameters are not hidden
| thread-index: AcTjhM6KynxAWJglRZyZ76tv0LGvGQ==| X-WBNR-Posting-Host: 198.240.212.30
| From: "=?Utf-8?B?UGFzY2FsIFNpbWxlcg==?=" <Pascal
Simler@.discussions.microsoft.com>
| Subject: hidden parameters are not hidden
| Date: Thu, 16 Dec 2004 07:35:01 -0800
| Lines: 9
| Message-ID: <7E509939-5E13-4BBD-987D-F73CA24397CE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:37567
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello,
|
| I've created a report with a parameter with no prompt ( hidden ) and a
| second one with a prompt. When I switch to preview in Visual Studio only
the
| second parameter appears. This is OK.
| When I launch the report in IE :
| http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&Param2=2
| both parameters appear in the parameter section !?!
|
||||Brad, are you aware of any probelms when using hidden parameters along with
prompted credentials? The result I encounter when attempting this is that RS
continually prompts for credentials rather than proceeding to view the
report...
""Brad Syputa - MS"" wrote:
> From the SP1 readme:
> 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.
> --
> | Thread-Topic: hidden parameters are not hidden
> | thread-index: AcTjhM6KynxAWJglRZyZ76tv0LGvGQ==> | X-WBNR-Posting-Host: 198.240.212.30
> | From: "=?Utf-8?B?UGFzY2FsIFNpbWxlcg==?=" <Pascal
> Simler@.discussions.microsoft.com>
> | Subject: hidden parameters are not hidden
> | Date: Thu, 16 Dec 2004 07:35:01 -0800
> | Lines: 9
> | Message-ID: <7E509939-5E13-4BBD-987D-F73CA24397CE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:37567
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hello,
> |
> | I've created a report with a parameter with no prompt ( hidden ) and a
> | second one with a prompt. When I switch to preview in Visual Studio only
> the
> | second parameter appears. This is OK.
> | When I launch the report in IE :
> | http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&Param2=2
> | both parameters appear in the parameter section !?!
> |
> |
>
hi,Re: Unable to get SQLCMD utility to work properly.
I try to go to a command prompt to get this to run right with no luck. Is there something that I am not doing right? It gives me the help library, but thats about it. Also, I have dealt with Oracle in the past. And was wondering is there a way to access the SQLCMD utility on a workstation with a login of some kind?
--David
hi David,
SqlCMD accepts a list of parameters as described in http://msdn2.microsoft.com/en-us/library/ms165702.aspx and at http://msdn2.microsoft.com/en-us/library/ms170207.aspx you can find a tutorial about it's use...
usually you open a command prompt window and provide the appropriate connection parameters, like
c:\Document and settings\user>sqlcmd -E -S.\SQLExpress
this tries a trusted connection to the local SQLExpress named instance...
if you got it succesfully you get a prompt like
1>
qhere you can just type your Transact-SQL statements..
regards