Hi Brandon,
I’ve not deployed Crystal Reports on
top of an Axapta database but I’ve done it on Great
Plains, Accpac and a few other systems for exactly the same reason.
The principle is identical.
It works well …. But you do need to
be careful because it isn’t all plain sailing. The following is a list of
issues that my co-workers(current and former) and I have come across. Its
not meant to be exhaustive.
- design
of the queries used to feed Crystal
with data becomes critical, especially when dealing with large databases
and joining multiple tables
- a
sound comprehension of the relationship between the tables is critical if
you don’t want to provide your customer with garbage
- a
sound comprehension of the impact that your query has on the database and
server is important if you don’t want to cripple them when the
report is run
- impact
of uncommitted SQL transactions on your query’s execution and integrity
I hope this helps.
Regards,
Christoph Malherbe
From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Krieger
Sent: 26 August 2005 09:09 PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?
We are on Axapta 2.5 and
use Crystal for
anything other then the "Vanilla" reports contained in Axapta. I've
recently updated to Crystal XI which is server based and web accessible, so now
my users can access any of my reports from inside the enterprise or via the
Internet. Report development, if you know Crystal,
is pretty straight forward, you really just need a understanding of Axapta's
table's and fields for content. The rest, at least in Crystal Developer 11 is
drag and drop. Let me know if you need more info.
Kevin
S Krieger
Information Systems Manager
Subaru Industrial Engines
Robin America, Inc.
Fuji Heavy Industries Ltd
940 Lively Blvd
Wood Dale IL 60191 USA
630-350-8200 / 630-350-8212 Fax
[EMAIL PROTECTED]
http://www.subarupower.com
From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Brandon George
Sent: Friday, August 26, 2005 1:44
PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?
Maurice,
Do you have any
examples, or any suggestions you could point out to me. Do you think you could
get a simple example, or maybe some information of where they replaced an
Axapta Report with a Crystal Report - Report?
thanks,
Brandon
From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Maurice Cohen
Sent: Friday, August 26, 2005 2:47
PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?
Hi Brandon,
One of customer is using Crystal reports with Axapta and
is pretty happy with it. I have never used it myself so I can only rely on
their feedback.
Maurice Cohen
Senior consultant
Advanced
Systems Integration, Inc.
26449 Rancho
Parkway South
Lake Forest, CA 92630
ph:
949-597-2170
fax:
949-597-0720
cell:
949-533-5966
From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.com]
On Behalf Of Brandon George
Sent: Friday, August 26, 2005
11:37 AM
To: Axapta-Knowledge-Village@yahoogroups.com;
development-axapta@yahoogroups.com
Subject:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?
Hello Everyone,
I have some more
advice that I need.
Ok we are getting sick of
using the clunky Axapta Report Designer. So we are investigating how easy it is
just to scrap the Axapta Reports, and do all reports in Crystal Reports?
Has anyone ever done this
before? Does anyone have any examples of using Crystal Reports and Axapta? Does
anyone have any experience at doing such a thing?
thanks in Advance, in
advise on this - either it's bad or good, or examples, any input at all please
give it!
thanks,
Brandon
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
