Page Size as a Report Parameter?

This might be a newbie question, but can the page size be set as a report
parameter?
Thanks!
MichaelNo you can't. When wondering what you can set dynamically you can tell by
seeing if it accepts an expression. This does not accept an expression so
there is no way to set it with a report parameter.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
news:DF6FE8B2-5776-4925-9509-4C75C8446E4A@.microsoft.com...
> This might be a newbie question, but can the page size be set as a report
> parameter?
> Thanks!
> Michael|||Thanks!
My dilema is that I need to be able to allow the user to change the page
size/target printer in IE. I have that all figured out (what a pain getting
page/preview settings), but I now need to control RS from IE. The only way I
see how, based on your comments, is to dynamically create the RDL on the fly.
I am already exploring that at the moment for the reporting engine anyway,
but it would be nice NOT to have to generate RDL files every time the page
settings are changed in IE.
On a side note, I was also thinking of having RS generate the HTML minus
page breaks and handle the printer/page settings in IE against the raw HTML,
but I don't see a clean way to get the table header rows to repeat. (it
appears I would also have to create my own handler for RS.)
Converging IE and RS is a pain right now, but it will be a great solution if
I can get this last piece figured out. If you know of any other direction to
take on this, I would appreciate your comments.
Thanks again!
"Bruce L-C [MVP]" wrote:
> No you can't. When wondering what you can set dynamically you can tell by
> seeing if it accepts an expression. This does not accept an expression so
> there is no way to set it with a report parameter.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> news:DF6FE8B2-5776-4925-9509-4C75C8446E4A@.microsoft.com...
> > This might be a newbie question, but can the page size be set as a report
> > parameter?
> >
> > Thanks!
> > Michael
>
>|||I would not make any effort on printing until you see how acceptable the
local printing support with SP2 (out mid month) is.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
news:98A13C00-AB0A-4770-8184-619D1BD16DFD@.microsoft.com...
> Thanks!
> My dilema is that I need to be able to allow the user to change the page
> size/target printer in IE. I have that all figured out (what a pain
getting
> page/preview settings), but I now need to control RS from IE. The only way
I
> see how, based on your comments, is to dynamically create the RDL on the
fly.
> I am already exploring that at the moment for the reporting engine anyway,
> but it would be nice NOT to have to generate RDL files every time the page
> settings are changed in IE.
> On a side note, I was also thinking of having RS generate the HTML minus
> page breaks and handle the printer/page settings in IE against the raw
HTML,
> but I don't see a clean way to get the table header rows to repeat. (it
> appears I would also have to create my own handler for RS.)
> Converging IE and RS is a pain right now, but it will be a great solution
if
> I can get this last piece figured out. If you know of any other direction
to
> take on this, I would appreciate your comments.
> Thanks again!
> "Bruce L-C [MVP]" wrote:
> > No you can't. When wondering what you can set dynamically you can tell
by
> > seeing if it accepts an expression. This does not accept an expression
so
> > there is no way to set it with a report parameter.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> > news:DF6FE8B2-5776-4925-9509-4C75C8446E4A@.microsoft.com...
> > > This might be a newbie question, but can the page size be set as a
report
> > > parameter?
> > >
> > > Thanks!
> > > Michael
> >
> >
> >|||Thanks! I was not aware they were addressing this topic in SP2. I will wait
for sure.
"Bruce L-C [MVP]" wrote:
> I would not make any effort on printing until you see how acceptable the
> local printing support with SP2 (out mid month) is.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> news:98A13C00-AB0A-4770-8184-619D1BD16DFD@.microsoft.com...
> > Thanks!
> >
> > My dilema is that I need to be able to allow the user to change the page
> > size/target printer in IE. I have that all figured out (what a pain
> getting
> > page/preview settings), but I now need to control RS from IE. The only way
> I
> > see how, based on your comments, is to dynamically create the RDL on the
> fly.
> > I am already exploring that at the moment for the reporting engine anyway,
> > but it would be nice NOT to have to generate RDL files every time the page
> > settings are changed in IE.
> >
> > On a side note, I was also thinking of having RS generate the HTML minus
> > page breaks and handle the printer/page settings in IE against the raw
> HTML,
> > but I don't see a clean way to get the table header rows to repeat. (it
> > appears I would also have to create my own handler for RS.)
> >
> > Converging IE and RS is a pain right now, but it will be a great solution
> if
> > I can get this last piece figured out. If you know of any other direction
> to
> > take on this, I would appreciate your comments.
> >
> > Thanks again!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > No you can't. When wondering what you can set dynamically you can tell
> by
> > > seeing if it accepts an expression. This does not accept an expression
> so
> > > there is no way to set it with a report parameter.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> > > news:DF6FE8B2-5776-4925-9509-4C75C8446E4A@.microsoft.com...
> > > > This might be a newbie question, but can the page size be set as a
> report
> > > > parameter?
> > > >
> > > > Thanks!
> > > > Michael
> > >
> > >
> > >
>
>|||Hey, I went looking for the beta signup and it was already removed (I beta
Office Small Business.) Is there a detailed feature list somewhere for this?
"Bruce L-C [MVP]" wrote:
> I would not make any effort on printing until you see how acceptable the
> local printing support with SP2 (out mid month) is.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> news:98A13C00-AB0A-4770-8184-619D1BD16DFD@.microsoft.com...
> > Thanks!
> >
> > My dilema is that I need to be able to allow the user to change the page
> > size/target printer in IE. I have that all figured out (what a pain
> getting
> > page/preview settings), but I now need to control RS from IE. The only way
> I
> > see how, based on your comments, is to dynamically create the RDL on the
> fly.
> > I am already exploring that at the moment for the reporting engine anyway,
> > but it would be nice NOT to have to generate RDL files every time the page
> > settings are changed in IE.
> >
> > On a side note, I was also thinking of having RS generate the HTML minus
> > page breaks and handle the printer/page settings in IE against the raw
> HTML,
> > but I don't see a clean way to get the table header rows to repeat. (it
> > appears I would also have to create my own handler for RS.)
> >
> > Converging IE and RS is a pain right now, but it will be a great solution
> if
> > I can get this last piece figured out. If you know of any other direction
> to
> > take on this, I would appreciate your comments.
> >
> > Thanks again!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > No you can't. When wondering what you can set dynamically you can tell
> by
> > > seeing if it accepts an expression. This does not accept an expression
> so
> > > there is no way to set it with a report parameter.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> > > news:DF6FE8B2-5776-4925-9509-4C75C8446E4A@.microsoft.com...
> > > > This might be a newbie question, but can the page size be set as a
> report
> > > > parameter?
> > > >
> > > > Thanks!
> > > > Michael
> > >
> > >
> > >
>
>|||The beta is closed because it is so close to release.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
news:476739F9-95C9-4AC0-9629-2E715710FB54@.microsoft.com...
> Hey, I went looking for the beta signup and it was already removed (I beta
> Office Small Business.) Is there a detailed feature list somewhere for
this?
> "Bruce L-C [MVP]" wrote:
> > I would not make any effort on printing until you see how acceptable the
> > local printing support with SP2 (out mid month) is.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> > news:98A13C00-AB0A-4770-8184-619D1BD16DFD@.microsoft.com...
> > > Thanks!
> > >
> > > My dilema is that I need to be able to allow the user to change the
page
> > > size/target printer in IE. I have that all figured out (what a pain
> > getting
> > > page/preview settings), but I now need to control RS from IE. The only
way
> > I
> > > see how, based on your comments, is to dynamically create the RDL on
the
> > fly.
> > > I am already exploring that at the moment for the reporting engine
anyway,
> > > but it would be nice NOT to have to generate RDL files every time the
page
> > > settings are changed in IE.
> > >
> > > On a side note, I was also thinking of having RS generate the HTML
minus
> > > page breaks and handle the printer/page settings in IE against the raw
> > HTML,
> > > but I don't see a clean way to get the table header rows to repeat.
(it
> > > appears I would also have to create my own handler for RS.)
> > >
> > > Converging IE and RS is a pain right now, but it will be a great
solution
> > if
> > > I can get this last piece figured out. If you know of any other
direction
> > to
> > > take on this, I would appreciate your comments.
> > >
> > > Thanks again!
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > No you can't. When wondering what you can set dynamically you can
tell
> > by
> > > > seeing if it accepts an expression. This does not accept an
expression
> > so
> > > > there is no way to set it with a report parameter.
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "moflaherty" <moflaherty@.discussions.microsoft.com> wrote in message
> > > > news:DF6FE8B2-5776-4925-9509-4C75C8446E4A@.microsoft.com...
> > > > > This might be a newbie question, but can the page size be set as a
> > report
> > > > > parameter?
> > > > >
> > > > > Thanks!
> > > > > Michael
> > > >
> > > >
> > > >
> >
> >
> >