locked
Auto Hide a column of tablix if it contains no data in Powerview RRS feed

  • Question

  • How can we autohide a column of tablix we the column contains no data ?

    Guneet Kalra


    Monday, October 8, 2012 3:48 AM

Answers

  • Hi Guneet,

    Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers.

    In you scenario, you want to hide the column when it contains no data, this is not support in the currently version. You can refer to the link below to see the power view design experience.
    http://technet.microsoft.com/en-us/library/hh231518.aspx

    If you have any concerns about this feature, you can submit a feedback at
    http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product.

    Thank you for your understanding.

    Regards,
    Charlie Liao

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    • Proposed as answer by Charlie Liao Monday, October 15, 2012 2:03 AM
    • Marked as answer by Charlie Liao Tuesday, October 16, 2012 12:51 AM
    Tuesday, October 9, 2012 2:07 AM

All replies

  • Hi,

    Yes you can use the expression in the Hidden property of the column.Select the column and press F4 , try to make expression in the hidden property as shown below ,=IIf(Fields!EnglishProductCategoryName.Value="",True, False).

    Hope this will help you.


    *Regards*
    *Samay Shrivastava*
    *Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*

    Monday, October 8, 2012 7:01 AM
  • where would add this expresseion ? Is it in Visual studio BISM tabular model ?


    Guneet Kalra

    Monday, October 8, 2012 7:16 AM
  • Hi ,

    I am referring 2008 R2, R u referring to 2012 ?.


    *Regards*
    *Samay Shrivastava*
    *Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*

    Monday, October 8, 2012 8:38 AM
  • yes Power view of SQL 2012

    Guneet Kalra

    Monday, October 8, 2012 8:44 AM
  • This is not supported in Power View

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Monday, October 8, 2012 8:56 AM
  • Hi Guneet,

    Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers.

    In you scenario, you want to hide the column when it contains no data, this is not support in the currently version. You can refer to the link below to see the power view design experience.
    http://technet.microsoft.com/en-us/library/hh231518.aspx

    If you have any concerns about this feature, you can submit a feedback at
    http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product.

    Thank you for your understanding.

    Regards,
    Charlie Liao

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    • Proposed as answer by Charlie Liao Monday, October 15, 2012 2:03 AM
    • Marked as answer by Charlie Liao Tuesday, October 16, 2012 12:51 AM
    Tuesday, October 9, 2012 2:07 AM