Crystal Reports Landscape printer setup

I'm using crystal reports 4.6, any idea how to setup the report page to landscape setting?Oh no, I know I am not helpful but I think it is really time for an upgrade. There are lots of new, sometimes actually useful features in new versions, lots of old features were enhanced and lots of bugs squashed. Stick to CR8 or CR85 if you want to preserve compatibility with old RPTs, or if you have an application that uses OCX or CRPE. Otherwise, go for CRXI.|||ok thanks. so what other version of CR supports landscape printing?|||Report orientation can be changed via File->Printer Setup menu.
It has been so since (at least) CR6, when I saw Crystal for the first time.

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.