Hi there,

This is sort of off topic, but I thought others may be interested . . .I am
working on optimizing a drill down report someone else has created using
Crystal Reports 8.0  . . . just for some background . . . our database is on
MS SQL Server 2000 Standard and we connect via an ODBC driver.  Anyway, I
noticed that this report is grouping at 3 levels based on Crystal Formulas.
My client machine is doing all the processing!  I am trying to fix this my
grouping on SQL Expressions instead.  As I'm relatively new to this I'm not
even sure this can be done given the current crystal formula used to group
my data.  For example, I want to change the following Crystal Formulas
(these are the formulas my groups are based on) to an SQL Expression:

//CustomerContractSort
{ARCM.SortName}+Right(ToText({ARTH.Customer},0,""),6)

//ApplyMonthTrans
(ToText(Year ({ARTL.ApplyMth}),0,"")+"/"+(ToText(Month
({ARTL.ApplyMth}),0,"")))+Right (("
"+(ToText({ARTL.ApplyTrans},0))),6 )

//MonthTrans
(ToText(Year ({ARTL.Mth}),0,"")+"/"+(ToText(Month ({ARTL.Mth}),0,"")))+Right
(("          "+(ToText({ARTL.ARTrans},0))),6 )

Here's the problem, I cannot find an equivilent "ToText" SQL function that
Crystal will allow me use in their Expression Editor.  I'd like to use the
STR function, but I don't see that option available to me.  From what I
understand, there are only certain SQL functions available to me when using
an ODBC driver.

Is there any way around this?  Do I have any other choices?  Am I even on
the right track??  I really don't like grouping on Crystal formulas, but
maybe I don't have a choice in this situation.

Any help would be greatly appreciated!

Thanks,
Jamie Kriegel

By the way . . . do any of you have a recommendation for a good SQL list
similar to this one for Access?