Hiding UserID parameter

In my report I am using 4 parameters i.e UID, LocationID, StartDate and
EndDate.
I am passing the UID parameter to a report in a URL. Based on UID, Locations
will be displayed. I don't want to Show UID on the report parameters header,
But I want to show all other parameters on the report, so that the user can
select locations and StartDate and EndDate.
I have tried &rc:Parameters=false, but this is hiding all the parameters.
I want to Hide only one parameter i.e UID
Please help.Hi,
when you define your paramters within the "Report Parameters"-Window
leave the "Prompt" field of the UID empty.
So it won't be presented to the user parameter but it's still
accessible within your reports.
By the way, if you want to use the current login user (often NT
account) then you could also use the RS internal User!UserID variable.
best regards
BB|||Hi BB
Many thnx for your quick response.
I have applied your logic.
when the "Prompt" field of the UID empty, it does allow for saving the
report and follwoing error is coming
"c:\documents and settings\dimpu\my documents\visual studio
projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
DefaultValue that has both or neither of the following: Values and
DataSetReference. DefaultValue must have exactly one of these elements."
So I have selected a default value for UserID. then it is ok and retrieving
data for that default userid.
But we can not pass a different user through URL.
Suppose the default value for the UserID =100
I want to pass UserID = 101 through URL
then the following error is coming
The report parameter 'UserID' is read-only and cannot be modified.
(rsReadOnlyReportParameter) Get Online Help
"BB_Reporting" wrote:
> Hi,
> when you define your paramters within the "Report Parameters"-Window
> leave the "Prompt" field of the UID empty.
> So it won't be presented to the user parameter but it's still
> accessible within your reports.
> By the way, if you want to use the current login user (often NT
> account) then you could also use the RS internal User!UserID variable.
> best regards
> BB
>|||After you have removed your Promt of UID, please, add a "dummy" value
to List e.g 100 as well as an default value "100". That should work...
cheers
BB|||After you deploy the report, go to the Report Manager and view the parameters
for the report. For the UID parameter, make sure the Prompt String is empty
and that Prompt User is checked. This should fix the problem. When you set
the Prompt String to empty from VS, it sets Prompt User to unchecked when
deployed.
"dimpu" wrote:
> Hi BB
> Many thnx for your quick response.
> I have applied your logic.
> when the "Prompt" field of the UID empty, it does allow for saving the
> report and follwoing error is coming
> "c:\documents and settings\dimpu\my documents\visual studio
> projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
> DefaultValue that has both or neither of the following: Values and
> DataSetReference. DefaultValue must have exactly one of these elements."
> So I have selected a default value for UserID. then it is ok and retrieving
> data for that default userid.
> But we can not pass a different user through URL.
> Suppose the default value for the UserID =100
> I want to pass UserID = 101 through URL
> then the following error is coming
> The report parameter 'UserID' is read-only and cannot be modified.
> (rsReadOnlyReportParameter) Get Online Help
>
>
> "BB_Reporting" wrote:
> > Hi,
> >
> > when you define your paramters within the "Report Parameters"-Window
> > leave the "Prompt" field of the UID empty.
> >
> > So it won't be presented to the user parameter but it's still
> > accessible within your reports.
> >
> > By the way, if you want to use the current login user (often NT
> > account) then you could also use the RS internal User!UserID variable.
> >
> > best regards
> >
> > BB
> >
> >|||can you set the Prompt String from another parameter?
IIF(Parameter!A="A",Paramter!B.PromptString="",Paramter!B.PromptString="Something")?
"David Siebert" <DavidSiebert@.discussions.microsoft.com> wrote in message
news:4168C1A3-5098-4E43-BC86-01AAA8E40ED9@.microsoft.com...
> After you deploy the report, go to the Report Manager and view the
> parameters
> for the report. For the UID parameter, make sure the Prompt String is
> empty
> and that Prompt User is checked. This should fix the problem. When you
> set
> the Prompt String to empty from VS, it sets Prompt User to unchecked when
> deployed.
> "dimpu" wrote:
>> Hi BB
>> Many thnx for your quick response.
>> I have applied your logic.
>> when the "Prompt" field of the UID empty, it does allow for saving the
>> report and follwoing error is coming
>> "c:\documents and settings\dimpu\my documents\visual studio
>> projects\fsreports\CustomerReport.rdl The report parameter 'UID' has a
>> DefaultValue that has both or neither of the following: Values and
>> DataSetReference. DefaultValue must have exactly one of these elements."
>> So I have selected a default value for UserID. then it is ok and
>> retrieving
>> data for that default userid.
>> But we can not pass a different user through URL.
>> Suppose the default value for the UserID =100
>> I want to pass UserID = 101 through URL
>> then the following error is coming
>> The report parameter 'UserID' is read-only and cannot be modified.
>> (rsReadOnlyReportParameter) Get Online Help
>>
>>
>> "BB_Reporting" wrote:
>> > Hi,
>> >
>> > when you define your paramters within the "Report Parameters"-Window
>> > leave the "Prompt" field of the UID empty.
>> >
>> > So it won't be presented to the user parameter but it's still
>> > accessible within your reports.
>> >
>> > By the way, if you want to use the current login user (often NT
>> > account) then you could also use the RS internal User!UserID variable.
>> >
>> > best regards
>> >
>> > BB
>> >
>> >|||Thnx David, Solved this problem now.
"David Siebert" wrote:
> After you deploy the report, go to the Report Manager and view the parameters
> for the report. For the UID parameter, make sure the Prompt String is empty
> and that Prompt User is checked. This should fix the problem. When you set
> the Prompt String to empty from VS, it sets Prompt User to unchecked when
> deployed.
> "dimpu" wrote:
> > Hi BB
> >
> > Many thnx for your quick response.
> >
> > I have applied your logic.
> >
> > when the "Prompt" field of the UID empty, it does allow for saving the
> > report and follwoing error is coming
> >
> > "c:\documents and settings\dimpu\my documents\visual studio
> > projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
> > DefaultValue that has both or neither of the following: Values and
> > DataSetReference. DefaultValue must have exactly one of these elements."
> >
> > So I have selected a default value for UserID. then it is ok and retrieving
> > data for that default userid.
> >
> > But we can not pass a different user through URL.
> >
> > Suppose the default value for the UserID =100
> >
> > I want to pass UserID = 101 through URL
> >
> > then the following error is coming
> >
> > The report parameter 'UserID' is read-only and cannot be modified.
> > (rsReadOnlyReportParameter) Get Online Help
> >
> >
> >
> >
> >
> > "BB_Reporting" wrote:
> >
> > > Hi,
> > >
> > > when you define your paramters within the "Report Parameters"-Window
> > > leave the "Prompt" field of the UID empty.
> > >
> > > So it won't be presented to the user parameter but it's still
> > > accessible within your reports.
> > >
> > > By the way, if you want to use the current login user (often NT
> > > account) then you could also use the RS internal User!UserID variable.
> > >
> > > best regards
> > >
> > > BB
> > >
> > >

