Restarting running total

Stimulsoft Reports.WEB discussion
Post Reply
FrenkR
Posts: 131
Joined: Mon Jan 05, 2015 12:15 am

Restarting running total

Post by FrenkR »

Hello,
is there any setting to "reset" running total value inside report when "Reset page number" is used inside "group band"?

using 2019.2, .net core (latest)

Rgds,
Frenk
Lech Kulikowski
Posts: 6263
Joined: Tue Mar 20, 2018 5:34 am

Re: Restarting running total

Post by Lech Kulikowski »

Hello,

Unfortunately, no.
As a way, you can use your own variable for running total calculation and set it to 0 as you needed.

Thank you.
FrenkR
Posts: 131
Joined: Mon Jan 05, 2015 12:15 am

Re: Restarting running total

Post by FrenkR »

but this is .net core, so scripting is not working?
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Restarting running total

Post by HighAley »

Hello, Frenk.

It's possible to use any expression in the Compilation mode.
There is no classic compilation in .Net Core. At all.
So it's possible to use our Interpreter.

You could use the Reset Page Number property of any band.

Thank you.
FrenkR
Posts: 131
Joined: Mon Jan 05, 2015 12:15 am

Re: Restarting running total

Post by FrenkR »

Can you prepare a simple example to show how to do that, please?
Lech Kulikowski
Posts: 6263
Joined: Tue Mar 20, 2018 5:34 am

Re: Restarting running total

Post by Lech Kulikowski »

Hello,

The sample report in the attachment.

Thank you.
Attachments
GroupSummRunning.mrt
(791.26 KiB) Downloaded 242 times
JHenn
Posts: 20
Joined: Fri Jun 01, 2018 9:23 pm

Re: Restarting running total

Post by JHenn »

In that sample report, the {SumRun += Products.UnitPrice} statement shows a "Syntax Error" message on Check, but it does execute.
Judy Hennessey / PrecisionBI
Lech Kulikowski
Posts: 6263
Joined: Tue Mar 20, 2018 5:34 am

Re: Restarting running total

Post by Lech Kulikowski »

Hello,

Please try to change on:
{SumRun = SumRun + Products.UnitPrice}

Thank you.
Post Reply