Empty spaces in report

rhardoyalrhardoyal Member Posts: 78
edited 2011-08-11 in NAV Three Tier
Hi,

I have design a report in rdlc and there are 2 tables in the report. The data in both tables are being displayed well, however, when i view the report in report viewer, there are a huge space between the table. Please see attachment. Any help how to remove these blank spaces.

Thanks,
Rizwana

Answers

  • Jatin_PatelJatin_Patel Member Posts: 200
    Apply two different color to both table and check from where the space is printed.

    Also check resultset for data not coming blank(About Print Preview Property).
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    rhardoyal wrote:
    Hi,

    I have design a report in rdlc and there are 2 tables in the report. The data in both tables are being displayed well, however, when i view the report in report viewer, there are a huge space between the table. Please see attachment. Any help how to remove these blank spaces.

    Thanks,
    Rizwana

    as Jatin said try to color rows of the tables to find which cause the empty spaces.
    I think that a filter on the Empty Group for both tables will solve the problem (if you don't get what I mean I will explain better).
    ~Rik~
    It works as expected... More or Less...
  • rhardoyalrhardoyal Member Posts: 78
    Hi,

    I have colored the rows as you both said but can't find any empty row. I have added a check on the row to set the visibility to false if there's no data.

    Please see attached. Note that I have also added an expression for the visibility of the table.

    thanks,
    Rizwana
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    rhardoyal wrote:
    Hi,

    I have colored the rows as you both said but can't find any empty row. I have added a check on the row to set the visibility to false if there's no data.

    Please see attached. Note that I have also added an expression for the visibility of the table.

    thanks,
    Rizwana

    Could you provide also a screenshot of the Report Structure from Visual Studio?
    ~Rik~
    It works as expected... More or Less...
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Can you show RDLC data in visual studio?

    make sure that there is no gap between two tables in rdlc data..
  • rhardoyalrhardoyal Member Posts: 78
    Please find attached screen shot from visual studio
    3.jpg 182.2K
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    make sure that there is no gap between two tables in rdlc data..

    Thanks...

    Are you sure there is no gap between 2 tables?

    I can see a little gap :-k

    EDIT: Also at the end of the second table..
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    2 questions:
    - when we suggest to color rows, did you also colored second table's rows?
    - did you placed visibility condiction on the second table?
    ~Rik~
    It works as expected... More or Less...
  • rhardoyalrhardoyal Member Posts: 78
    yes I did same for 2nd table and still same issue. Regarding the space between the 2 tables in the designer, i have removed but the result is still same.
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    are tables in 2 different lists?
    ~Rik~
    It works as expected... More or Less...
  • Sergii_ChernenkoSergii_Chernenko Member Posts: 14
    Try to delete empty space to the right of your report.
  • rhardoyalrhardoyal Member Posts: 78
    hi,

    I tried to delete empty spaces from the right and this did not solve it.

    Yes there are 2 lists and are from different tables.
  • Troubles_In_ParadiseTroubles_In_Paradise Member Posts: 588
    rhardoyal wrote:
    hi,

    I tried to delete empty spaces from the right and this did not solve it.

    Yes there are 2 lists and are from different tables.

    have you imposed any filter on the 2 lists?
    if not you should...
    ~Rik~
    It works as expected... More or Less...
Sign In or Register to comment.