Adjusting reportwidth dynamically.. please help me

hi,

I am new to reporting services.I am using sqlserver Reporting services to generate Report.I have designed a static RDL file based on a view which contains 40 columns..i included all the 40 column in rdl file..i have used hidden field expressions for hiding columns..Now at run time if i select three columns for generating report, The remaining hidden column spaces are still there in the report ... The report width is not adjusting to the selected column width... how to eliminate the hidden column spaces in the report.Please help me..it is really urgent for me..

Thanks in advance...

You can change the width of the ReportViewer in the Load() event like so...

ReportViewer1.Width=500

I think if you try to do it in another event it has no effect becasue the size has already been rendered.

Good luck.

|||

try to set the width = "auto"

Adding RDL to manager via .NET

Hi
is it possible to add a RDL-Report via a Window-Application to the report manager?
Thanks in advance!
Regards
AlexConsier using an RSS file with RS.exe, if you're okay with doing this via command-line
--
Message posted via http://www.sqlmonster.com

Adding new web.config custom section

Hello All,
I want to add custom cofiguration section to the report server web.config
and use this configuration from the RDL, can it be done? and if the answer is
yes, how it can be done.
Thank youOn Oct 7, 1:21 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> Hello All,
> I want to add custom cofiguration section to the report server web.config
> and use this configuration from the RDL, can it be done? and if the answer is
> yes, how it can be done.
> Thank you
You might be able to reference the Web config file from custom code in
the report (via: Layout view >> Report drop-down >> Report
Properties... >> Code tab). You might be able to reference it via a
call to Configurations.AppSettings(...). Of course this is a long
shot. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thank you,
i will be thankful if you can give me an example f custom configuration
section for the web.config
"EMartinez" wrote:
> On Oct 7, 1:21 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> > Hello All,
> >
> > I want to add custom cofiguration section to the report server web.config
> > and use this configuration from the RDL, can it be done? and if the answer is
> > yes, how it can be done.
> >
> > Thank you
>
> You might be able to reference the Web config file from custom code in
> the report (via: Layout view >> Report drop-down >> Report
> Properties... >> Code tab). You might be able to reference it via a
> call to Configurations.AppSettings(...). Of course this is a long
> shot. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>