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

ButadRocks01

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.

pavithrap0992

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.

saravanans87

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?

ButadRocks01

@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.

pavithrap0992

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.

ButadRocks01

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.