Two Fields in one row

[#1]

I have a field that says "Customer - Balance" and I have a field that says "Customer-Days O/S". I need a straight table that for the dimension lists these in one column.

For the expression I can do two calculation and use the LEN and MID function to find either "Balance" or "Days O/S" to put the proper equation in the expression. So it would look something like:

Column 1 Column 2

Customer - Balance $23,434

Customer-Days O/S 25

I know that this is normally done like this:

Column 1 Column2 (Balance) Column 3 (Days O/S)

Customer $23,434 25

But the user needs to export to excel in the two column format . Can this be done?

Thanks,

Stephen

[#2]

try using "crosstable"..

Crosstable

A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. To turn a cross table into a straight table, you can use a crosstable prefix.

The syntax is:

crosstable ( attribute field , data field [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field is the field to contain the attribute values.

data field is the field to contain the data values.

n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1.

-Lester

[#3]

Thanks Iprosete, crosstable did the trick.

THanks,

Stephen