String Serial Numbers show multiple values left to right

[davismar]

I have a string value: tblCustomerInventory.Serial Number.

The results display the serial number in multiple values.

How do I format this data to appear across the page from left to right - so I don't eat up so much paper when displaying/printing the report?

 

[IanWaterman]

Please give a sample of data as it ci=urrently display and then how you want it to display.

Not sure what you want to achieve

Ian

 

[davismar]

Currently Displayed as:

Item # Item Description Serial#

0910048 Phone 2B2145
2B2146


Want to Display as:

Item # Item Description Serial #
0910048 Phone 2B2145 2B2146 etc.

 

[IanWaterman]

Looks like you have a carriage retun CHRW(13) or a line feed CHRW(10)
Try this formula using 13 or 10 and see which one it might be

@replace
replace({yourfield), chrw(13), ' ')

Ian

 

[lbass]

Try inserting a crosstab that uses the item and item desc as row fields and the serial number as the column field. For the summary, use max of serial number and then remove the grid and suppress the column field.

Or you can insert a group on item # and then create the following formulas:

//{@reset} for the item group header:
whileprintingrecords;
stringvar x;
if not inrpeatedgroupheader then
x := "";

//{@accum} for the detail section:
whileprintingrecords;
stringvar x := x + {table.serialnumber} + " ";

//{@display} for the item group footer:
whileprintingrecords;
stringvar x;

Then suppress the group header and detail section and drag the item # and description to the group footer next to {@display}.

-LB

 

[lbass]

typo - should be "inrepeatedgroupheader".

-LB