Hiding URL from User

I have a web application written in ASP, not ASP.Net. We set up a page with an iframe that we populate the SSRS reports into. The url of the report is visible through a right click/properties. Is there a way to either disable the right click or hide the url?

you can disable the right click by adding oncontextmenu="return false" in the body tag:

<body oncontextmenu="return false">

Hiding Top Banner In Subscriptions

Hi there
Does anyone know how to hide the banner on the top of the subscriptions
page when you are viewing via a URL. I have managed it in the reports
by setting the parameters to false etc but cannot do it in the
subscriptions.
Thanks in advance
DaveI would like to second Dave's request for information. I am struggling with
the same problem.
Thanks,
Joe
"Bungle" wrote:
> Hi there
> Does anyone know how to hide the banner on the top of the subscriptions
> page when you are viewing via a URL. I have managed it in the reports
> by setting the parameters to false etc but cannot do it in the
> subscriptions.
> Thanks in advance
> Dave
>|||Add me in as well. I thought I figured this out once, but for the life of me
cannot get this to work anymore.
"Joe" wrote:
> I would like to second Dave's request for information. I am struggling with
> the same problem.
> Thanks,
> Joe
> "Bungle" wrote:
> > Hi there
> >
> > Does anyone know how to hide the banner on the top of the subscriptions
> > page when you are viewing via a URL. I have managed it in the reports
> > by setting the parameters to false etc but cannot do it in the
> > subscriptions.
> >
> > Thanks in advance
> >
> > Dave
> >
> >

Hiding Report Parameters ToolBar

