CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 How to add LINE NUMBERS into a grid report?

Print topic Send  topic

Author Message
Francisco
Posted: 03/24/2003, 11:25 PM

Hello,
I have a grid report(with data coming from an Access database) and I would like to add, at the begining of the line, a LINE NUMBER automatically. Currently, the grid is a standing report sorted by a number of pointsa and the line number I would like to add will represent the position of the team (1st, 2nd, 3rd,...) Example at http://www.kart-team.com/teams/Teams_list3.asp without the line numbers (of course...)

Thanks a lot in advance

Francisco
Farooq Ahmed
Posted: 03/25/2003, 4:16 AM

Dear Francisco,
Please do the following:
1- In the grid form make a new label like S# and give its name in the property as "SN".
2- In the Form Open property of grid form write "i=0"
3- In the Form Before Show property write
i=i+1
fldSN=i

save the form and run it. It will show serial number of all records.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.