Add QSO Sequence Numbers to Report

Question

made a special report (worked members of some Club) and got a list of records (QSO-Data, Mebership numbers etc.). The Report shows me xxx records. Now I want to have such (simply ascending from 1 to xxx) numbers as part of my report, there should be a column called Number. How can I do this?

Answer

Add a counter to count the Records to the report and display this counter as Sequence Number.

A record counter can be added in the following way:

  1. Edit the Report to which the sequence  number should be addded
  2. Add a custom field to the query
    • double click on an empty column. This opens the value Editor
    • open the Expression page and enter a 1 in the lower part

    • Change to the Value Page and enter a name for the field (QSOCount)

     

  3. Add the the QSOCount field to the layout and display it with the function @Sum
    • open the Layout page of the Report Editor
    • open the Page Designer and place QSOCount on the Report
    • select the [QSOCount] field and open the Customize ¦ Caption page of the Page Designer
    • Change  the QSOCount field to the function @Sum([QSOCount])

Now you can test the result