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
>
No comments:
Post a Comment