|
|
You're in the
sql server reporting services
group:Is there a way to turn off Pagination???
sql server reporting services:
breaks in automatically. The problem is, RS puts a page break in if the following item wont fit completly in the space below, but will fit in the next page. I'm sure there must be some setting we can use to turn this off, perhaps via rendering a report from code? The closest I've come to solving this solution is seperating large textboxes into multiple small ones, but this only works in extreme cases, about 5% of the time. The problem may be to do with the behaviour of a list? If I instead use a table to contain everything, would it act any differently? FYI, this is the structure of my report: List1 --Textboxes1 --List2 ----Textboxes2 ----Table1 ----Textboxes3 ----Table2 ----Table3 ----Textboxes4 ----Table4 --EndList2 EndList1 My problem occurs when redering the items in List 2. RS will attempt to put an entire result of List 2 on one page if possible, breaking if needs be onto a new page. This is not necisary, as I have already implemented special breaking rules for when this actually needs to be done. List 1 is never a problem, as its always way to big to even consider fitting it on one page. I read some posts that by changing the size of the column to a certain size resolves this issue, but I cant change my layout dramatically as it is specially formatted for a particular presentation. Any advice would be much appreciated!! Thanks,
Are you only concerned about pagination in HTML output (e.g. through report
manager) and in report designer preview mode? Other rendering formats (PDF, etc.) have to render to physical page sizes - therefore you can't prevent page breaks once the report (and its margins) exceed the page size. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Arkiliknam" <Arkiliknam@discussions.microsoft.com> wrote in message news:6D1972D5-B466-4B6F-9E31-1DF63D263774@microsoft.com... >I really need to render a report that does not decide where to put page > breaks in automatically. The problem is, RS puts a page break in if the > following item wont fit completly in the space below, but will fit in the > next page. > > I'm sure there must be some setting we can use to turn this off, perhaps > via > rendering a report from code? > > The closest I've come to solving this solution is seperating large > textboxes > into multiple small ones, but this only works in extreme cases, about 5% > of > the time. > > The problem may be to do with the behaviour of a list? If I instead use a > table to contain everything, would it act any differently? > > FYI, this is the structure of my report: > > List1 > --Textboxes1 > --List2 > ----Textboxes2 > ----Table1 > ----Textboxes3 > ----Table2 > ----Table3 > ----Textboxes4 > ----Table4 > --EndList2 > EndList1 > > My problem occurs when redering the items in List 2. RS will attempt to > put > an entire result of List 2 on one page if possible, breaking if needs be > onto > a new page. This is not necisary, as I have already implemented special > breaking rules for when this actually needs to be done. List 1 is never a > problem, as its always way to big to even consider fitting it on one page. > > I read some posts that by changing the size of the column to a certain > size > resolves this issue, but I cant change my layout dramatically as it is > specially formatted for a particular presentation. > > Any advice would be much appreciated!! > > Thanks, > Andre
I need to render a PDF.
I realize RS shouldnt split up a single Object such as a long textbox, that is why I created multiple textboxes that split up the data. The hope was to have RS fit Textbox A on page 1, and put Textbox B on page 2, instead of putting everything on page 2 and leaving a large white space. Instead, it seams to look at the List (which holds Textboxes A & B) as a single object and fit it on its own page if possible, so nothing really changed. My question is, can you turn off Pagination for that List, so that the Items within it can be split up all the time, instead of only when the List wont fit in the next page completly. Thanks, Andre [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Are you only concerned about pagination in HTML output (e.g. through report > manager) and in report designer preview mode? > > Other rendering formats (PDF, etc.) have to render to physical page sizes - > therefore you can't prevent page breaks once the report (and its margins) > exceed the page size. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Arkiliknam" <Arkiliknam@discussions.microsoft.com> wrote in message > news:6D1972D5-B466-4B6F-9E31-1DF63D263774@microsoft.com... > >I really need to render a report that does not decide where to put page > > breaks in automatically. The problem is, RS puts a page break in if the > > following item wont fit completly in the space below, but will fit in the > > next page. > > > > I'm sure there must be some setting we can use to turn this off, perhaps > > via > > rendering a report from code? > > > > The closest I've come to solving this solution is seperating large > > textboxes > > into multiple small ones, but this only works in extreme cases, about 5% > > of > > the time. > > > > The problem may be to do with the behaviour of a list? If I instead use a > > table to contain everything, would it act any differently? > > > > FYI, this is the structure of my report: > > > > List1 > > --Textboxes1 > > --List2 > > ----Textboxes2 > > ----Table1 > > ----Textboxes3 > > ----Table2 > > ----Table3 > > ----Textboxes4 > > ----Table4 > > --EndList2 > > EndList1 > > > > My problem occurs when redering the items in List 2. RS will attempt to > > put > > an entire result of List 2 on one page if possible, breaking if needs be > > onto > > a new page. This is not necisary, as I have already implemented special > > breaking rules for when this actually needs to be done. List 1 is never a > > problem, as its always way to big to even consider fitting it on one page. > > > > I read some posts that by changing the size of the column to a certain > > size > > resolves this issue, but I cant change my layout dramatically as it is > > specially formatted for a particular presentation. > > > > Any advice would be much appreciated!! > > > > Thanks, > > Andre > >
Not entirely sure I understand what you are trying to achieve - but you
could try to use rectangles as container of the textboxes and control page breaks on the rectangles. But for PDF output the important properties are the PageWidth and PageHeight on the Report element in report designer. If the report body / reportitems + margins are too large, they won't fit on one page. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Arkiliknam" <Arkiliknam@discussions.microsoft.com> wrote in message news:96B9ECF0-0C77-40A6-81C3-478ACB9D489D@microsoft.com... >I need to render a PDF. > > I realize RS shouldnt split up a single Object such as a long textbox, > that > is why I created multiple textboxes that split up the data. > > The hope was to have RS fit Textbox A on page 1, and put Textbox B on page > 2, instead of putting everything on page 2 and leaving a large white > space. > Instead, it seams to look at the List (which holds Textboxes A & B) as a > single object and fit it on its own page if possible, so nothing really > changed. > > My question is, can you turn off Pagination for that List, so that the > Items > within it can be split up all the time, instead of only when the List wont > fit in the next page completly. > > Thanks, > Andre > > "Robert Bruckner [MSFT]" wrote: > >> Are you only concerned about pagination in HTML output (e.g. through >> report >> manager) and in report designer preview mode? >> >> Other rendering formats (PDF, etc.) have to render to physical page >> sizes - >> therefore you can't prevent page breaks once the report (and its margins) >> exceed the page size. >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Arkiliknam" <Arkiliknam@discussions.microsoft.com> wrote in message >> news:6D1972D5-B466-4B6F-9E31-1DF63D263774@microsoft.com... >> >I really need to render a report that does not decide where to put page >> > breaks in automatically. The problem is, RS puts a page break in if the >> > following item wont fit completly in the space below, but will fit in >> > the >> > next page. >> > >> > I'm sure there must be some setting we can use to turn this off, >> > perhaps >> > via >> > rendering a report from code? >> > >> > The closest I've come to solving this solution is seperating large >> > textboxes >> > into multiple small ones, but this only works in extreme cases, about >> > 5% >> > of >> > the time. >> > >> > The problem may be to do with the behaviour of a list? If I instead use >> > a >> > table to contain everything, would it act any differently? >> > >> > FYI, this is the structure of my report: >> > >> > List1 >> > --Textboxes1 >> > --List2 >> > ----Textboxes2 >> > ----Table1 >> > ----Textboxes3 >> > ----Table2 >> > ----Table3 >> > ----Textboxes4 >> > ----Table4 >> > --EndList2 >> > EndList1 >> > >> > My problem occurs when redering the items in List 2. RS will attempt to >> > put >> > an entire result of List 2 on one page if possible, breaking if needs >> > be >> > onto >> > a new page. This is not necisary, as I have already implemented special >> > breaking rules for when this actually needs to be done. List 1 is never >> > a >> > problem, as its always way to big to even consider fitting it on one >> > page. >> > >> > I read some posts that by changing the size of the column to a certain >> > size >> > resolves this issue, but I cant change my layout dramatically as it is >> > specially formatted for a particular presentation. >> > >> > Any advice would be much appreciated!! >> > >> > Thanks, >> > Andre >> >> >>
Sorry, let me try and explain what I'm trying to accomplish in more detail.
What I am creating is a 3 column product catalogue consisting of up to 200 pages. I have: - a List of Categories - a List of Sub Categories (within the Categories list) - a List of Products (within the SubCategtories list) and within the product, there are numerous textboxes, tables, etc. A Product often takes up more than one entire column (and as far as I can see, RS treats columns as pages). The requirement is that Products are printed on the A4 sheet continuosly, leaving minimal white space. This is where my problem begins. Because each product uses its List template, it treats each single Product as an entire object. RS then attempts to fit an entire Object in one column at the expense of leaving a lot of white space in the previous column where I would like it to begin. The problem then goes deaper, and when RS has no other solution but to allow a Product to be split accross one or more columns, it then attempts to keep each Object within the list together. In my case, each Product has a list of Attributes, and RS will attempt to keep this list together at the expense of leaving chunks of white space on the previous column where it should have started. So basically, I'd like to get RS to stop putting in page breaks at the end of objects and groups of objects, and to just print continuously, only breaking when there is an element that can not be split accross pages (like a single Picture, or Textbox). Does this sound possible? There are options like Keep Together, is there a way to say Dont Even Try To Keep Together? :) I'll give 2 examples below (lets say an A4 page takes up 05 rows) of what I want, and what I get: 1) Wanted Outcome: Page1----- 01Computers 02--Hardware 03----JVC Cd Burner 04------PICTURE 05------descriptiona... Page2----- 01------descriptionb... 02------Speed: 03--------descriptiona... 04--------descriptionb... 05------Price: Page3----- 01--------descriptiona... 02--------descriptionb... 03------Release date: 04--------descriptiona... 05--------descriptionb... 1) Actual Outcome: Page1----- 01Computers 02--Hardware 03----JVC Cd Burner 04------PICTURE 05------"" Page2----- 01------descriptiona... 02------descriptionb... 03------Speed: 04--------descriptiona... 05--------descriptionb... Page3----- 01------Price: 02--------descriptiona... 03--------descriptionb... 04------"" 05--------"" Page4----- 01------Release date: 02--------descriptiona... 03--------descriptionb... 04----"" 05----"" So what should have fit into 3 pages get spread over into 4 and leave lots of white space (""). Hope it makes sense. I dont know a better way of showing what I mean, appart from taking screen shots or even sending the rdl... Thanks for your help, Andre [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Not entirely sure I understand what you are trying to achieve - but you > could try to use rectangles as container of the textboxes and control page > breaks on the rectangles. > > But for PDF output the important properties are the PageWidth and PageHeight > on the Report element in report designer. If the report body / reportitems + > margins are too large, they won't fit on one page. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > "Arkiliknam" <Arkiliknam@discussions.microsoft.com> wrote in message > news:96B9ECF0-0C77-40A6-81C3-478ACB9D489D@microsoft.com... > >I need to render a PDF. > > > > I realize RS shouldnt split up a single Object such as a long textbox, > > that > > is why I created multiple textboxes that split up the data. > > > > The hope was to have RS fit Textbox A on page 1, and put Textbox B on page > > 2, instead of putting everything on page 2 and leaving a large white > > space. > > Instead, it seams to look at the List (which holds Textboxes A & B) as a > > single object and fit it on its own page if possible, so nothing really > > changed. > > > > My question is, can you turn off Pagination for that List, so that the > > Items > > within it can be split up all the time, instead of only when the List wont > > fit in the next page completly. > > > > Thanks, > > Andre > > > > "Robert Bruckner [MSFT]" wrote: > > > >> Are you only concerned about pagination in HTML output (e.g. through > >> report > >> manager) and in report designer preview mode? > >> > >> Other rendering formats (PDF, etc.) have to render to physical page > >> sizes - > >> therefore you can't prevent page breaks once the report (and its margins) > >> exceed the page size. > >> > >> -- Robert > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> "Arkiliknam" <Arkiliknam@discussions.microsoft.com> wrote in message > >> news:6D1972D5-B466-4B6F-9E31-1DF63D263774@microsoft.com... > >> >I really need to render a report that does not decide where to put page > >> > breaks in automatically. The problem is, RS puts a page break in if the > >> > following item wont fit completly in the space below, but will fit in > >> > the > >> > next page. > >> > > >> > I'm sure there must be some setting we can use to turn this off, > >> > perhaps > >> > via > >> > rendering a report from code? > >> > > >> > The closest I've come to solving this solution is seperating large > >> > textboxes > >> > into multiple small ones, but this only works in extreme cases, about > >> > 5% > >> > of > >> > the time. > >> > > >> > The problem may be to do with the behaviour of a list? If I instead use > >> > a > >> > table to contain everything, would it act any differently? > >> > > >> > FYI, this is the structure of my report: > >> > > >> > List1 > >> > --Textboxes1 > >> > --List2 > >> > ----Textboxes2 > >> > ----Table1 > >> > ----Textboxes3 > >> > ----Table2 > >> > ----Table3 > >> > ----Textboxes4 > >> > ----Table4 > >> > --EndList2 > >> > EndList1 > >> > > >> > My problem occurs when redering the items in List 2. RS will attempt to > >> > put > >> > an entire result of List 2 on one page if possible, breaking if needs > >> > be > >> > onto > >> > a new page. This is not necisary, as I have already implemented special > >> > breaking rules for when this actually needs to be done. List 1 is never > >> > a > >> > problem, as its always way to big to even consider fitting it on one > >> > page. > >> > > >> > I read some posts that by changing the size of the column to a certain > >> > size > >> > resolves this issue, but I cant change my layout dramatically as it is > >> > specially formatted for a particular presentation. > >> > > >> > Any advice would be much appreciated!! > >> > > >> > Thanks, > >> > Andre > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |