SSRS automatic extension columns depending on the parameters - tablix

Monic

I have a table and a graph next to each other in a line. I can choose one or more of 5 columns which can be displayed by using multiple values in parameters. But when I'll choose 4 of 5 I have white area between chart (graph) and tablix (table), what I don't want. I want to expand these columns to initial tablix size. And the same in case less number of columns. Is it possible expand them depending on chosen parameters?

(Edit:) Or how to change width of column depending on expression? If I can do this, my problem will be solved.

Or another idea is to expand chart on whole width - it could be between tablix and the end of page.

Any ideas how to do this?

Jeroen

This is unfortunately not possible in SSRS without the use of a hack. To quote the "accepted" answer from this MSDN thread:

This is a common request and I definitely see the value in it. However, we didn't get to this for SSRS 2008. Please feel free to file a feature request (or add votes to an existing request) on the connect.microsoft.com.

As far as I know this hasn't changed in SSRS 2012, though someone may correct me on this.

The thread mentioned above holds several workardounds, ranging from ugly to UGLY. One other lead (possibly even a duplicate question?) is this SO question where it's suggested to not hide the column but make the text have the same color as the background o.O

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

SSRS automatic extension columns depending on the parameters - tablix

From Dev

SSRS tablix split report into two sets of columns

From Dev

SSRS tablix split report into two sets of columns

From Dev

Can I allow the user to specify the order of static columns in SSRS tablix?

From Dev

Adding together 4 different Tablix data columns SSRS

From Dev

Expression to hide tablix in ssrs

From Dev

Hide Tablix on Condition base in SSRS

From Dev

SSRS Chart in tablix with Column Break

From Dev

Adding subtotals to SSRS report tablix

From Dev

Fixed tablix or chart width in SSRS

From Dev

SSRS Removing "#Error" from a tablix

From Dev

SSRS Dataset Field Refresh not updating for Tablix

From Dev

Adding a new group to an SSRS tablix with existing groups?

From Dev

SSRS. Page breaks inside tablix with subreports

From Dev

SSRS Show only 1 tablix row

From Dev

SSRS tablix Sorting not working on Date column

From Dev

SSRS Report Multiple Pages Tablix Order

From Dev

SSRS Fixed Tablix/ add blank rows below

From Dev

Change the rows color of tablix report in SSRS

From Dev

Tablix border inconsistent when zooming into ssrs report

From Dev

SSRS report - show tablix only once

From Dev

Using Cutsom Colors For Charts and Tablix in SSRS

From Dev

expression to hide multiple tablix in ssrs 2008

From Dev

SSRS - How to keep tablix expanded even if no data

From Dev

SSRS Parameters - Toggle a parameter's NULL checkbox depending on value other parameter(s) NULL checkboxes

From Dev

SSRS Parameters - Toggle a parameter's NULL checkbox depending on value other parameter(s) NULL checkboxes

From Dev

Show subtotal of a columns in the same Tablix in RDLC

From Dev

add variable number of empty columns to a tablix

From Dev

tablix columns jagged in dynamics crm report viewer

Related Related

  1. 1

    SSRS automatic extension columns depending on the parameters - tablix

  2. 2

    SSRS tablix split report into two sets of columns

  3. 3

    SSRS tablix split report into two sets of columns

  4. 4

    Can I allow the user to specify the order of static columns in SSRS tablix?

  5. 5

    Adding together 4 different Tablix data columns SSRS

  6. 6

    Expression to hide tablix in ssrs

  7. 7

    Hide Tablix on Condition base in SSRS

  8. 8

    SSRS Chart in tablix with Column Break

  9. 9

    Adding subtotals to SSRS report tablix

  10. 10

    Fixed tablix or chart width in SSRS

  11. 11

    SSRS Removing "#Error" from a tablix

  12. 12

    SSRS Dataset Field Refresh not updating for Tablix

  13. 13

    Adding a new group to an SSRS tablix with existing groups?

  14. 14

    SSRS. Page breaks inside tablix with subreports

  15. 15

    SSRS Show only 1 tablix row

  16. 16

    SSRS tablix Sorting not working on Date column

  17. 17

    SSRS Report Multiple Pages Tablix Order

  18. 18

    SSRS Fixed Tablix/ add blank rows below

  19. 19

    Change the rows color of tablix report in SSRS

  20. 20

    Tablix border inconsistent when zooming into ssrs report

  21. 21

    SSRS report - show tablix only once

  22. 22

    Using Cutsom Colors For Charts and Tablix in SSRS

  23. 23

    expression to hide multiple tablix in ssrs 2008

  24. 24

    SSRS - How to keep tablix expanded even if no data

  25. 25

    SSRS Parameters - Toggle a parameter's NULL checkbox depending on value other parameter(s) NULL checkboxes

  26. 26

    SSRS Parameters - Toggle a parameter's NULL checkbox depending on value other parameter(s) NULL checkboxes

  27. 27

    Show subtotal of a columns in the same Tablix in RDLC

  28. 28

    add variable number of empty columns to a tablix

  29. 29

    tablix columns jagged in dynamics crm report viewer

HotTag

Archive