0

Pebblestone Fashion Matrix (color-size)

Jet Reports Historic Posts

June 17, 2008 12:31

None

Follow

I've been trying to create a pebblestone fashion matrix in JetReports.
The problem lies in the fact that every item could need diffirent columns.

So you get:

Item A | S | M | L
color 1
color 2

Item B | 38 | 42 | 44 | 46
color 1
color 2

The solution I tried is creating columns using the integer table and then try to ask for the sizes per item (like: get the first size, get the second size,…) and try filling up the columns. But I didn't get the desired result.

Can someone help me or share their experience?

Thanks in advance,

Jan DD
Belgium

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts June 19, 2008 10:27

  I got it to work just five minutes ago!
  
  I was on the right track using the integer table, what was new for me was the NL("1") use, so I could reference to the NL("Colums";"Integer";"Number") formula to get a NL(reference;"PfsItem Horz Comp")….
  
  You get the picture…
  Hope this helps some other people too.
  
  
• 0
  
  Jet Reports Historic Posts June 23, 2008 17:49

  That is a very nice chart for items that vary by muliple features. If we had anything like it I'd steal that immediately.

• 0
  
  Jet Reports Historic Posts June 23, 2008 18:57

  Hehe, you can think of several uses for this trick.
  
  fe: you can use it for vendors(suppliers) per item,…