web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Hiding columns in tabl...
Microsoft Dynamics CRM (Archived)

Hiding columns in tablix dynamically

(0) ShareShare
ReportReport
Posted on by jmkvalsund 22

I have a tablix where there are two column group levels, "product type" and "product". There are furthermore three detail columns, "Sum credit","Sum debet" and "No of items". However, for some products (and product types), the "Sum credit" and "Sum debet" is always 0 or NULL. And those columns I would like to hide. Is this possible to do? Using CRM 2011 and SSRS 2008.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mithilesh Kumar Profile Picture
    Mithilesh Kumar 10,047 on at

    Hi jmkvalsund,

    Correct me if I am wrong. Hiding columns for those field values means you don't want to show 0 or Null.

    The reason I am stating this because hiding columns will hide for all records and not just for one.

    If that is what you are looking for follow this tutorial which will help you on how to format Data in SSRS Reports (Conditional Formatting).

    www.youtube.com/watch

    Hope that helps

    Thanks

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Jm,

    Yesm it is possible.

    You just need to use IIF Expression for the Column Visibility Setting.

    Example:

    IIF(IsNothing(Fields!fieldname.Value),True,False)

    or

    =IIf(Fields!val.Value > 0, False, True)

    You can use Sum as well

    =IIf(Sum(Fields!val.Value) > 0, False, True)

    Thanks.

  • jmkvalsund Profile Picture
    jmkvalsund 22 on at

    The problem is a bit more complicated than that. Since the tablix contains grouped columns, it is the same "detail columns" that shows for every group header. Which means I have to get the "output" of the tablix and format the detail columns of the groups where the value is 0 or NULL. I can not format the tablix static on column-level, since there will always be one or more groups containing data in the actual column. Which will make the column show anyway. As it is supposed to when it contains data.

    If this was a  .NET project, I think I would have grabbed the Format event of the tablix (or the column in the tablix), but that is not possible in SSRS (not for me, anyway).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans