Greetings,
i'm using ms ReportViewer which was provided. heres the deal, in my report
parameters if i leave "prompt" empty and unchecked "allow null value" and
click in preview, i do not see the parameters being shown at the header.
WHICH IS WHAT I WANT. GOOD. but then, if i were to use the report viewer in
the web enviroment, and having set Parameters=true OR false makes not
difference... with true it still shows the parameter as textbox and if i set
it to false, my other parameter will not be visiable. so i NEED to set it to
TRUE.
can someone please advice me?
thanks.
Asha.You need to go to the properties tab of the report in ReportManager. Click
the parameters sub tab. For the parameter you want hidden, make sure
'Prompt User' is checked and that there is no prompt string.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Asha" <Asha@.discussions.microsoft.com> wrote in message
news:A957E9D1-DE64-4158-A4B2-1651AF467E87@.microsoft.com...
> Greetings,
> i'm using ms ReportViewer which was provided. heres the deal, in my report
> parameters if i leave "prompt" empty and unchecked "allow null value" and
> click in preview, i do not see the parameters being shown at the header.
> WHICH IS WHAT I WANT. GOOD. but then, if i were to use the report viewer
in
> the web enviroment, and having set Parameters=true OR false makes not
> difference... with true it still shows the parameter as textbox and if i
set
> it to false, my other parameter will not be visiable. so i NEED to set it
to
> TRUE.
> can someone please advice me?
> thanks.
> Asha.sql
Showing posts with label heres. Show all posts
Showing posts with label heres. Show all posts
Monday, March 26, 2012
Monday, February 20, 2012
Report Security
Ok heres the problem...
I have been requested to have some security 'features' included in my reports.
The main requirements are:
1 - Remove the address bar at the top, as the user will be able to alter
parameters in here.
2 - Disable the F11 key. this is because even if the report opens with no
addres bar present in a simple window, they can still press F11 and it will
return. pressing this key restores the toolbar and URL.
3 - Disable Right Click, as they user can then view the source, and
therefore view the address, with parameters.
The whole point is to disable the alteration of parameters in the reports.
Any ideas?
Thanks in advance, Rob.How are the reports parameterized in the first place?
You could put all parameters into dropdownlists, if the users should be able
to choose some parameters. This way your report just won't render if they
try to hard code the parameter through the URL. THis would solve most of
your problems, I think.
If your users are not supposed to change any parameters, you could create a
parameter table in the data source data base, which gives you a set of
parameters that each user is supposed to see. No way to change it on the
outside, but a bit more for the report administrator or someone else to do.
Kaisa M. Lindahl Lervik
"MACNR" <MACNR@.discussions.microsoft.com> wrote in message
news:9FCABD33-168F-4487-A2DC-41E40D82FA1D@.microsoft.com...
> Ok heres the problem...
> I have been requested to have some security 'features' included in my
> reports.
> The main requirements are:
> 1 - Remove the address bar at the top, as the user will be able to alter
> parameters in here.
> 2 - Disable the F11 key. this is because even if the report opens with no
> addres bar present in a simple window, they can still press F11 and it
> will
> return. pressing this key restores the toolbar and URL.
> 3 - Disable Right Click, as they user can then view the source, and
> therefore view the address, with parameters.
> The whole point is to disable the alteration of parameters in the reports.
> Any ideas?
> Thanks in advance, Rob.
I have been requested to have some security 'features' included in my reports.
The main requirements are:
1 - Remove the address bar at the top, as the user will be able to alter
parameters in here.
2 - Disable the F11 key. this is because even if the report opens with no
addres bar present in a simple window, they can still press F11 and it will
return. pressing this key restores the toolbar and URL.
3 - Disable Right Click, as they user can then view the source, and
therefore view the address, with parameters.
The whole point is to disable the alteration of parameters in the reports.
Any ideas?
Thanks in advance, Rob.How are the reports parameterized in the first place?
You could put all parameters into dropdownlists, if the users should be able
to choose some parameters. This way your report just won't render if they
try to hard code the parameter through the URL. THis would solve most of
your problems, I think.
If your users are not supposed to change any parameters, you could create a
parameter table in the data source data base, which gives you a set of
parameters that each user is supposed to see. No way to change it on the
outside, but a bit more for the report administrator or someone else to do.
Kaisa M. Lindahl Lervik
"MACNR" <MACNR@.discussions.microsoft.com> wrote in message
news:9FCABD33-168F-4487-A2DC-41E40D82FA1D@.microsoft.com...
> Ok heres the problem...
> I have been requested to have some security 'features' included in my
> reports.
> The main requirements are:
> 1 - Remove the address bar at the top, as the user will be able to alter
> parameters in here.
> 2 - Disable the F11 key. this is because even if the report opens with no
> addres bar present in a simple window, they can still press F11 and it
> will
> return. pressing this key restores the toolbar and URL.
> 3 - Disable Right Click, as they user can then view the source, and
> therefore view the address, with parameters.
> The whole point is to disable the alteration of parameters in the reports.
> Any ideas?
> Thanks in advance, Rob.
Subscribe to:
Posts (Atom)