HOW TO ARRANGE ROWS INTO COLUMNS IN A LIST REPORT

[crn.professional]

Hi,

I would like to know how to arrange the row values as columns in a list report. Here is my example

Category                 Period               Value
ELECTRONICS          10                     100
MECHANICAL            11                       50

i WOULD LIKE TO SEE LIKE THIS

CATEGORY                 period   VALUE    period      values
ELECTRONICS            10         100         
mechanical                                            11             50

Could you please let me know how to do that.

Thanks in advance.

[mikegreen]

Make period1, value1, period2, value2 calculations..
Make period1 CASE category so when it is electronics then period, else null
then case period2 when category = mechanical then period, else null.

I'm not sure why you would want to do this, though.

regards,

Mike

[bdybldr]

I agree with Mike.  This doesn't make sense to me either.  You don't want to display period 11 for electronics...just mechanical?

Will you provide some insight as to the impetus for this type of requirement so we can provide more assistance?  Just curious.  Thanks.