Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Nuttakorn
Partner - Contributor II
Partner - Contributor II

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

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.

Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

  1. Add a Label object at the beginning of the details row
  2. By keeping the new label selected, open the Scripts - Before Print event and create a new script
  3. 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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

3 Replies
Ruggero_Piccoli
Support
Support

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Nuttakorn
Partner - Contributor II
Partner - Contributor II
Author

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
----------------------------------------------

Ruggero_Piccoli
Support
Support

Hi,

  1. Add a Label object at the beginning of the details row
  2. By keeping the new label selected, open the Scripts - Before Print event and create a new script
  3. 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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.