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 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 Parameters

Is it easy to hide the parameters of a report? Im using the ReportViewer tag in asp.net and I have my own parameters that I am passing into my report. But when the report renders, it shows the default parameters that look terrible in my application.

I was wondering if there was a way to only have my own parameters showing?

Thanks in advance everyone
man, just after I posted this I found the exact thing I wanted, the code is as follows:

reportViewer.Parameters = Microsoft.Samples.ReportingServices.ReportViewer.multiState.False;