How can I change the report layout in Discoverer Viewer?
Discoverer Viewer supports direct pivoting of items in the result set to change the layout of your worksheet. ‘Drag bars’ located next to each item – axis items, page items, data items – allow you to drag and drop the item, thus pivoting the report. You do this by simply dragging and dropping the items to where you want them. To pivot multiple items at the same time you can use the ‘Table/Crosstab Layout’ link.