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 static columns to the right side of a Matrix report

Hi all,
I'm trying to figure out how to add static columns to a matrix report
in reporting services 2005. i have a matrix where the columns can be
dynamic (1 to n columns) and in addition to the row columns on the far
left i also need to place columns on the right as well. So it would
look like this:
matrixcol1 matrixcol2 staticcol1, staticcoln...
row 1 # # label1 label_2_1
row 2 # # label2 label_2_2
I got the report to display the data by embedding a matrix in a list
but for each row the columns for the matrix do not line up as
matrixco1, 2.. is different for each row. -THanks!On Jun 7, 2:29 pm, dfate...@.gmail.com wrote:
> Hi all,
> I'm trying to figure out how to add static columns to a matrix report
> in reporting services 2005. i have a matrix where the columns can be
> dynamic (1 to n columns) and in addition to the row columns on the far
> left i also need to place columns on the right as well. So it would
> look like this:
> matrixcol1 matrixcol2 staticcol1, staticcoln...
> row 1 # # label1 label_2_1
> row 2 # # label2 label_2_2
> I got the report to display the data by embedding a matrix in a list
> but for each row the columns for the matrix do not line up as
> matrixco1, 2.. is different for each row. -THanks!
I normally handle this by placing an empty space in front of the
columns I want to appear first (on the left) in the matrix (i.e., (" "
+ ColumnNameToBePivoted)) and then have the columns I want at the end
(on the right) just be their regular names. That way, alphabetically,
the spaced columns will come first. Of course, you will want to do
this in the stored procedure/query that is sourcing the report. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Adding static columns to a matrix report?

So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
want to do.
__________|Item Code|Description | Column Group -->
Row Group| | |
---
| | |
|
|
\/
I can get it all working, except for the "Description" column. What I have
now is
__________|Item Code| Column Group -->
Row Group| |
---
| |
|
|
\/
Which works fine. I cannot, for the life of me, add another "static" column
for the Description (that does not get repeated with the column group). I
hope this is clear enough for someone to offer me a suggestion, and I hope
posting doesnt mess up the linbreaks... Thanks in advance!
Peter L.Try this ..
Right click on filed below column group. choose add row.
It will add new column on left. Then delete the cell below the column field.
which will delete added row below but coloum on left will remain as it is.
"plandry@.newsgroups.nospam" wrote:
> So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
> want to do.
> __________|Item Code|Description | Column Group -->
> Row Group| | |
> ---
> | | |
> |
> |
> \/
> I can get it all working, except for the "Description" column. What I have
> now is
> __________|Item Code| Column Group -->
> Row Group| |
> ---
> | |
> |
> |
> \/
> Which works fine. I cannot, for the life of me, add another "static" column
> for the Description (that does not get repeated with the column group). I
> hope this is clear enough for someone to offer me a suggestion, and I hope
> posting doesnt mess up the linbreaks... Thanks in advance!
> Peter L.|||That only adds another row below... I think that's how I got the first Item
Code column. It just won't let me add another column, no matter how many rows
I add...
"Vinay" wrote:
> Try this ..
> Right click on filed below column group. choose add row.
> It will add new column on left. Then delete the cell below the column field.
> which will delete added row below but coloum on left will remain as it is.
>
> "plandry@.newsgroups.nospam" wrote:
> > So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
> > want to do.
> >
> > __________|Item Code|Description | Column Group -->
> > Row Group| | |
> > ---
> > | | |
> >
> > |
> > |
> > \/
> >
> > I can get it all working, except for the "Description" column. What I have
> > now is
> >
> > __________|Item Code| Column Group -->
> > Row Group| |
> > ---
> > | |
> >
> > |
> > |
> > \/
> >
> > Which works fine. I cannot, for the life of me, add another "static" column
> > for the Description (that does not get repeated with the column group). I
> > hope this is clear enough for someone to offer me a suggestion, and I hope
> > posting doesnt mess up the linbreaks... Thanks in advance!
> >
> > Peter L.