• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

UDC Description in Crystal 10

detroit1

Member
Hi,

I am trying to display UDC description on the report for F4102.IBPRP1. I am new to Crystal and I need some help as crystal interface is different from ERW.

I have already added the F0005 to the Database. I am having trouble selecting record for UDC 41/P1.

Also is the table F0005 to be linked to F4102 by F0005.DRKY=F4102.IBPRP1 ?

Any comments are welcome.
 

Larry_Jones

Member
Use a database view that selects the UDC System and UDC Table codes for you. In Crystal you treat the DB View as a table and just link then to the DRKY field. Here's an example:

CREATE OR REPLACE VIEW Commodity_Class_F0005_VIEW (
COMMODITY_CLASS_DRKY ,
DESCRIPTION1_DRDL01 ,
DESCRIPTION2_DRDL02 ,
USER_ID_DRUSER ,
PROGRAM_ID_DRPID ,
DATE_UPDATED_DRUPMJ ,
WORK_STATION_ID_DRJOBN ,
TIMELASTUPDATED_DRUPMT )
AS SELECT
SUBSTR(DRKY,8,3),
DRDL01,
DRDL02,
DRUSER,
DRPID,
JDE2DATE(DRUPMJ),
DRJOBN,
DRUPMT
FROM F0005
WHERE
DRSY='41' AND DRRT='P1'
WITH READ ONLY;
 

detroit1

Member
Thanks Larry, creating the Database View would be the ideal way. Would there be any other way to do this as the System Admin is having some issues in dealing with Database views?
 

Larry_Jones

Member
1. Admin needs to step up to the plate (take night classes at college?)
2. A really ugly way would be to use a subreport in Crystal ... and no, I'm not about to attempt to walk you through that.
 

Aarto

Member
Hi all!

We're using CR 10 at a clients site. If configured properly, you should be able to see the UDC descriptions as "columns" when you select which columns should be included in the report. (these "virtual table columns" appear just below the actual column in the selection panel)

I do not have access to the client at the moment but i believe this is a setting in the CR equivalent of the ODBC/ODA driver

in essence, there should be no need to create joins/lookups to F4005 unless you want to use description 2 or the special handling codes.

Hope this helps...
 

Larry_Jones

Member
Aarto,

The option to show the UDC description or even UDC virtual tables is a specialized feature of the ODA or JDEDirect ODBC drivers. Native database drivers (whether ODBC or OLEDB) are ignorant of the internal organization of application data such as UDCs - hence the need to build specialized views.

I have discussed reasons why we don't use ODA or JDEDirect before, but briefly ODA has issues and limitations while JDEDirect is very expensive.
 

merk

Member
I believe you can check/set the option on the OneWorld ODA Data Source for "Convert User Defined Codes" and this will do the trick.

The other options to view Tables, Views or both is also useful.

Karim
 

Parag K

Member
Hi,

I am using Crystal Report XI R2. Could you plese guide me how I can have the virtual column for the UDC values from JDE.

At present I can see the UDE description, but I need to use udc code as well as description.

I am using OneWorld ODA and OneWorld ODA Ora connection

Parag
 
Top