Page 1 of 2 1 2 >
Topic Options
#46927 - 08/19/15 07:51 AM Crystal Reports Custom Reports AR 150625
Tony Martin Offline
Adagio Scholar

Registered: 07/17/00
Posts: 96
Loc: Chatham, Ontario, Canada
I have reports designed for AR 9.2A (150625) that run fine on my install.
When transferred to the customer, pressing "preview" after selecting the custom report results in an "Unspecified Error".

I just noticed the AR about screen says it is AR 9.2A (150701) ??

Any ideas?
_________________________
Tony Martin
Code 6 Programming
519.359.0918

Top
#46947 - 08/20/15 11:35 AM Re: Crystal Reports Custom Reports AR 150625 [Re: Tony Martin]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
Hi Tony:

I likewise have had this problem, and reported in on the Forum a number of weeks ago.
Problem is, I sent the data and reports to Softrak and they are able to run the reports without the error message, but I still cannot run them from within Adagio 9.2.
The reports that bomb-out in Adagio work fine when I run them from Crystal.
This issue is not resolved for me yet.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#46953 - 08/20/15 01:54 PM Re: Crystal Reports Custom Reports AR 150625 [Re: Samuel Kopstick]
Tony Martin Offline
Adagio Scholar

Registered: 07/17/00
Posts: 96
Loc: Chatham, Ontario, Canada
Hi Samuel:

Did you see my note about the version...what version does your AR report?
_________________________
Tony Martin
Code 6 Programming
519.359.0918

Top
#46954 - 08/20/15 02:11 PM Re: Crystal Reports Custom Reports AR 150625 [Re: Tony Martin]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
I am running the reports accessing tables from OE & AR.
The AR is 9.2A(150410).
The OE is 9.2A(150729)
(I am trying to use the most-current versions.)
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#46958 - 08/20/15 02:41 PM Re: Crystal Reports Custom Reports AR 150625 [Re: Samuel Kopstick]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
A common problem with Crystal Reports "works for me and not the client" is the printer driver. Try printing to AdagioPDF.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#46961 - 08/20/15 03:33 PM Re: Crystal Reports Custom Reports AR 150625 [Re: Douglas Dickie]
Tony Martin Offline
Adagio Scholar

Registered: 07/17/00
Posts: 96
Loc: Chatham, Ontario, Canada
I've tried printing to AdagioPDF ...same result.
_________________________
Tony Martin
Code 6 Programming
519.359.0918

Top
#46967 - 08/20/15 03:56 PM Re: Crystal Reports Custom Reports AR 150625 [Re: Tony Martin]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
Hi Tony,

Other possible differences may be the dictionary used for creating the report (ie you have a dictionary in \softrak\dict that your client does not have), or that you have MS Visual C++ Runtime versions on your workstation that your client does not have. Perhaps there are other system files or other differences apart from these.

Are you creating CustomReports or ModifiedReports to run from Adagio? Or is PrintTool being used to print the custom report? That might make a difference, particularly with the ODBC connection but perhaps also the dictionaries.

I presume that your client is able to print the Standard Reports in Adagio 9.2A successfully and it is just the custom-written reports with a problem.

I could not locate a particular reason for the 'Unspecified Error' message.
_________________________
Regards,
Softrak Tech Support

Top
#46978 - 08/21/15 08:37 AM Re: Crystal Reports Custom Reports AR 150625 [Re: Softrak Support]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
I changed the report printer in the Crystal Report to AdagioPDF & re-saved the file.
(And just to be sure, I uninstalled on my laptop the ODBC and re-installed.)
The report is saved to C:\SOFTRAK\Receivables\CustomReports
In Adagio AR, I ran the report twice from two separate companies (different clients' data), but the end result is that we still receive: "Unspecified error"
When I run the same report from Crystal, the report runs properly.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#47033 - 08/28/15 07:24 AM Re: Crystal Reports Custom Reports AR 150625 [Re: Samuel Kopstick]
Tony Martin Offline
Adagio Scholar

Registered: 07/17/00
Posts: 96
Loc: Chatham, Ontario, Canada
Tried printing with PrintTool....prints fine when using "saved data", but crashes when I try to refresh.

I'm thinking it's one of two things:
Parameters: Report has parameters. They aren't fancy, don't look up info and aren't cascading.
ODBC Driver: I've noticed there are some things I can't do in Crystal while using the Adagio ODBC (like using formulae in linking), perhaps one of the Crystal functions I've used (inadvertently) is causing the ODBC read to fail.

As an immediate solution, this client is buying Crystal for themselves and I will recreate the report on site.

I'll keep you posted...
_________________________
Tony Martin
Code 6 Programming
519.359.0918

Top
#47034 - 08/28/15 07:59 AM Re: Crystal Reports Custom Reports AR 150625 [Re: Tony Martin]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
I doubt this will solve the problem, but you shouldn't be saving the data with the report.

If you want, you can upload the data and the RPT and we can try and recreate the problem here.
_________________________
Andrew Bates

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 50 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30