locked
Large white space in the right margin of the report RRS feed

  • Question

  • User1793652459 posted

    Hi.

    I have a report where I hide or show a set of columns based upon the user selections in the paramters dropdown list. User could select option 1, option 2 or both. Requirement is that if they select option 1 then I need to hide the option 2 related columns. If they select option 2 then I hide the option 1 related columns. The tricky part is that they can also select both options then I need to show both options related columns. Normally I create dynamic column titles and column fields with the IIF statements and show only one set depending upon the selection and adjust the right margin. In this case I need to leave the right margin to the maximum columns width so it could accommodate the selection of both sets of columns.  The issue comes in When they select only one set of columns that leaves some ugly large white space in the right margin which is visible while previewing or printing report. Is there any way to fix this issue? This is SQL server 2005 reporting services.


    Thanks for your help.

    Tuesday, April 12, 2011 8:18 PM

Answers

  • User1471008070 posted

    Hi,

    In SSRS 2005, this requirement might not be able to achieve, if you are using SSRS 2008 or SSRS 2008 R2, we could set static column's visibility to achieve this, if possible, you could update your Reporting serivces to SSRS 2008 to later version.

    Thanks,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 20, 2011 4:13 AM

All replies

  • User-305876627 posted

    depends on your requirement, you might want your table/ tablix center horizontally. might looks better.

    select table --> format --> Center in Form  --> horizontal 

    alternatively, try removing header/ footer and then leave no margin around table and try to print it.

    Wednesday, April 13, 2011 12:36 PM
  • User1793652459 posted

    Thanks for the reply, I tried both suggestions with no luck.

    Thursday, April 14, 2011 7:33 PM
  • User1471008070 posted

    Hi,

    In SSRS 2005, this requirement might not be able to achieve, if you are using SSRS 2008 or SSRS 2008 R2, we could set static column's visibility to achieve this, if possible, you could update your Reporting serivces to SSRS 2008 to later version.

    Thanks,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 20, 2011 4:13 AM