|
|
You're in the
sql server reporting services
group:Page breaks in a Matrix
sql server reporting services:
Is there a way to insert a page break into a matrix based on a grouping? I've found this option for tables....
Yes. Just right-click on the matrix column or row group header, select "edit
group" from the menu, and select "page break at end" from the grouping and sorting dialog. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "certolnut" <whitney_neal@hotmail.com> wrote in message news:%23EJsNT1nFHA.2156@TK2MSFTNGP09.phx.gbl... > Hi > > Is there a way to insert a page break into a matrix based on a grouping? > I've found this option for tables.... > >
I have tried your soulution, I know where is the "edit group" option, and the
dialog apears, but I have found the grouping and sorting dialog... and of course, the "page break at the end" option... I have the same problem... Thanks in advance [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Yes. Just right-click on the matrix column or row group header, select "edit > group" from the menu, and select "page break at end" from the grouping and > sorting dialog. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > "certolnut" <whitney_neal@hotmail.com> wrote in message > news:%23EJsNT1nFHA.2156@TK2MSFTNGP09.phx.gbl... > > Hi > > > > Is there a way to insert a page break into a matrix based on a grouping? > > I've found this option for tables.... > > > > > >
You can only get explicit page breaks after _every_ group or no explicit
page breaks after groups. Are you trying to dynamically control page breaks for groups? This is not supported. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Pato" <Pato@discussions.microsoft.com> wrote in message news:3AD14436-0834-406C-9B47-900C463A6E81@microsoft.com... >I have tried your soulution, I know where is the "edit group" option, and >the > dialog apears, but I have found the grouping and sorting dialog... and of > course, the "page break at the end" option... I have the same problem... > Thanks in advance > > "Robert Bruckner [MSFT]" wrote: > >> Yes. Just right-click on the matrix column or row group header, select >> "edit >> group" from the menu, and select "page break at end" from the grouping >> and >> sorting dialog. >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> "certolnut" <whitney_neal@hotmail.com> wrote in message >> news:%23EJsNT1nFHA.2156@TK2MSFTNGP09.phx.gbl... >> > Hi >> > >> > Is there a way to insert a page break into a matrix based on a >> > grouping? >> > I've found this option for tables.... >> > >> > >> >> >>
I have row & column groups, I want "page breaks" for the column ones, so, my
matrix can change page every group, but the column ones, and repeat the header of the rows... Let's say: Region 1 City 1 | City 2 Id | Desc | SKU Stock | Price | Stock | Price 1 Abc 123 1.1 $10 1.4 $14 2 Bcd 234 2.1 $13 3 $5 So, I want my report to be like this: Page 1: Region 1 City 1 Id | Desc | SKU Stock | Price 1 Abc 123 1.1 $10 2 Bcd 234 2.1 $13 Page 2: Region 1 City 2 Id | Desc | SKU Stock | Price 1 Abc 123 1.4 $14 2 Bcd 234 3 $5 I want my report to breaks, every city group, and put the "header" of the row complete... or let's say, repeat the row grouping [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> You can only get explicit page breaks after _every_ group or no explicit > page breaks after groups. Are you trying to dynamically control page breaks > for groups? This is not supported. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Pato" <Pato@discussions.microsoft.com> wrote in message > news:3AD14436-0834-406C-9B47-900C463A6E81@microsoft.com... > >I have tried your soulution, I know where is the "edit group" option, and > >the > > dialog apears, but I have found the grouping and sorting dialog... and of > > course, the "page break at the end" option... I have the same problem... > > Thanks in advance > > > > "Robert Bruckner [MSFT]" wrote: > > > >> Yes. Just right-click on the matrix column or row group header, select > >> "edit > >> group" from the menu, and select "page break at end" from the grouping > >> and > >> sorting dialog. > >> > >> -- Robert > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> "certolnut" <whitney_neal@hotmail.com> wrote in message > >> news:%23EJsNT1nFHA.2156@TK2MSFTNGP09.phx.gbl... > >> > Hi > >> > > >> > Is there a way to insert a page break into a matrix based on a > >> > grouping? > >> > I've found this option for tables.... > >> > > >> > > >> > >> > >> > >
Sorry, page breaks are not supported for column groupings in matrices. Only
on row groupings. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Pato" <Pato@discussions.microsoft.com> wrote in message news:F85EBB60-21B9-4C85-99FA-9A164AB0F444@microsoft.com... >I have row & column groups, I want "page breaks" for the column ones, so, >my > matrix can change page every group, but the column ones, and repeat the > header of the rows... > > Let's say: > > Region 1 > City 1 | City 2 > Id | Desc | SKU Stock | Price | Stock | Price > 1 Abc 123 1.1 $10 1.4 $14 > 2 Bcd 234 2.1 $13 3 $5 > > So, I want my report to be like this: > > Page 1: > > Region 1 > City 1 > Id | Desc | SKU Stock | Price > 1 Abc 123 1.1 $10 > 2 Bcd 234 2.1 $13 > > > Page 2: > > Region 1 > City 2 > Id | Desc | SKU Stock | Price > 1 Abc 123 1.4 $14 > 2 Bcd 234 3 $5 > > > I want my report to breaks, every city group, and put the "header" of the > row complete... or let's say, repeat the row grouping > > "Robert Bruckner [MSFT]" wrote: > >> You can only get explicit page breaks after _every_ group or no explicit >> page breaks after groups. Are you trying to dynamically control page >> breaks >> for groups? This is not supported. >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >>
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 |