Showing posts with label designer. Show all posts
Showing posts with label designer. Show all posts

Monday, March 26, 2012

Hidden/Read-only parameters in Report Designer

This question was never clearly answered, so here's what works for me:
In Report Designer:
To make a parameter read-only and hidden, leave the Prompt box blank.
To make a parameter hidden but not read-only, type a space in the Prompt box.
If there's another way, please let me know.
Chrissie"To make a parameter hidden but not read-only, type a space in the Prompt
box."
I can't get this to work... it then seems to put in the name of the param as
the prompt.
Are you sure about this? Have you applied the service patch? Just
checking?
Thanks for any help,
Alan Smith.
"Chrissie" <Chrissie@.discussions.microsoft.com> wrote in message
news:D002CF70-3C1E-4EFA-9EBB-4D2CAAD5EECC@.microsoft.com...
> This question was never clearly answered, so here's what works for me:
> In Report Designer:
> To make a parameter read-only and hidden, leave the Prompt box blank.
> To make a parameter hidden but not read-only, type a space in the Prompt
box.
> If there's another way, please let me know.
> Chrissie|||We don't support hidden parameters in Report Designer even in SP1. This is a server-side only
feature.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alan Smith" <nospam@.nospam.com> wrote in message news:unxCBuRiEHA.1040@.TK2MSFTNGP09.phx.gbl...
> "To make a parameter hidden but not read-only, type a space in the Prompt
> box."
> I can't get this to work... it then seems to put in the name of the param as
> the prompt.
> Are you sure about this? Have you applied the service patch? Just
> checking?
> Thanks for any help,
> Alan Smith.
> "Chrissie" <Chrissie@.discussions.microsoft.com> wrote in message
> news:D002CF70-3C1E-4EFA-9EBB-4D2CAAD5EECC@.microsoft.com...
> > This question was never clearly answered, so here's what works for me:
> >
> > In Report Designer:
> > To make a parameter read-only and hidden, leave the Prompt box blank.
> > To make a parameter hidden but not read-only, type a space in the Prompt
> box.
> >
> > If there's another way, please let me know.
> > Chrissie
>

Friday, March 23, 2012

Hidden parameters and defaults using Globals

Hi,
Firstly, I would like to know if there are any intentions to allow you
to hide parameters from the report designer, without having to log into
Report Manager after deployment and fiddle around?
Secondly, I have a problem. I have a report with 2 parameters. One
(userID) I want to set via URL string and one (reportDate) I want to
default to todays date. In the designer, I set the default for
reportDate to Globals!ExecutionTime. I then deploy my report. I now
want to be able to access the report in Report Manager and set the
Prompt string for userID to blank but I can't save this change unless I
either (a) uncheck the default box for reportDate or (b) give
reportDate a static default. Is there any way around this?
Thanks,
JoPlease check this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=2820671f-d7f0-46ee-a857-a2f048fd0cd5&sloc=en-us
It will also explain how to setup the UserID parameter so that you don't
need to change it in report manager afterwards.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
<tinyjo@.gmail.com> wrote in message
news:1116253063.200357.225100@.g47g2000cwa.googlegroups.com...
> Hi,
> Firstly, I would like to know if there are any intentions to allow you
> to hide parameters from the report designer, without having to log into
> Report Manager after deployment and fiddle around?
> Secondly, I have a problem. I have a report with 2 parameters. One
> (userID) I want to set via URL string and one (reportDate) I want to
> default to todays date. In the designer, I set the default for
> reportDate to Globals!ExecutionTime. I then deploy my report. I now
> want to be able to access the report in Report Manager and set the
> Prompt string for userID to blank but I can't save this change unless I
> either (a) uncheck the default box for reportDate or (b) give
> reportDate a static default. Is there any way around this?
> Thanks,
> Jo
>