Results 1 to 6 of 6

Thread: Get UDC Description in Crystal Reports

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

    Get UDC Description in Crystal Reports

    Can Any one help me how to get UDC description in Crystal report.

    I have one table column Location Code (ex. 101, 102, 103) for this there is UDC in JDE 55/CL which has description for this codes...

    I need to display the description from UDC 55/CL to crystal report....

    Please help...
    my email id is parag.kathare@gmail.com

    Regards,
    Parag Kathare


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

    Re: Get UDC Description in Crystal Reports

    From Crystal how are you accessing the Database?

    - Directly using ODBC or OLEDB?
    - Using JDE Connector?
    - Using OneWorld ODA ODBC?

    and lastly . . . what versions of JDE are you rinning and database/version?
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

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

    Re: Get UDC Description in Crystal Reports

    I am acessing the database through JDE connector.
    When I login to Crystal under create new connection it shows me "JDE Enterprise One", I use that as my source..


    I am using JDE E811 and Crystal Report XI R2...

    Is there any config which i need to do....

    How I will know in crystal that, one data dictionary item or table column is attached with UDC....

    Please Help...

    Regards,
    Parag Kathare

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

    Re: Get UDC Description in Crystal Reports

    Can any one help me how to access individual crystal report in JDE Enterprise One Menu...

    If anyone can give the steps, it will be more helpful....

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

    Re: Get UDC Description in Crystal Reports

    Hi Larry...

    Can you help me ...how i can supress line in crystal reports...like we supress in JDE using "Supress Section Write"

  6. #6
    Member
    Join Date
    May 2001
    Location
    Florence, AL
    Posts
    63

    Re: Get UDC Description in Crystal Reports

    There are two solutions. One is to configure the ODBC connection to provide them instead of the code. You'll find this in Configure Data Source under the ODBC Data Source Administrator. The other (more useful imho) is to fetch them in a sub report and bring them back. this lets you retain the code for sort/select purposes but show the description on the printed page.

    Supressing sections is found in the section expert. report/section expert
    8.11 SP1 Tools 8.98.3.2
    I5 - 550 V6R1

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.