Restarting running total
Restarting running total
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
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
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Restarting running total
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.
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.
Re: Restarting running total
but this is .net core, so scripting is not working?
Re: Restarting running total
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.
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.
Re: Restarting running total
Can you prepare a simple example to show how to do that, please?
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Restarting running total
Hello,
The sample report in the attachment.
Thank you.
The sample report in the attachment.
Thank you.
- Attachments
-
- GroupSummRunning.mrt
- (791.26 KiB) Downloaded 242 times
Re: Restarting running total
In that sample report, the {SumRun += Products.UnitPrice} statement shows a "Syntax Error" message on Check, but it does execute.
Judy Hennessey / PrecisionBI
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Restarting running total
Hello,
Please try to change on:
{SumRun = SumRun + Products.UnitPrice}
Thank you.
Please try to change on:
{SumRun = SumRun + Products.UnitPrice}
Thank you.