RDLC Report Merge 2 Rows In 1 Row NAV 2013

FurkanR

Hello Developers,

I have a question about RDLC Report in NAV 2013

I have 2 rows like this

Store10 2.00 5.00 0.00 0.00

Store10 0.00 0.00 3.00 9.00

And I want 1 row by merging these, like;

Store10 2.00 5.00 3.00 9.00

How can it possible ?

Thanks for your answers.

eskay

Hi,

make an extended Dataset in the report and fill the values in to different fields.

Field: Store A-A A-B A-C A-D B-A B-B ...
Values: Store10 2.00 5.00 0.00 0.00 10 0.00 0.00 3.00 9.00

Than you can filter in one row with iif(xxx.value <>...)

SilverX

How about grouping on the first column? Then use static group instead of details group and Sum() for the values.

In case you only need the sums and not the single values in the report, please try to sum directly in NAV object. You can use Query object for this.

Cheers
Carsten