Crystal Reporting against JDE files

[Graham_Aberdein1]

Hi there,

I'm wondering if anyone out there is using Crystal Reports to access JDE
ledger files (e.g. F0902. F0911)?

Can the JDE files be accessed directly by Crystal Reports and how?

Does JDE security control access to data being retrieved by an external
reporting tool, or does Crystal Reports have its own security to handle
this?

Any information is appreciated.

Cheers,
Graham G. Aberdein
Clarica
Email: graham. aberdein@clarica .com
Running WorldSoftware A.7.3 cum 11

 

[jzimmerm]

Graham,
We use Crystal Reports, but we first replicate our JDE files to SQL Server
tables. Crystal then hits those tables and not our JDE files directly.
We use DataMirror Transformation Server for the AS/400 and Microsoft SQL
Server. This product allows for continuous mirroring. Works fine for us,
and security is not an issue.

Jim Zimmerman
Sterling Chemicals - ICS
(409) 942-3616
A7.3 cum 8, Crystal 7.0

 

[brian]

I've used Crystal Reports extensively against JDE World files. I set it up
so that Crystal is actually running against MS Access tables that have been
linked through Client Access ODBC to the AS400.

I was forced to code my own business unit security routines which forced me
to call some Client Access API's to retrieve the User Name. Otherwise,
security is pretty much wide open.

It has been an inexpensive extremely useful tool.

Brian Whitney
System Tech Consulting Inc
http://www.systemtechcorp.com

>

 

[LTYLER]

Hi

I have used Crystal 7 Info on JDE but only in a test environment. You can
link Crystal to JDE via an ODBC link.
But we have decided not to pursue the Crystal route.

Louise Tyler
QBE Insurance





Graham Aberdein <[email protected]>@jdelist.com on 30/01/2001
19:33:02

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:

Subject: Crystal Reporting against JDE files ~~0:4766


Hi there,

I'm wondering if anyone out there is using Crystal Reports to access JDE
ledger files (e.g. F0902. F0911)?

Can the JDE files be accessed directly by Crystal Reports and how?

Does JDE security control access to data being retrieved by an external
reporting tool, or does Crystal Reports have its own security to handle
this?

Any information is appreciated.

Cheers,
Graham G. Aberdein
Clarica
Email: graham. aberdein@clarica .com
Running WorldSoftware A.7.3 cum 11





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=4766

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************





________________________________________________________________________
This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp