Data from table displayed in Columns

[lukeirelandwild]

I have a number of product codes which have the same 7 digits followed by 3 digits showing size. What I want to do is display the 7 digit code on the left and then the stock figure from my stock table across the report as follows:

001 002 003 004 etc
ABCDEFG 2 4 3 7 etc


I am using Crystal Vesion 8.5

Thanks in advance for your help.

Luke

 

[lbass]

Create two formulas:

//{@rowfield}:
left({table.string},7)

//{@colfield}:
right({table.string},3)

Insert a crosstab and add {@rowfield} as the row and {@colfield} as the column. Not sure what your summary is.

-LB

 

[lukeirelandwild]

The summary is the field held in a table of stock, so I need to find out value in that table where the part is the composite of rowfield+colfield

What formula would I use for summary value?

 

[lbass]

You don't need a formula. Just insert the {stock.field} or whatever the field name is, and insert the summary that makes sense--a sum or a count, I'm guessing.

-LB

 

[lukeirelandwild]

LB you are a star. Thanks for responding so quickly.

I owe you one!

Luke