RDLC subtotals

txeriff

Hi all, hope some1 can help. This is the expected in old NAV version:


And this is current RDLC layout I have. Im trying to make subtotals for each fixed asset so I groupped by autoincremental field (first column in table, lfdnr) so that way it shows me all the rows calculated in the process that builds this up. I would need to subtotal for each fixed asset (Inv-Nr. in the screen capture).
Groupping by "document no." Would be OK I guess too, if this make it easier.

Thanks a lot for your help

Any ideas how I could do it? I tried several ways but...

postsaurav

Incorrect Grouping.
Change the Group Expression to Fixed Asset No.

txeriff

postsaurav wrote: »

Incorrect Grouping.
Change the Group Expression to Fixed Asset No.

Hi postsaurav

If I do that then only one row is shown. Do you mean change in the parent row?


And this is how dataitem looks like. Its what they had in OLD nav version

postsaurav

ok Do it this way.

1. Create a New Table.
2. Add a Group in the Table on FA No. and Select CheckBox Add Group header and Footer.
3. Whatever is the content of your second line in picture put it in Details (not on Group Header of New Group Created).
4. on Group Footer on New Group Created, put Your Sum Expression.
5. Hide / Remove the Old Table.
6. Run the Report.

txeriff

thanks a lot! It worked !

best regards!

postsaurav

Hi,
Please mark the answer to the reply that helped you.
It will help others.