Results 1 to 9 of 9

Thread: UDC Description in Crystal 10

  1. #1

    UDC Description in Crystal 10

    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.

    Analyst/Programmer
    JDE Tools Release 8.97

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246

    Re: UDC Description in Crystal 10

    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;
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3

    Re: UDC Description in Crystal 10

    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?
    Analyst/Programmer
    JDE Tools Release 8.97

  4. #4
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246

    Re: UDC Description in Crystal 10

    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.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  5. #5
    Member Aarto's Avatar
    Join Date
    Oct 2000
    Location
    Copenhagen, Denmark
    Posts
    397

    Re: UDC Description in Crystal 10

    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...
    Aarto Reponen

    Senior JD Edwards/Serialization consultant, xperitus Denmark Aps - Your JDE experts in Scandinavia
    Part of Redfaire International, Oracle platinum partner
    LinkedIn

  6. #6
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246

    Re: UDC Description in Crystal 10

    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.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  7. #7
    New Member
    Join Date
    Feb 2003
    Location
    BC, Canada
    Posts
    11

    Re: UDC Description in Crystal 10

    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
    ERP 8.0/B7334; SQL2K; W2K; And (sigh) NT4TSE/Citrix 1.8

  8. #8
    New Member
    Join Date
    Mar 2009
    Posts
    21

    Re: UDC Description in Crystal 10

    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

  9. #9
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246

    Re: UDC Description in Crystal 10

    Its been 10 years . . . but I believe all you have to do is configure your ODA ODBC Data Source . . .
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.