Maintaining tablix width when hiding some columns in rdlc report

Question

In our project, we got some rdl files that contains dynamic column, User can decide which to show or which to hide by a Multi-Selection Report Parameter. then it comes some problems: 1.if there is a report contains 10 columns, when the user selected 5 columns to show ,and other columns to hide, the right half page were blank. so what we need is that we can dynamically change rdlc table size by user's selection or configuration. how to resolve it ? Report's tablix have no Expression input, can it be dynamically?

thanks in advance

Answer 1

The questions seems to be related to SSRS, so you might need to use "Sql-Server-Reporting-Services" tag and not WPF tag.

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

You can't set column width to be dynamic, it's a fixed value.
However.
The rdl file is xml.
If this is a desktop app you can manipulate the values in the rdl.
Perhaps keep an original version and save an edited file to disk. Then use that edited version to run the report.

Answer 3

Hi,
The column width in Report design can only use fixed size.
We could not make it dynamic or use expression for it. It is by design.