To get past sorting vs display issues like this I tend to define a computed
expression in the SQL of: int value coverted to ascii and left padded with
zeroes to a set length concatenated with the display string (month), this
then allows correct sort in SQL. In your graph object, leave categories
unsorted and set the text for the category values to mid(string,start of
month string).
Regards,
Gary Hyland
Australia
-----Original Message-----
From: Laforce, Lester [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 4:17 AM
To: '[EMAIL PROTECTED]'
Subject: PFCSIG Code Table for Graph Category Labels (Non PFC Question)
Have a table with MONTH column and integer values ranging 1 through 12.
Want to display month string (i.e. JAN) along category axis of graph.
Tried
a code table, but does not seem to work -- integers are displayed.
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
