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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How Can i Give Visibil...
Microsoft Dynamics NAV (Archived)
Answered

How Can i Give Visibility Expression in Nav 2015 Reports

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Experts,

I have a small Doubt to Given Visibility Experssion For a Row In NAV2015 Reports.

Actualy Present i am doing Report Upgradation to Nav2009 R2 to Nav 2015 So in Nav 2009 r2 Sections visibility code is like this

CurrReport.SHOWOUTPUT((CurrReport.TOTALSCAUSEDBY = FIELDNO("Gen. Prod. Posting Group")) AND DetailLevel);


this above code is for one row in section

in nav2015 Rdlc i desinged same row and i have to give this visibility but how can i give this one?

what is totalscausedby?

is it workable in NAV2015?

I reffered below link 

https://msdn.microsoft.com/en-us/library/dd301478.aspx 

in the above link

IF CurrReport.TOTALSCAUSEDBY = ItemRec.FIELDNO("No.") THEN
  CurrReport.SHOWOUTPUT(FALSE); 

I thinks CurrReport.SHOWOUTPUT we con't Given in NAV2015.
any one help me to Solve this error.......

Thanks,
Ramesh.

*This post is locked for comments

I have the same question (0)
  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi Ramesh

    Totalscausedby used to define Grouping in 2009, if we want to achieve the same in 2015 we have to create a Group in your case you need to create group on Gen, Prod Posting Group and set the visibility by "DetailLevel"

    Best Regards

    Rajasekhar.Y

  • Community Member Profile Picture
    Community Member on at

    Hi Rajasekhar,

    i already Create a Group as Gen.prod Posting Group but my doubt is DetailLevel visibility Expression where i Can create means that for Group Visibility or Row Visibility.

    Actualy In nav 2009 R2 this visibilty is for row only as i said previous post.

    is it workable for both Group and Row?

    any way i check it.........

    thanks,

    Ramesh

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi Ramesh

    Yes, you need to put the Visibility expression on the Group rows using "DetailLevel" and check

    Best Regards

    Rajasekhar.Y

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Rajasekhar

    i Checked it but it's better to give visibility for Row only why means when i visibility for Group it is not Effect on row.

    and these Gen.Prod Posting Group is parent and under this group child Groups are there so it's better to Give DetailLevel for row only What you Say?

    Thanks,

    Ramesh.

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Yes, you need to put the Visibility for Row only.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans