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 AX (Archived) / SSRS report : How to h...
Microsoft Dynamics AX (Archived)

SSRS report : How to hide column by expression in visual studio

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I am beginner of dynamics ax2012 r3 and microsft visual studio 2010.

currently i want to hide the highlighted column below based on expression in report design (visual studio).

however, after the expression set and the expression true, the row of data was not showed.

Kindly advises,

Thanks in advanced..

regards,

Eity182

*This post is locked for comments

I have the same question (0)
  • Bilal Issa Profile Picture
    Bilal Issa 4,370 on at

    Hi,

    please set the visibility property to be expression , and if that expression return true then it will be visible, if return false, it will be hidden.

    Regards,

    Bilal

  • Community Member Profile Picture
    Community Member on at

    Hi Bilal,

    Thanks for your reply.. is it like this?

    regards,

    eity182

  • Community Member Profile Picture
    Community Member on at

    after i done this expression, the column is hide...but if the expression was true..the column was showed..then the row data was not showed..

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Be careful, the logic of the report is different than the one from AX. You are setting the 'HIDDEN' property and not the visible one.

    So if you return true, it will be hidden (invisible) and if you return false, is will be shown(not hidden/visible).

  • Community Member Profile Picture
    Community Member on at

    Hi Jens,

    Thanks for your reply..

    could you explain me details?

    I really have no idea :(

    Regards,

    eity182

  • Community Member Profile Picture
    Community Member on at

    But when expression true, the column is showed but the row data is hidden :(

  • Community Member Profile Picture
    Community Member on at

    You are setting the 'hidden' property. So returning true will hide the column. If you want to see the column, you have to return false.

    So you say hidden = false, meaning it's not hidden - its visible.

  • Community Member Profile Picture
    Community Member on at

    Hi Jens,

    May I know is also reflect the row data?

  • Community Member Profile Picture
    Community Member on at

    Are you sure the data is provided correctly (fields do actually have values)?

  • Community Member Profile Picture
    Community Member on at

    Yes i'm sure..but when the expression is true the column was visible..but my problem is the row data is not showed(invisible).

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans