3 Replies Latest reply on Feb 25, 2012 9:51 AM by egbaumier

    How to show serial reference for each line of a report?

    egbaumier

      Is there any sugestion to solve this issue?

      I'd like to make a report but at every line should be a reference before the main data. Example:

       

      1. Cars

      2. Tools

      3. Food

      .

      .

      .

       

      How to include ou make a calculation to automatic increase 1 after previous line at report?

        • 1. Re: How to show serial reference for each line of a report?
          jmfruition

          Assuming you're talking about a simple report with found set and not a sub-summarized group that you with to number, use:

           

          Insert/Record Number Symbol

           

          This will place the @@ control on your layout, move to the far left of your line.

           

          Is that what you're looking for?

           

          Jeff

          1 of 1 people found this helpful
          • 2. Re: How to show serial reference for each line of a report?
            gcatnine

            Define a numeric field (Field_Num) in the same table of, car, Tools, Food, etc.

             

            A) Cars, Tools, etc.,  are in the same table  of the details data

            after selecting and sorting the records, run a script like this  (_Table::categ contains Cars, Toos, etc)

             

            Loop

            Set Variable[$cat; Value:If(EvaluationError ( GetNthRecord ( _Table::categ; Get ( RecordNumber )-1) );""; GetNthRecord

            ( _Table::categ; Get ( RecordNumber )-1) )]

            Set Variable[$num; Value:If(EvaluationError ( GetNthRecord ( _Table::Field_Num; Get ( RecordNumber )-1) );0; GetNthRecord

            ( _Table::Field_Num; Get ( RecordNumber )-1) )]

            If[$cat = _Table::categ]

            Set Field[_Table::Field_Num; $num]

            Else

            Set Field[_Table::Field_Num; $num+1]

            End If

            Go to Record/Request/Page

            [Next; Exit after last]

            End Loop

             

            In the report put the Field_Num near the field with Cars, Tools, etc.

             

            B) Cars, Tools, etc., are in a separate table of the details data

            After you have selected and sorted the records to be printed, replace the field  content of  Field_Num with serial number starting from 1 increment by 1

            In the report put the Field_Num near the field with Cars, Tools, etc.

            • 3. Re: How to show serial reference for each line of a report?
              egbaumier

              Thanks. So simple and works fine.

               

              Edison