Crystal Report Linking to OE Price Code File

[loydchristmas2]

We run version 7.6.2 SQL. I want to link the open order line file to the price code file, but their is not a direct link. We have pricing by customer #/item number and customer type/item number. How can I link the two files?

 

[dgillz]

Since you are using 2 different types of pricing this is more difficult. For price code 1, the field filler_0001 consists of 12 characters of customer number and the remainder is the item number. For price code 3, the first 5 characters are the customer type and the remainder is the item number.

This would be easier handled with a view on the database side, but if you need to write a report these tables are not linkable and you will have to write a formula field to extract the item number as detailed above and use a subreport in Crystal.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

If I were you, I would start w/ the macola ICR for either customer/item or customer type/item & add the other variable to the existing ICR. You can examine macola's formulas in the ICR to help you figure out the other formula to add. See OE\reports\lists\price code for the ICR options available (PWE only).

 

[Macoladownunder]

Hello loydchristmas2,
dgillz has explained the way we got a link for those tables. We created a SQL view and 'substringed' the filler_001 column to 'split' the concatenated data into 2 separate and linkable columns. Then we wrote reports using a link between OE tables and the new view.
Macola Down Under


MacolaDownUnder
Exact Down Under Users Group - EDUUG
Getting systems that work in Australia and NZ