Cross tab in SQL server

Question

Post reply

Cross tab in SQL server

arup chakraborty

Hall of Fame

Points: 3640
More actions
June 4, 2009 at 6:43 am

#205496

Hi,
How to create a cross tab report in SQL server 2005?
Plz help. Its urgent.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Look for PIVOT in Books online.

[font="Verdana"]Markus Bohse[/font]

arup chakraborty Hall of Fame Points: 3640 More actions · Answer 2

I am using SSRS and want an alternative to Crystal reports cross tab tables.

Thanks in advance.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

arup_kc (6/4/2009)
I am using SSRS and want an alternative to Crystal reports cross tab tables.
Thanks in advance.

Then use a matrix in your report. Or as I said before use a PIVOT query as base for your report.

[font="Verdana"]Markus Bohse[/font]

arup chakraborty Hall of Fame Points: 3640 More actions · Answer 4

Hi Marcus,

My problem is, the no. of columns are not defined. they can varry.

So initially I am going to develop the SP using Pivot. I hope this will work. But while using the report, How I will show all the dinamically generated columns? I think cross tab is the only solution. But as I am new in SSRS, I dont know what is the cross tab equivalent in SSRS.

Please give me some detail description about matrix/ tabular report.

Thanks in advance.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 5

About how to add a matrix to your report see here:

http://msdn.microsoft.com/en-us/library/cc627441.aspx

and

http://msdn.microsoft.com/en-us/library/ms157334(SQL.90).aspx

About how to make a dynamic PIVOT, when you don't know3the number of columns see here:

http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx

[font="Verdana"]Markus Bohse[/font]