Create verticle grouping instead of horizontal

Hello,
Generally when using the Report Wizard with MS SQL 2005 it wants to present
the data horizontally, like this:
Item 1 Item2 Item3 Item4 Item5
Value1a Value2a Value3a Value4a Value5a
Value1b Value2b Value3b Value4b Value5b
... and so forth.
Instead of this, I need my report to present the data vertically, like this:
Item1 Value1a Value1b
Item2 Value2a Value2b
Item3 Value3a Value3b
Item4 Value4a Value4b
Item5 Value5a Value5b
I'm actually limiting this query to the Top 4 so it will only show columns
of data. Problem is, I have no idea how change the orientation of the
table. Can someone give me
some guidance on how to accomplish this? I'm using VB.Net 2003 to create
the report.
Thanks,
AlexOn Jul 26, 10:07 am, "Alex" <sama...@.gmail.com> wrote:
> Hello,
> Generally when using the Report Wizard with MS SQL 2005 it wants to present
> the data horizontally, like this:
> Item 1 Item2 Item3 Item4 Item5
> Value1a Value2a Value3a Value4a Value5a
> Value1b Value2b Value3b Value4b Value5b
> ... and so forth.
> Instead of this, I need my report to present the data vertically, like this:
> Item1 Value1a Value1b
> Item2 Value2a Value2b
> Item3 Value3a Value3b
> Item4 Value4a Value4b
> Item5 Value5a Value5b
> I'm actually limiting this query to the Top 4 so it will only show columns
> of data. Problem is, I have no idea how change the orientation of the
> table. Can someone give me
> some guidance on how to accomplish this? I'm using VB.Net 2003 to create
> the report.
> Thanks,
> Alex
You will want to look into using either a matrix report or pivoting
the data in the stored procedure/query that is souring the report.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant