How to align two (2) records in one (1) table?

ButadRocks01
ButadRocks01 Member Posts: 9
in NAV Three Tier
I have a problem in aligning a record in each row. As you can see in the attached file, the row #70 should be align in row #1. Basically, the record is pulled out in one table (database) only. I already tried the sorting (property), but it doesn't work the way that I wanted. It will work but the number will jump.

Thank You for your help.

Best Answer

Answers

  • saravanans87
    saravanans87 Member Posts: 36
    Do you want to hide the other rows that does't have data or you want to sort the list by the rows that are having data and forwarded by the rest?
    Software Developer,
    Archerpoint India Pvt. Ltd,Chennai.
  • ButadRocks01
    ButadRocks01 Member Posts: 9
    @saravanans87

    I already hide the row that has no data, and used the 
    RowNumber("GroupName")
    . My problem right now is that the 
    RowNumber("GroupName")
    stays at 1 and does not increment (Please see the attached file.). I tried the sample in this link (https://saurav-nav.blogspot.com/2015/04/nav-rtc-report-reset-row-no-serial-no.html) to get some ideas in row numbering.
  • ButadRocks01
    ButadRocks01 Member Posts: 9
    edited 2016-11-15
    pavithrap0992 wrote: »
    If you are hiding some rows you can increment the row number either by using a variable in c/AL for the row number or in the SSRS code.

    Yes. I already used that idea. I used variable in C/AL to hold the incremented value for row numbering. I think this is fine.

    Thanks for the help.

Categories