Maintaining tablix width when hiding some columns in rdlc report

akshay kumar 1 Reputation point
2020-08-28T10:27:36.42+00:00

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,935 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,746 Reputation points
    2020-08-28T10:32:43.537+00:00

    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

    0 comments
  2. Andy ONeill 361 Reputation points
    2020-08-31T17:27:25.173+00:00

    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.

    0 comments
  3. Lukas Yu -MSFT 5,821 Reputation points
    2020-09-02T06:16:26.42+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.