CodeCharge Studio

All ASP PHP Perl ColdFusion Java C#.NET VB.NET

Inserting Row Number

This example shows how to insert row number ReportLabel in Report Component. We will change the value of control Label1 located in a Report Users using several methods.

Method 1: Using Total Functions

This method allows you to show the Row Number and reset it for the whole report, separate page or needed group depending on the Reset At property value.

1. Specify Control Source Type property of Label1 as Database Column.
2. Leave Control Source property of Label1 empty.
3. Specify Function property of Label1 as Count.
4. Specify Reset At property of Label1 as you need.

Method 2: Using Special Value

This method allows you to show the Row Number and reset it for report.

1. Specify Control Source Type property of Label1 as Special Value.
2. Specify Control Source property of Label1 as Row Number.

Method 3: Using the Custom Code

1. Add the Before Show event to the Lable1 control
2. Within the event, add the code below:

   ASP

   Users.Label1.Value = "Row Number: " & Users.RowNumber

   Java

   e.getReport().getControl("Label1").setValue("Row Number: " + e.getReport().getRowNumber());

   PHP

   global $Users;
   $Users->Label1->SetValue ("Row Number: " . $Users->RowNumber);

   Perl

   $Users->{Label1}->SetValue ("Row Number: " . $Users->{RowNumber});

   ColdFusion

   <CFSET fldLabel1=RowNumber>

   ASP.NET C#

   UsersLabel1.Text = "Row Number: " + Users.RowNumber.ToString();

   ASP.NET VB

   UsersLabel1.Text = "Row Number: " + Users.RowNumber.ToString()

See also