Skip to Content
author's profile photo Former Member
Former Member

Display the Description based on Position, Product and Location (HELP) :)

I need some help. I have been trying to figure this one out on my own with no success.

What I am wanting to do is build an auto-populating description for columns K06S1-25 based on K05PHL1 (product-
PET, CR, DB) and K05ICNT (Inventory Center's- 07,08 or 10) that displays K05DESC (which varies from product and location)

Please see attached jpg for details. I tried to be as descriptive as possible in the attachment. Thanks in advance for any help you can provide. I am new at all of this, I am slowly learning but SLOWLY..

Thanks,

JJ

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on May 28, 2013 at 11:04 PM

    Hello Jarrod

    What product are you using? CR and SAP Business One?

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 29, 2013 at 07:18 AM

    Hi Jarrod,

    Do you also have sample data with how the Position column should look in the report?

    I'm sorry but I didn't really understand the requirement.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2013 at 09:28 AM

    Hi Jarrod,

    It seems that you might need to convert a 'Row' into a 'Column' or vice-versa.For the images, have you stored them as a column in a table.

    What is the reporting datasource? is it SAP BW.

    -Prathamesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2013 at 12:48 PM

    Guys, I'm Sorry for not being clear. I am trying to write a Crystal Reports Formula to display a column heading. this is a report that our dealer will be able to run that shows where there order is in the manufacturing process.

    Here is the formula I attempted that doesn't work:
    if {K05F1.K05POS}=1 then {K05F1.K05DESC}

    The following table defines what stage of Manufacturing the product is in by plant location (ICNT), Product (PHL1) and its physical stage in the manufacturing process (DESC)

    K05ICNT K05POS K05VAL K05DESC K05PHL1 07 1 RG RUNGEAR PET 07 2 PL CUT PET 07 3 SM SEAMER PET 07 4 RL ROLL PET 07 5 Q1 QUE 1 PET 07 6 FU FITUP PET 07 7 PD PRE-DETAIL PET 07 8 DT DETAIL PET 07 9 MN MANIPULATOR PET 07 10 FN FINAL PET 07 11 AT AIR TEST PET 07 12 MT MOUNT PET 07 13 Q2 QUE 2 PET 07 14 P1 PIPING CELL 1 PET 07 15 P2 PIPING CELL 2 PET 07 16 P3 PIPING CELL 3 PET 07 17 P4 PIPING CELL 4 PET 07 18 OT TEST PET 07 19 WA WASH PET 07 20 PA PAINT PET 07 21 FF FINAL FINISH PET 07 22 W2 WASH 2 PET 07 23 RW REWORK PET 07 24 ST STAMP PET 07 1 RG RUN GEAR DB 07 2 PL CUT DB 07 3 SM SEAMER DB 07 4 RL ROLL DB 07 5 Q1 QUE 1 DB 07 6 FU FIT UP DB 07 7 FR FRAME DB 07 8 Q2 QUE 2 DB 07 9 Q3 QUE 3 DB 07 10 FN FINAL DB 07 11 MT MOUNT DB 07 12 P1 PIPING CELL 1 DB 07 13 P2 PIPING CELL 2 DB 07 14 WT WATER TEST DB 07 15 WA WASH DB 07 16 PT PAINT DB 07 17 W2 WASH 2 DB 07 18 GR GREEN DB

    I am going to show the 25 possible stages horizontally across a table with the DESC.

    Underneath will be the order number with a graphical image showing the trailers status in the manufacturing process. I can figure out the images later. I really am concerned with creating the formula to display the Description shown in the table based on the location and product.

    Is that Better?

    PS.. This table only shows inventory center 07 but there are actually 3 - "07", "08", "10"

    Message was edited by: Jarrod Johnson

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Its really not creating the crosstab that I want to do. Is it possible to delete this whole post and start again.

      I am just looking to create a Custom formula.

      Please disregard the previous Picture and description from your mind. Please look at the New Picture I have attached.. I think this should clear it up. along with the following notes.

      (please note on example 2, I accidentally added a blank column)

      One other bit of critical info:

      K06S1 = K05POS,1

      K06S2 = K05POS,2

      K06S3 = K05POS,3

      K06S4 = K05POS,4

      In example 1 of the RAW DATA:

      K06ORDNO = 29231

      K06PHL1 = FLO

      K06ICNT= 08

      So K06S1 Should have a column heading of FLO PLASMA

      K06S2 should have a column heading of FLO QUE1 , as shown in EX 1 Customer Displayed Data

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.