Re: [Emerald] Custom Report

Alan D. Criado ( (no email) )
Tue, 23 Feb 1999 15:19:43 -0500

Hello Dale, I hope all is going well for you.

At 12:14 PM 2/23/99 -0800, you wrote:
>"Alan D. Criado" wrote:
>> I need someone's help who's good at putting together CR reports with
>> Emerald data.
>> The information I'm look for is, how many customer of each type of service
>> do I have and the price of each of these services.
>> Something along the lines of:
>> Service Description Quantity of Accounts Price of
>> this Service
>> ========================================================
>> 1 mo. Dialup PPP xxxx
>> 19.95
>> 1 yr. Dialup PPP xxxx
>> 191.00
>> DNS Hosting xxxx
>> xxxxx
>> etc. etc. etc.
>> I'm willing to pay 100.00 for the first report that can do this and work on
>> my system, but I need it today!
>There is a report called serv_rev.rpt that will break down your
>revenue by service (in a drill down fashion). Its on our FTP
>site as well.

I tried to run that report but it just errors out. I wrote to you about
it, here's your reply:

"Alan D. Criado" wrote:
> I'm running Emerald 2.5.22.
> Whenever I try to run the SERV-REV.RPT report, I get an SQL error:
> ODBS error: [Microsoft][ODBC SQL Server Driver][SQL Server]The number '0.'
> is out of the range for numeric representation [max precision:33].

It looks like it had the wrong location. I'll put an update in
/emerald/reports on our FTP site.

> If I just try to run the SQL Query of that report:

You can't do this. Crystal uses its own interpreter of the SQL

> Do you have any idea what could be wrong and how to correct this?

A quick fix is to load the report in Crystal, select Database...Set
Location and for each table, remove eveything in the bottom frame
except for the table name itself. Also under Database, choose
Show SQL Query and choose the reset option in the lower right hand


Dale E. Reed Jr. Emerald and RadiusNT

I tried the above quick fix, but I wasn't able to get it to work. Thus myrequest again for someone's help in area, I need this report today.

Thank you for your repsonse.

Alan D. Criado

For more information about this list, including removal,please see