RDLC subtotals

txeriff · 2016-02-01

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 · 2016-02-01

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

txeriff · 2016-02-01

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 · 2016-02-01

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 · 2016-02-01

thanks a lot! It worked !

best regards!

postsaurav · 2016-02-02

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

Howdy, Stranger!

Quick Links

Categories

RDLC subtotals

Answers