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