RS2005 Report Paper / Page / Scaling - Setup

Hi,
I've a report with more than 20 columns in it. I want to print this
report in "1 page wide/Multi page tall" scaling & also in "Legal paper
- Landscape orientation". I was able to set the Landscape in the Page
setup, but not the scaling/Paper selection! Is there any way to do this
setting for each report in RS? Right now, the columns are getting
printed in multiple pages.
Actually I've this report in Excel as well. As you know, in excel I can
set the "Print Area and all the Page setup" through a macro which is
running properly. Now, I cannot ask the users to generate the report in
RS and export the report to Excel, then set the "Print Area & Page
setup" & then Print it, which I don't think they'll buy it. I also dont
want to have a separate front-end in .Net or something else to do this
setup!
Is there any way to do this in RS 2005?
Thanks,
GaneshThe only way I have managed to do this is programmatically. I get the
report as a Metafile image using the webservice and can then print this
image scaled to the paper afterwards.
Craig
"Ganesh" <imsganesh2@.gmail.com> wrote in message
news:1142364252.533688.323570@.i39g2000cwa.googlegroups.com...
> Hi,
> I've a report with more than 20 columns in it. I want to print this
> report in "1 page wide/Multi page tall" scaling & also in "Legal paper
> - Landscape orientation". I was able to set the Landscape in the Page
> setup, but not the scaling/Paper selection! Is there any way to do this
> setting for each report in RS? Right now, the columns are getting
> printed in multiple pages.
> Actually I've this report in Excel as well. As you know, in excel I can
> set the "Print Area and all the Page setup" through a macro which is
> running properly. Now, I cannot ask the users to generate the report in
> RS and export the report to Excel, then set the "Print Area & Page
> setup" & then Print it, which I don't think they'll buy it. I also dont
> want to have a separate front-end in .Net or something else to do this
> setup!
> Is there any way to do this in RS 2005?
> Thanks,
> Ganesh
>|||Thanks Craig!
Can't we do this any other reporting tool? How about in Crystal
Reports. I remember doing this when I was on Crystal Reports a year
back. Is there no other way to do this? I can't sell RS to my users
(who are very comfortable with Excel 2000) without this option.
or Can you tell me how you did this programmatically to get report as a
Metafile and print it?
Thank you!|||Hi All,
Can anyone please tell me whether this is not possible at all in
RS2005, so that I don't have to waste much time in searching for this
all over the net?
Thanks!

rs2000 summing up calculated columns

Hey,
I've got a few columns that called a custom assembly and fetch results
more or less correctly, but at the end of the column I'd like to sum up
that column.
Does it have a way of doing Sum(col3) or something, so I dont have to
implement any more custom assembly goodness?
Also, can I do =(col1+col2)?
Thanks in advance
Weston WeemsI suggest you create a calculated field. Do a right mouse click on your
field list, add an expression that calls your code. Now at this point it
will look like any other field and you can just sum it.
You can definitely do a sum(field1.value + field2.value) but that will be
using the field list, it is not summing your text boxes. You could need to
do this sum(Code.Mycode(field1.value) + Code.MyCode(field2.value)). Gets
confusing, which is why adding your own field to the field list is a good
idea in this instance.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Weston Weems" <wweems@.gmail.nospammers.com> wrote in message
news:eimVKly3FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hey,
> I've got a few columns that called a custom assembly and fetch results
> more or less correctly, but at the end of the column I'd like to sum up
> that column.
> Does it have a way of doing Sum(col3) or something, so I dont have to
> implement any more custom assembly goodness?
> Also, can I do =(col1+col2)?
> Thanks in advance
> Weston Weemssql