Home » Developer & Programmer » Reports & Discoverer » To Auto srno by Report
To Auto srno by Report [message #631751] Mon, 19 January 2015 08:21 Go to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

i want to generate the srno in formate as
a.
b.
c.
i have done this with formula chr(srno+96) which is working for the z but after that it return as { .....now i want to return after the z as a.a
a.b
a.c
a.d
a.e
etc
Re: To Auto srno by Report [message #631986 is a reply to message #631751] Thu, 22 January 2015 13:12 Go to previous message
bluetooth420
Messages: 145
Registered: November 2011
Senior Member
For the left side part you use this
Quote:

CHR(CEIL(SRNO/26,1) + 96)




while for right hand part use this

Quote:

CHR(MOD(SRNO-1,26)+97)



Good luck till 676 records.
Previous Topic: Error while converting Reports from rdf to rep
Next Topic: Page wise grouping
Goto Forum:
  


Current Time: Sun Jul 12 21:55:50 CDT 2020