Rows Instead of Columns

[fsub]

I want to print data in rows instead of columns. For example, I have data...
Acct1 23
Acct1 34
Acct2 39
Acct2 88
Acct3 75
Acct3 92

I want to print it in rows so it'll look....
Acct1 23 34
Acct2 39 88
Acct3 75 92

 

[lbass]

What are the two values per group? Are they summaries of some type? Please identify the field name or show the content if a formula.

-LB

 

[fsub]

Hi LB,

The two values are two records in table2. That is, table1 has Acct1 and table2 contains record1 with a value of 23 and record2 with a value of 34.

Thanks

 

[fsub]

I ended up setting a record counter and variables to store each value in table2. Value 1 is stored in var1, value 2 in var2, etc. I grouped by acct no. and displayed all variables in the group footer.

 

[Madawc]

I think you could have got the same result by a summary total showing the maximum for each acct no. group. (Assuming that was what you wanted.)

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP