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

[Former Member]

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

[Former Member]

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

[abhilash_kumar]

Hi Jarrod,

Ok. I think i understand what you're trying to do. You can build a Mock-Crosstab to achieve this.

Have a look at this example on how to create the Mock Crosstab:

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/10c4c9c3-a275-2b10-bfa6-87b265d5a0d9

-Abhilash

[Former Member]

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

[Former Member]

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

[abhilash_kumar]

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

[former_member183750]

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

[Former Member]

Crystal Reports