Changing Orientation of Report (display) (1 Viewer)

[Danny00lee]

How do I change the orientation of a report from vertical to horizontal? For example:

Product Mod 1 Mod 2 Mod 3
SK LV 1 10 30 10
SK LV 2 4 10 8
SK LV 3 2 12 5
SK LV 4 1 2 3
SK LV 5 1 1 1

Any assistance would be helpful. Thanks in advance.

 

[Trevor G]

Either take the data into Excel and look to copy it and then use Paste Special and Transpose or possibly look to use a Cross Tab query and use the query as the report source.

 

[Danny00lee]

@ Trevor, thanks that is what I need

 

[Trevor G]

Thanks for letting me know you have a working solution.