How do i get rid of page breaks for HTML view...

Hello, I would like to get my reports to be on one page when viewing in HTML
in the report viewer. People generally dont want to have to flip through
pages when looking at reports online... they would much rather see the entire
report and just keep scrolling... however when printing you would want the
page-breaks to still happen (naturall).
Currently in Crystal using their report viewer control I simply removing the
paging controls to get this effect iirc... i tried hiding the paging control
in the RS report viewer control and i simply got a paged report with no way
of advancing through the pages...
Can someone please help me do this.Here is the solution. This works only for RS 2005. RS 2005 introduced
interactivesize which consists of interactivewidth and interactiveheight. To
have no page breaks set the interactiveheight to 0. This only works for
height, not width. You need to get to the report properties. You know how
when you click on the body or a textbox you see the property page for that
element on the right. If you click to the left of the ruler, that gets the
report properties to show (the menu, report properties does allow setting
this). Look for interactivesize, expand and then set interactiveheight to 0.
Not very discoverable but pretty cool.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"thejez" <thejez@.discussions.microsoft.com> wrote in message
news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> Hello, I would like to get my reports to be on one page when viewing in
> HTML
> in the report viewer. People generally dont want to have to flip through
> pages when looking at reports online... they would much rather see the
> entire
> report and just keep scrolling... however when printing you would want the
> page-breaks to still happen (naturall).
> Currently in Crystal using their report viewer control I simply removing
> the
> paging controls to get this effect iirc... i tried hiding the paging
> control
> in the RS report viewer control and i simply got a paged report with no
> way
> of advancing through the pages...
> Can someone please help me do this.|||I think im posting this question to wrong place (but in all fairness its very
confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
control - so i dont see the interactive options. I have RS 2005 but I am
unable to use it because of the limitations of how i can poplate the data (I
have to do pre-aggregation on the data before it gets to the dataset to get
around the aggregate of aggregates lmiitation). So my only option was to use
a local report where i could get the data from the DB pre-process it and then
pop the dataset and then render the report... this a big pain i know but what
can i do...
so is there any way in the VS 2005 ReportViewer and a local Report file
(rdlc). I have height set to 100% on everything and i even went to far as to
define the report at 160in high... but alas the control seems to break at the
same place ignoring everything i throw at it!
:(
"Bruce L-C [MVP]" wrote:
> Here is the solution. This works only for RS 2005. RS 2005 introduced
> interactivesize which consists of interactivewidth and interactiveheight. To
> have no page breaks set the interactiveheight to 0. This only works for
> height, not width. You need to get to the report properties. You know how
> when you click on the body or a textbox you see the property page for that
> element on the right. If you click to the left of the ruler, that gets the
> report properties to show (the menu, report properties does allow setting
> this). Look for interactivesize, expand and then set interactiveheight to 0.
> Not very discoverable but pretty cool.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "thejez" <thejez@.discussions.microsoft.com> wrote in message
> news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > Hello, I would like to get my reports to be on one page when viewing in
> > HTML
> > in the report viewer. People generally dont want to have to flip through
> > pages when looking at reports online... they would much rather see the
> > entire
> > report and just keep scrolling... however when printing you would want the
> > page-breaks to still happen (naturall).
> >
> > Currently in Crystal using their report viewer control I simply removing
> > the
> > paging controls to get this effect iirc... i tried hiding the paging
> > control
> > in the RS report viewer control and i simply got a paged report with no
> > way
> > of advancing through the pages...
> >
> > Can someone please help me do this.
>
>|||Bruce, i managed to just put the <InteractiveHeight>0in</InteractiveHeight>
element into my RDLC file and it worked... so even though there isnt any
design-tim support for setting that value (at least that i saw) adding it to
the source file did the trick.
thanks!
"thejez" wrote:
> I think im posting this question to wrong place (but in all fairness its very
> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> control - so i dont see the interactive options. I have RS 2005 but I am
> unable to use it because of the limitations of how i can poplate the data (I
> have to do pre-aggregation on the data before it gets to the dataset to get
> around the aggregate of aggregates lmiitation). So my only option was to use
> a local report where i could get the data from the DB pre-process it and then
> pop the dataset and then render the report... this a big pain i know but what
> can i do...
> so is there any way in the VS 2005 ReportViewer and a local Report file
> (rdlc). I have height set to 100% on everything and i even went to far as to
> define the report at 160in high... but alas the control seems to break at the
> same place ignoring everything i throw at it!
> :(
> "Bruce L-C [MVP]" wrote:
> > Here is the solution. This works only for RS 2005. RS 2005 introduced
> > interactivesize which consists of interactivewidth and interactiveheight. To
> > have no page breaks set the interactiveheight to 0. This only works for
> > height, not width. You need to get to the report properties. You know how
> > when you click on the body or a textbox you see the property page for that
> > element on the right. If you click to the left of the ruler, that gets the
> > report properties to show (the menu, report properties does allow setting
> > this). Look for interactivesize, expand and then set interactiveheight to 0.
> >
> > Not very discoverable but pretty cool.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > > Hello, I would like to get my reports to be on one page when viewing in
> > > HTML
> > > in the report viewer. People generally dont want to have to flip through
> > > pages when looking at reports online... they would much rather see the
> > > entire
> > > report and just keep scrolling... however when printing you would want the
> > > page-breaks to still happen (naturall).
> > >
> > > Currently in Crystal using their report viewer control I simply removing
> > > the
> > > paging controls to get this effect iirc... i tried hiding the paging
> > > control
> > > in the RS report viewer control and i simply got a paged report with no
> > > way
> > > of advancing through the pages...
> > >
> > > Can someone please help me do this.
> >
> >
> >|||You beat me to it, that is what I was going to suggest.
Also, here is a suggestion for development. Develop reports in RS 2005
designer. The designer is better and you can quickly preview. Don't deploy
the report. Then, rename the rdl file to rdlc and bring it into your
project. This is how I do it. Much nicer development environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"thejez" <thejez@.discussions.microsoft.com> wrote in message
news:1A2F6C1F-3453-412A-AC0E-363C18C89D08@.microsoft.com...
> Bruce, i managed to just put the
> <InteractiveHeight>0in</InteractiveHeight>
> element into my RDLC file and it worked... so even though there isnt any
> design-tim support for setting that value (at least that i saw) adding it
> to
> the source file did the trick.
> thanks!
> "thejez" wrote:
>> I think im posting this question to wrong place (but in all fairness its
>> very
>> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
>> control - so i dont see the interactive options. I have RS 2005 but I am
>> unable to use it because of the limitations of how i can poplate the data
>> (I
>> have to do pre-aggregation on the data before it gets to the dataset to
>> get
>> around the aggregate of aggregates lmiitation). So my only option was to
>> use
>> a local report where i could get the data from the DB pre-process it and
>> then
>> pop the dataset and then render the report... this a big pain i know but
>> what
>> can i do...
>> so is there any way in the VS 2005 ReportViewer and a local Report file
>> (rdlc). I have height set to 100% on everything and i even went to far
>> as to
>> define the report at 160in high... but alas the control seems to break at
>> the
>> same place ignoring everything i throw at it!
>> :(
>> "Bruce L-C [MVP]" wrote:
>> > Here is the solution. This works only for RS 2005. RS 2005 introduced
>> > interactivesize which consists of interactivewidth and
>> > interactiveheight. To
>> > have no page breaks set the interactiveheight to 0. This only works for
>> > height, not width. You need to get to the report properties. You know
>> > how
>> > when you click on the body or a textbox you see the property page for
>> > that
>> > element on the right. If you click to the left of the ruler, that gets
>> > the
>> > report properties to show (the menu, report properties does allow
>> > setting
>> > this). Look for interactivesize, expand and then set interactiveheight
>> > to 0.
>> >
>> > Not very discoverable but pretty cool.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
>> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
>> > > Hello, I would like to get my reports to be on one page when viewing
>> > > in
>> > > HTML
>> > > in the report viewer. People generally dont want to have to flip
>> > > through
>> > > pages when looking at reports online... they would much rather see
>> > > the
>> > > entire
>> > > report and just keep scrolling... however when printing you would
>> > > want the
>> > > page-breaks to still happen (naturall).
>> > >
>> > > Currently in Crystal using their report viewer control I simply
>> > > removing
>> > > the
>> > > paging controls to get this effect iirc... i tried hiding the paging
>> > > control
>> > > in the RS report viewer control and i simply got a paged report with
>> > > no
>> > > way
>> > > of advancing through the pages...
>> > >
>> > > Can someone please help me do this.
>> >
>> >
>> >|||another update... after re-starting visual studio (since my properties window
was laggin very badly) i went back into the report and now i notice that when
you click on the out-grey area of the report i can see the interactive
property... hrmm so it is there... at least now it is... i dont think it was
there before.. but like i said my properties page was acting VERY funky (like
showing the properties for a DD control on another page while editing the
report...)
"thejez" wrote:
> Bruce, i managed to just put the <InteractiveHeight>0in</InteractiveHeight>
> element into my RDLC file and it worked... so even though there isnt any
> design-tim support for setting that value (at least that i saw) adding it to
> the source file did the trick.
> thanks!
> "thejez" wrote:
> > I think im posting this question to wrong place (but in all fairness its very
> > confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> > control - so i dont see the interactive options. I have RS 2005 but I am
> > unable to use it because of the limitations of how i can poplate the data (I
> > have to do pre-aggregation on the data before it gets to the dataset to get
> > around the aggregate of aggregates lmiitation). So my only option was to use
> > a local report where i could get the data from the DB pre-process it and then
> > pop the dataset and then render the report... this a big pain i know but what
> > can i do...
> >
> > so is there any way in the VS 2005 ReportViewer and a local Report file
> > (rdlc). I have height set to 100% on everything and i even went to far as to
> > define the report at 160in high... but alas the control seems to break at the
> > same place ignoring everything i throw at it!
> >
> > :(
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Here is the solution. This works only for RS 2005. RS 2005 introduced
> > > interactivesize which consists of interactivewidth and interactiveheight. To
> > > have no page breaks set the interactiveheight to 0. This only works for
> > > height, not width. You need to get to the report properties. You know how
> > > when you click on the body or a textbox you see the property page for that
> > > element on the right. If you click to the left of the ruler, that gets the
> > > report properties to show (the menu, report properties does allow setting
> > > this). Look for interactivesize, expand and then set interactiveheight to 0.
> > >
> > > Not very discoverable but pretty cool.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> > > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > > > Hello, I would like to get my reports to be on one page when viewing in
> > > > HTML
> > > > in the report viewer. People generally dont want to have to flip through
> > > > pages when looking at reports online... they would much rather see the
> > > > entire
> > > > report and just keep scrolling... however when printing you would want the
> > > > page-breaks to still happen (naturall).
> > > >
> > > > Currently in Crystal using their report viewer control I simply removing
> > > > the
> > > > paging controls to get this effect iirc... i tried hiding the paging
> > > > control
> > > > in the RS report viewer control and i simply got a paged report with no
> > > > way
> > > > of advancing through the pages...
> > > >
> > > > Can someone please help me do this.
> > >
> > >
> > >|||Good advice! Ill do that from now on!
thanks
"Bruce L-C [MVP]" wrote:
> You beat me to it, that is what I was going to suggest.
> Also, here is a suggestion for development. Develop reports in RS 2005
> designer. The designer is better and you can quickly preview. Don't deploy
> the report. Then, rename the rdl file to rdlc and bring it into your
> project. This is how I do it. Much nicer development environment.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "thejez" <thejez@.discussions.microsoft.com> wrote in message
> news:1A2F6C1F-3453-412A-AC0E-363C18C89D08@.microsoft.com...
> > Bruce, i managed to just put the
> > <InteractiveHeight>0in</InteractiveHeight>
> > element into my RDLC file and it worked... so even though there isnt any
> > design-tim support for setting that value (at least that i saw) adding it
> > to
> > the source file did the trick.
> >
> > thanks!
> >
> > "thejez" wrote:
> >
> >> I think im posting this question to wrong place (but in all fairness its
> >> very
> >> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> >> control - so i dont see the interactive options. I have RS 2005 but I am
> >> unable to use it because of the limitations of how i can poplate the data
> >> (I
> >> have to do pre-aggregation on the data before it gets to the dataset to
> >> get
> >> around the aggregate of aggregates lmiitation). So my only option was to
> >> use
> >> a local report where i could get the data from the DB pre-process it and
> >> then
> >> pop the dataset and then render the report... this a big pain i know but
> >> what
> >> can i do...
> >>
> >> so is there any way in the VS 2005 ReportViewer and a local Report file
> >> (rdlc). I have height set to 100% on everything and i even went to far
> >> as to
> >> define the report at 160in high... but alas the control seems to break at
> >> the
> >> same place ignoring everything i throw at it!
> >>
> >> :(
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> > Here is the solution. This works only for RS 2005. RS 2005 introduced
> >> > interactivesize which consists of interactivewidth and
> >> > interactiveheight. To
> >> > have no page breaks set the interactiveheight to 0. This only works for
> >> > height, not width. You need to get to the report properties. You know
> >> > how
> >> > when you click on the body or a textbox you see the property page for
> >> > that
> >> > element on the right. If you click to the left of the ruler, that gets
> >> > the
> >> > report properties to show (the menu, report properties does allow
> >> > setting
> >> > this). Look for interactivesize, expand and then set interactiveheight
> >> > to 0.
> >> >
> >> > Not very discoverable but pretty cool.
> >> >
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> >> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> >> > > Hello, I would like to get my reports to be on one page when viewing
> >> > > in
> >> > > HTML
> >> > > in the report viewer. People generally dont want to have to flip
> >> > > through
> >> > > pages when looking at reports online... they would much rather see
> >> > > the
> >> > > entire
> >> > > report and just keep scrolling... however when printing you would
> >> > > want the
> >> > > page-breaks to still happen (naturall).
> >> > >
> >> > > Currently in Crystal using their report viewer control I simply
> >> > > removing
> >> > > the
> >> > > paging controls to get this effect iirc... i tried hiding the paging
> >> > > control
> >> > > in the RS report viewer control and i simply got a paged report with
> >> > > no
> >> > > way
> >> > > of advancing through the pages...
> >> > >
> >> > > Can someone please help me do this.
> >> >
> >> >
> >> >
>
>