Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

2 Tablix

Posted on by 3,027

Hi

  I have DataItem Structure like this

   Sales Header

        Sales Line

   Item Charge Assignment (Purchase)

In report i have 2 Tablix. In first Tablix Sales Line Data is displayed.

In second Item Charge Assignment (Purchase) Data is displayed.

Problem is if there is 1 line in Sales Line Data and 10 or more lines in Item Charge Data then in First Tablix also it takes that much Height. I want it should take height of only its Data.

Thanks

*This post is locked for comments

  • Verified answer
    Tina Menezes Profile Picture
    Tina Menezes 2,576 on at
    RE: 2 Tablix

    Hi,

    You can try PrintOnlyIfDetailProperty for your dataitem

    https://msdn.microsoft.com/en-in/library/dd301378.aspx

    Also you can go to Row visibility->Show or hide based on an expression->

    Now enter the expression based on which the row must be hidden.

    =Fields!FieldName.Value=""

    Enter the name of the field based on which the row should be hidden.

    You can refer my answer on the following discussion too with screenshots:

    https://community.dynamics.com/nav/f/34/t/255430

  • Verified answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,266 on at
    RE: 2 Tablix

    Hi,

    - Have you tried PrintOnlyIfDetail property?

    - The other way could be Go to the row Visibility property of the row and apply the condition.

    Ref: https://msdn.microsoft.com/en-us/library/dd354976.aspx?f=255&MSPPError=-2147217396

    https://www.sourcecodester.com/tutorials/visual-basic-net/4883/suppress-row-if-value-zero-0-using-rdlc-report.html

    https://www.adv-usa.com/2016/01/05/rdlc-reports-in-nav-how-to-hide-what/

    Let me know if you need more explanation.

    Thanks

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans