locked
SSRS/ Fetch XML / Hid Matrix Table RRS feed

  • Question

  • hi Team

    Does anyone know how to only show the last x columns within a matrix table?

    I am trying to get a report using FetchXml where by is shows the running total of the whole database by week, but I only want to show the last 7 weeks

    cheers

    Wednesday, October 26, 2016 2:45 AM

All replies

  • Hi Tay84,

    According to your description, you only would like to display the columns which is last 7 weeks, right?  Did you mean there was a week column group and you want to hide some columns in this group?

    If so, you can set visibility that show or hide based on an expression for the columns to control the visibility. You can take a look at this thread: How to make a column invisible in an ssrs matrix.

    If the method above doesn’t meet your requirement, could you please share your report design and sample data with us?

    Best Regards,
    Pirlo Zhang

    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    Thursday, October 27, 2016 8:19 AM