Cross Tab function?

I have my data summed and groupd properly to send to Crystal for a cross
tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
fit with the total.
So is there a Cross Tab function that I have missed that will gen the
dataset form me?
TIAHow will doing the work in SQL Server instead of Crystal have any effect on
the amount of data you can fit on a piece of paper? This sounds like a font
size issue to me...
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||Sorry Stephen,
there's no such thing like a cross-tab function in SQL 2000 (it is in
2005) but you can create a cross-tab report by using CASE. There's a
good example in BOL, just search for cross-tab report
M|||Stephen,
Might look at:
http://support.microsoft.com/defaul...b;EN-US;q175574
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OGad6VB0FHA.2312@.TK2MSFTNGP14.phx.gbl...
> How will doing the work in SQL Server instead of Crystal have any effect
> on the amount of data you can fit on a piece of paper? This sounds like a
> font size issue to me...
Because Crystal determines all sizes for columns, and I can get them smaller
if I had all the rows preset in the dataset. If I controled it, I may be
able to make it happen.