JDE & Crystal 8 connectivity
JDE & Crystal 8 connectivity
(OP)
Can someone walk me through how to setup my ODBC/ODA connection so that the names of the fields and tables come out in a user friendly format. I know it can be done because I've read numerous pages on the JDE site and Crystal that says it can be done. Their partners.
Basically what I'm seeing is
Table Field
F4101 IMITM
What I want to see is the long table (Item Master) and field names (Item Number). I'm trying to write several reports using Crystal and it is taking forever to mine through all these tables and fields. Any help you can give would be greatly appreciated. Thanks.
Susan
Basically what I'm seeing is
Table Field
F4101 IMITM
What I want to see is the long table (Item Master) and field names (Item Number). I'm trying to write several reports using Crystal and it is taking forever to mine through all these tables and fields. Any help you can give would be greatly appreciated. Thanks.
Susan
RE: JDE & Crystal 8 connectivity
Thanks.
RE: JDE & Crystal 8 connectivity
If you go to the "Management Menu" you should be able to type a "40" in the selection and it will bring up a form that you can type the name of the table in. Press enter and it will list the fields, description, type, length & position. I've copied and pasted this info into a spreadsheet so I can reference it. I hope this is of some help to you.
If you find a true "data mapping" source or a way to set up the ODBC connection so that it converts it to a user friendly format, please let me know.
RE: JDE & Crystal 8 connectivity
Which version of OneWorld are you using? JDE has a report writer incorporated into their package. I have just started to look into it as Crystal is very difficult to apply to JDE. Are you familiar with the JDE report writer?
RE: JDE & Crystal 8 connectivity
RE: JDE & Crystal 8 connectivity
Dan
RE: JDE & Crystal 8 connectivity
Crystal is a better choice by miles.
N
RE: JDE & Crystal 8 connectivity
RE: JDE & Crystal 8 connectivity
Greg
RE: JDE & Crystal 8 connectivity
I've been reading the reporting issue. Two years ago we've investigated what report tool we were going to use for OneWorld. A visit to Denver learned us that the JDE Report Writer is not user friendly at all. We've chosen Cognos as our reporting tool ans are still satisfied with this choice, very powerful with Impromptu and Powerplay.
We are a leading multinational Pharmaceutical company, I'm based in Europe.
I hope this helps you with your choice.