Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Base 36 Conversion Post Reply Post New Topic
Author Message
boroffcl
Newbie
Newbie
Avatar

Joined: 04 Jan 2010
Location: United States
Online Status: Offline
Posts: 1
Quote boroffcl Replybullet Topic: Base 36 Conversion
    Posted: 04 Jan 2010 at 11:20am
The SQL database I am using stores all invoices numbers in Base 36.  I would like to know how to easily convert them back to Base 10 for my reports.  There has to be an easier way than my current method of exporting the data to an Excel spreadsheet and doing the conversion.
Coy Boroff
coyboroff@hotmail.com
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 04 Jan 2010 at 11:25am
I used to know a formula to convert any base to any base, but it has been thirty years since I used it.  The bottom line is to use a formula.  I do not know if Crystal formula editor has the tools to do the conversion.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 07 Jan 2010 at 8:30am
I looked up how to do base conversions.  I do not know if Crystal has the tools to do what you need.  If the base 36 number is fixed on size or as least below a maximum size, then it might be possible.

It would take creating a formula and testing against the data.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.