topic Re: How to force the record number/sequence to continue counting over the group for the whole report. in Qlik NPrinting

How to force the record number/sequence to continue counting over the group for the whole report.

Nuttakorn — Mon, 15 Feb 2021 04:44:54 GMT

I've working with PixelPerfect with multi level. I need the sequence number to run through every table rows and continue counting when the level changed. I've try for all summary option in summary running Page is closer my expectation but I need to countinue counting till the page end. for the other It's reset to 1 when level change.

Re: How to force the record number/sequence to continue counting over the group for the whole report.

Ruggero_Piccoli — Mon, 15 Feb 2021 08:18:24 GMT

Hi,

Are they two different levels (different fields) or two different values of the same level?

I have to check if it is possible.

Best Regards,

Ruggero

Re: How to force the record number/sequence to continue counting over the group for the whole report.

Nuttakorn — Mon, 15 Feb 2021 08:29:08 GMT

Hi,
There is 1 Table but grouping by the dimension value in level (same field).

ie. I have a table of customer and the branch name is the level

----------------------------------------------
Branch1 : A
--------------------table of customer ---
seq. Customer Name
1 CustomerA
2 CustomerB
----------------------------------------------

Branch2 : B
--------------------table of customer ---
seq. Customer Name
3 CustomerC << Normally it reset to 1 but I need concurrent counting
4 CustomerD
----------------------------------------------

Re: How to force the record number/sequence to continue counting over the group for the whole report.

Ruggero_Piccoli — Mon, 15 Feb 2021 13:04:39 GMT

Hi,

Add a Label object at the beginning of the details row
By keeping the new label selected, open the Scripts - Before Print event and create a new script
Insert the following script:

int counter = 0; private void label4_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { counter++; label4.Text = counter.ToString(); }

This is a C# script so be sure it is selected ad template scripting language and that the scripts are enabled. Chenge the name of the label with the correct value. In my case the name is label4.

Best Regards,

Ruggero