• 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!

Crystal Reports & OW UDC File

wsellers

Active Member
Hay Y'all

While this is not a OW question it is related to using OW. My apology if you don't feel it belongs on the List.

Using Seagate Crystal Reports with OW, I need to know how to link the UDC table (F0005) to another file using the UDC code to pull the related UDC description into a report. The way I've tried to link the tables I'm getting an error saying the field are different lengths.

Walt Sellers
Heil Environmental Industries, Ltd.
OW B733.2 SP10, Citrix, Windows NT TS2000, Oracle 8.1.6
 
Walt,
What is the other table you are trying to link to and the other field name?

J Boulden
CNC
Praxair Inc.




wsellers <wsellers@ftpayne.heilco.com> on 05/23/2001 09:25:28 AM
 

Larry_Jones

Legendary Poster
Walt,

Assuming that you aren't using ODA, create a database view (outside of OneWorld) for the particular UDC sub-table you want. The view (actually a select statement) should restrict the select to a particular UDC table and reduce the size of the UDC code to match the actual code length in the table you're linking to. You can then use this view in crystal to link to.

Show below example to your DBA. He/she will need to determine schema (normally PRODDTA) and grant access:

CREATE OR REPLACE VIEW Commodity_Class_F0005_VIEW (
Commodity_Class_DRKY ,
Description1_DRDL01 ,
Description2_DRDL02 )
AS SELECT
SUBSTR(LTRIM(DRKY),1,3),
DRDL01,
DRDL02
FROM F0005
WHERE
DRSY='41' AND DRRT='P1'
WITH READ ONLY;



Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 

wsellers

Active Member
Thanks Larry,
Although I didn't create database view, your use of LTRIM gave me an idea. After linking the tables and entering my data selection, I edited the SQL query and set my first table field equal to the left trim of the UDC table field.
I've linked irem branch item price group equal to the left trim of the UDC key.
F4102."IBPRGR" = LTRIM( F0005."DRKY")
Part of my data selection also narrows F0005."DRSY"="40" and F0005,"DRRT"="PI".

Using this setup I was able to extract the UDC description into my report.

Thanks for your help.
"Happy Happy" :):)

Walt Sellers
Heil Environmental Industries, Ltd.
OW B733.2 SP10, Citrix, Windows NT TS2000, Oracle 8.1.6
 
Top