Showing posts with label hidden. Show all posts
Showing posts with label hidden. Show all posts

Friday, March 30, 2012

Report Detail Sections will not expand

I have a report that has a detail section hidden until the user clicks
the '+' sign to expand it and see the details. This has worked in the
past and works in design view for this report, however when deployed to
report manager and brought up in IE it will not expand. I have tried
deleting the report from the report manager and then re-deploying but
this doesnt work. Does anyone have a similar experience or know how to
fix this?I have just found out that it is doing this for all reports that have
the '+' sign that lets the user choose to see detail. Only thing that
has changed is that we changed our report server to the full license
when our trial expired. If anyone can help I would greatly appreciate
it.|||I have the same problem. If you have solved the problem, please post the
resolution. Thanks.
<barhoc11@.gmail.com> wrote in message
news:1129901639.084816.251550@.f14g2000cwb.googlegroups.com...
>I have just found out that it is doing this for all reports that have
> the '+' sign that lets the user choose to see detail. Only thing that
> has changed is that we changed our report server to the full license
> when our trial expired. If anyone can help I would greatly appreciate
> it.
>

Wednesday, March 28, 2012

Report deployment with RS2k, SP1

Hello,
I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
have only hidden parameters (parameters with a prompt blank).
When I deploy from VS. NET 2003 to an empty folder on my RS server, the
prompts reappear and the checkbox "prompt user" is unchecked. That means
read only parameters and my reports return an error. The only way to correct
that is to manualy change the checkbox.
After the first deployment, each time I deploy the same reports (I replace
the existing), the checks stay but the prompt reappear. I have 15 reports
with 5-10 parameters on 3 environments (dev, qa, prod) and after each
deployment, I have to manualy remove the prompt..... I get crazy....
If someone have some experience with that problem or a workaround, don't
hesitate...
Thanks in adavance
LaurentHi,
have you tried rs.CreateReport with overwrite properties so that you can
overwrite all the parameter and report properties..
when i do upgrade i use this property to overwrite report in the script..
Bava
"Laurent" wrote:
> Hello,
> I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
> have only hidden parameters (parameters with a prompt blank).
> When I deploy from VS. NET 2003 to an empty folder on my RS server, the
> prompts reappear and the checkbox "prompt user" is unchecked. That means
> read only parameters and my reports return an error. The only way to correct
> that is to manualy change the checkbox.
> After the first deployment, each time I deploy the same reports (I replace
> the existing), the checks stay but the prompt reappear. I have 15 reports
> with 5-10 parameters on 3 environments (dev, qa, prod) and after each
> deployment, I have to manualy remove the prompt..... I get crazy....
> If someone have some experience with that problem or a workaround, don't
> hesitate...
> Thanks in adavance
> Laurent
>
>sql