Sub-summary with record number

[Josue Gutierrez]

Hello,

 

I need to create a report similar to the attached  PDF ( or Correct Record Number link). In the report I don't want to use the Body part but the Sub-summary; However, when I use the {{RecordNumber}} Symbol in the Sub-summary part, it does not give the consecutive record number (see the Wrong Record Number link). Is there any way to use  {{RecordNumber}} Symbol in the  Sub-summary part of the report and behave in same way as in body.

 

 

Correct Record Number

https://www.dropbox.com/s/hdaddpi9zdw72ol/CORRECT%20RECORD%20NUMBER.pdf?dl=0

 

Wrong Record Number

https://www.dropbox.com/s/bb3e5ihip88yheb/WRONG%20RECORD%20NUMBER%20.pdf?dl=0

 

I appreciate any suggestion to this issue. 

 

Best Regards, 

 

Josh

RMA INVENTORY 08-15-2014.pdf

[eos]

You cannot use the record number symbol, because it displays the number of a record; and regardless of your displaying the body part or not, the records that generate the summary parts are still “there”.

 

Instead, create an unstored calculation field as

Case ( yourSubSummaryBreakField ≠ GetNthRecord ( yourSubSummaryBreakField ; Get ( RecordNumber ) - 1 ) ; 1 )

and a summary field as Count (running) of this field. That's your sub-summary “record number” value.