zeros in a new table in RDLC report.

delaghetto

Using NAV 2013 R2, I've added a new table in my Sales Invoice report.

The idea is that it shows a total Tax amount grouped by VAT Base. So I add a new table, and in the group property I add group by the Sales Line 'VAT %'. I also add some amounts in the same table.

So it works correctly, but for some reason, the first line always shows a blank VAT% and zero amounts. Even if my Invoice has a single line with 5% VAT, the table shows first line with empty VAT% and then then correct line with 5% VAT

For the moment, I've used the BlankZero function to hide it, but the blank space wasted is annoying. Any ideas on why is this empty line showing up?

lakshanvindana

it is because of the report design (data items), if you check the data set you can find it out.

for a solution, you can group the table by VAT%, or
use row visibility to hide.