Hi,
I am generating report using stored procedures. I am passing values to the
SP parameters for the report through URL. When I generate the report, the
parameters are being displayed in a toolbar at the top of the report. Is
there any way I can hide the parameter toolbox or parameter list while
generating the report.
Regards,
Sudhakara.T.P.Have you set the Report Parameters to Hidden?
daw
"Sudhakara.T.P." wrote:
> Hi,
> I am generating report using stored procedures. I am passing values to the
> SP parameters for the report through URL. When I generate the report, the
> parameters are being displayed in a toolbar at the top of the report. Is
> there any way I can hide the parameter toolbox or parameter list while
> generating the report.
> Regards,
> Sudhakara.T.P.|||Hi,
I just experienced the same issue for my reports and I found out there
is plenty of ways to work it out. Share with you my findings. Many thanks to
SSRS experts!!
1) Create a custom CSS file at \MSSQL\Reporting
Services\ReportServer\Styles\. Modify the .ToolbarRefresh or
.ToolbarParameters etc. Change display:inline to display:none. This is to
hide certain items/icons at Toolbar which is not frequently used. Then, set
your access url like :
http://server/reportserver?/reportname&rc:Stylesheet=MyStyle (without the
.css extension)
More reference at
http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx
2) Add &rc:Toolbar=false after your report url to hide the entire toolbar.
3) Add &rc:Parameters=false / &rc:Parameters=Collapsed after your report
url to hide parameters list only.
4) Clear the checkbox of Prompt User through Report
Manager>Properties>Parameters.
HTH.
regards,
sammy
"daw" wrote:
> Have you set the Report Parameters to Hidden?
> daw
> "Sudhakara.T.P." wrote:
> > Hi,
> > I am generating report using stored procedures. I am passing values to the
> > SP parameters for the report through URL. When I generate the report, the
> > parameters are being displayed in a toolbar at the top of the report. Is
> > there any way I can hide the parameter toolbox or parameter list while
> > generating the report.
> >
> > Regards,
> > Sudhakara.T.P.

Hiding report parameters

Hi,
Is there way to hide parameters passed from the URL and show parameters in a
report? Some people suggested me to use &rc:Parameters=false, this is not
working for me, I have 2 parameters passed via URL and 3 parameters in the
report, &rc:Parameters=false will hide all.
TIAhi Raymond,
On the Reports menu bar click report and then select Parameters. Select the
Hidden check box. Select this option if the parameter value should not appear
on the report. Although hidden parameters do not appear on a report, they can
be set in other ways (for example, in subscriptions and through URLs).
Regards,
--
http://www.Designing-Systems.com
Email. Support@.Designing-Systems.com
----
"Raymond Du" wrote:
> Hi,
> Is there way to hide parameters passed from the URL and show parameters in a
> report? Some people suggested me to use &rc:Parameters=false, this is not
> working for me, I have 2 parameters passed via URL and 3 parameters in the
> report, &rc:Parameters=false will hide all.
> TIA
>
>

Hiding Parts of a report.

I'm using a PageViewer control in SharePoint to view a Report in SQL Server,
so the URL that is pulling up is something like
http://servername/ReportServer/Pages/ReportViewer.aspx?%2fOceanSpray.SharePoint.OsciReports%2fSavings+By+Plant&rs:Command=Render
The report comes up and displays the report information the way that I want
it to, but what I would like to be able to do in some instance where I'm
doing this is to header the header information of the report. By the header
I'm refering to the Page Navigation, Zoom, Find, Export and Print Toolbar
that gets added above the report information.
Is there a way to remove this Toolbar?Search for URL Access in Books on line -.. The toolbar option ie
http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false
--
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.
"Paul" wrote:
> I'm using a PageViewer control in SharePoint to view a Report in SQL Server,
> so the URL that is pulling up is something like
> http://servername/ReportServer/Pages/ReportViewer.aspx?%2fOceanSpray.SharePoint.OsciReports%2fSavings+By+Plant&rs:Command=Render
> The report comes up and displays the report information the way that I want
> it to, but what I would like to be able to do in some instance where I'm
> doing this is to header the header information of the report. By the header
> I'm refering to the Page Navigation, Zoom, Find, Export and Print Toolbar
> that gets added above the report information.
> Is there a way to remove this Toolbar?

Hiding Parameters in Report

I'm using a URL to execute reports and I wish to have the parameters not displayed to the user. However, when I either uncheck the Promt User box or delete the prompt string, I get an error stating read only parameters can not be changed.
We have installed SP1 on the server so I thought this issue had been fixed.
TIA for any help.
Dave
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.If you don't want any parameters displayed to the user, add
rc:Parameters=false to the URL.
If you want only some of the parameters displayed, then for those that
should be hidden, make sure "Prompt User" is checked and the prompt string
is empty.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OA03nKUXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I'm using a URL to execute reports and I wish to have the parameters not
displayed to the user. However, when I either uncheck the Promt User box or
delete the prompt string, I get an error stating read only parameters can
not be changed.
> We have installed SP1 on the server so I thought this issue had been
fixed.
> TIA for any help.
> Dave
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.