Display report horizontally

rajvja
rajvja used Ask the Experts™
on
Hi,
  I have a table with 3 fields. Category, ProdName, Price
I want to generate a report like

Category1  ProdName1  Price  ProdName2 Price2 ProdName3 Price3 (group by category)
Category2  ProdName2  Price2
Category3  ProdName1  Price1 ProdName3 Price3

I used Matrix tool. But its not displaying as I expected. Displayed as

Category1  ProdName1  Price       ProdName2 Price2      ProdName3 Price3 (group by category)
Category2  <should start here>    ProdName2  Price2
Category3  ProdName1  Price1     <should show here>   ProdName3 Price3

How can I do this

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What reporting tool are you using?

mlmcc
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Judging by your comments you are using a crosstab for the data.

WHen you group, it groups by category for rows and the coluns are for the products so each product is shown in its own column.

To do what you want will require using a manual table and the method differs depending on the reporting tool you are using.

mlmcc

Author

Commented:
Thanks for the reply.

I got this by adding a column which I used as column group

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial