CODEWITHSUNDEEP
reporting-servicesssrs-2008
Gaddigesh
Gaddigesh

Reputation: 1953

Manually resize column width after report is rendered on the browser

Is it possible to let user resize the column width after report is rendered on browser?

enter image description here

Upvotes: 1

Views: 634

Answers (2)

Ron Smith
Ron Smith

Reputation: 3266

One sort of a hack way to do this would be to first include various widths of the same column and hide all but one based on a hidden parameter value. Then add a Jump to Report Action on the headers that reload the report with the updated parameter value.

For example, if you had 3 different column widths available for Column1, the value passed in the Jump to Report Action would be something like =iif(Parameters!Column1Width.Value + 1 > 3,1,Parameters!.Column1Width.Value + 1). Then set the Hidden attribute on the 3 Column1 columns to =Parameters!Column1Width.Value <> 1, =Parameters!Column1Width.Value <> 2, and =Parameters!Column1Width.Value <> 3 respectively.

Upvotes: 0

Nathan Griffiths
Nathan Griffiths

Reputation: 12776

Short answer: no. Once the report is rendered it is basically static (there are a couple of interactivity options, like sorting columns). You need to set the column width to an appropriate value up front, however (if allowed by your report server configuration) your users can export the report to Excel and adjust column widths there if required.

Upvotes: 1

Related Questions