I almost have this figured out. In the details I have gather the values for each field and add them to an array for each field.
Example:
arrID:= ["C01", "C02", "C03", "C04"];
arrPrice:= ["400", "500", "400", "500"];
Then in the footer, I created a formula for each field. In the formula, I iterate through each element in the array and create a string with a line break in between each element. Then I dropped each formula in the footer, and it shows nice columns.
I do have another problem though. In some columns the value wraps to the next line, so that the rest of the column values do not liine up anymore.
Example:
Customer ID Order Number Date Ordered Price
C01 Ord01,206 1/1/2011 $400
C02 Ord02,992 2/1/2011 $500
C03 Ord03,038,6 2/1/2011 $400
C04 0489,9054 3/1/2011 $500
Ord04
I tried to work around this by padding each field with spaces so that that the fields in each row have the same number of spaces and should theoretically wrap.
So in the example above, Order Number associated with ID C03 has a length of 20. I have padded ID, date, and price with with spaces and trimmed so that they have a length of 20.
Example: "C03"
tempID:=left("C03"+space(20),space(20))
tempID should show "C03 "
Since the width is the same between fields, I would have thought that it would wrap the extraneous spaces to the next line, creating what would looke like a break. I envisioned this:
Customer ID Order Number Date Ordered Price
C01 Ord01,206 1/1/2011 $400
C02 Ord02,992 2/1/2011 $500
C03 Ord03,038,6 2/1/2011 $400
0489,9054
C04 Ord04 3/1/2011 $500
Instead the it looks like Crystal is completely ignoring the spaces appended to each string. I have also looked at the length of the padded strings and they are correct. When I add an actual charater at the end of the blank spaces, it looks like there is only one space in between the original string and the additional character.
Example: "C03"
tempID:=left("C03"+space(20),space(20))+"v"
tempID should show "C03 v"
but tempID is showing "C03 v"
and crystal is showing that the length of tempID is 21, even though it appears to be 5.
How can I get Crystal to stop ignorning my blank spaces???
IP Logged
