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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to remove extra pa...
Microsoft Dynamics NAV (Archived)

How to remove extra page from rdlc report in navision 2013 r2

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Experts,

  I am trying to run a picking list report from navision. i have created two tablix in the RDLC layout. one tablix for normal items and another one for buffet items and now my problem is i have set a boolean variable for the 2nd tablix i.e if buffet items are there then only it visible . now my problem is if buffet items are there then my report showing perfectly but when comes to normal items it displaying one extra empty page. but now i dont want that extra page but how to overcome from this problem.

Can any one suggest me...

Thanks in Advance

Ramesh

*This post is locked for comments

I have the same question (0)
  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    Are the buffet items and normal items coming from the same DataItem?

    Best Regards,

    MMV

  • Community Member Profile Picture
    Community Member on at

    Yes....

    For Buffet Items I have Written Code on onpostdataitem trigger.

  • mmv Profile Picture
    mmv 11,471 on at

    That means, you have defined a separate set of DataItem for Buffet Items.  

    Are you in a position to bring all the data in one tablix?

    I feel that the tablix which is showing the normal data is causing you the problem of blank page.  If you cannot bring all in one table, you need to find a way to hide the Normal data tablix when there is no data.

  • Community Member Profile Picture
    Community Member on at

    i tried to define that two dataitems information in one tablix but for Buffet items i need to Add a Header Row separately and also i need to print buffet items in a new page for that i have created two tablix's..

     also i hide second tablix using a boolean variable i.e i wrote in my post.

    regards,

    ramesh

  • mmv Profile Picture
    mmv 11,471 on at

    It should not create any issues.  Could you check Sales - Invoice report?  It has a lot of examples of hiding and conditional visible etc.  

    Are all the tablix inside a List control?

    Have you set the Property Page Break before the start of the Buffer Items?

  • Community Member Profile Picture
    Community Member on at

    Following are the steps to hide the column

    1) Add a boolean parameter with name column_visible in your report

    2) Right Click on desired column and select Column Visibility.

    3) Select the option "show or hide based on an expression"

    4) add following formula

    = iif(Parameters!column_visible.Value = "True", false,true)

    5) Add following code in c# file where you are assigning value to above added parameter

    ReportParameter[] parameters = new ReportParameter[1];

    if (condition)

    {

      parameters[0] = new ReportParameter("column_visible", "True");

    }

    else

    {

    parameters[0] = new ReportParameter("column_visible", "False");

    }          

    this.reportViewer1.LocalReport.SetParameters(parameters);

  • Community Member Profile Picture
    Community Member on at

    I Added a list box and i pasted that two tablixs in that list box but i am getting error when i build that report and the error is "The tablix 'Tablix1' has a detail member with inner members. Detail members can only contain Static inner members. " like that but i don't know why sales - invoice report not getting that error Pls suggest me....

    Regards,

    Ramesh

  • Community Member Profile Picture
    Community Member on at

    No need to add extra box there. Please check the below URL, it might help you to hide the blank rows & page.

    msdn.microsoft.com/.../dd354976.aspx

  • Community Member Profile Picture
    Community Member on at

    Thanks Sandeep......

    But my Problem is not to Hide a Column or a tablix what ever...here the problem is i am getting extra empty page, because of as per my knowledge the second tablix is the problem here that means the space of that tablix creating issue if i run that report for normal items the second tablix going to hide and that space is there in body so that space is giving that blank page.... can u please consider this thing

    Regards

    Ramesh V

  • Community Member Profile Picture
    Community Member on at

    Yes correct, if second tablix dosn't have data then it will show the blank page and that's why i am telling you that please try to set the hide & show condition there because if tablix have data it will show accordig to show conditoin otherwise it will hide the blank page.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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