| Groups | Blog | Home |
sql server reporting services : linked matrix together on same page?
I have a report that is 2 thin columns: a date and an avg value for
that date. Naturally this doesn't take much space on the page, and the longer this report gets the more pages it takes up. Rather than waste this on-screen real estate, I was wondering if it is possible to have the matrix repeat across the page, either a set number of times or until the page determines that a new page is needed i.e. pg1 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 pg2 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 1/11/2007 | 8.2 1/14/2007 | 5.2 1/12/2007 | 5.4 1/15/2007 | 7.3 possible, or "would be nice, but..." ?
[quoted text, click to view]
On May 18, 9:01 am, Kevin Blount <kevin.blo...@gmail.com> wrote: > I have a report that is 2 thin columns: a date and an avg value for > that date. Naturally this doesn't take much space on the page, and the > longer this report gets the more pages it takes up. Rather than waste > this on-screen real estate, I was wondering if it is possible to have > the matrix repeat across the page, either a set number of times or > until the page determines that a new page is needed > > i.e. > > pg1 > 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 > 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 > 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 > > pg2 > 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 > 1/11/2007 | 8.2 1/14/2007 | 5.2 > 1/12/2007 | 5.4 1/15/2007 | 7.3 > > possible, or "would be nice, but..." ? Probably the best thing to do in this case is to use a multi-column report and then limit your rows per column. here are some steps: 1. In the BIDS 'Layout' view, select the 'Report' tab. 2. Select 'Report Properties' from the drop-down list. 3. Select the 'Layout' tab. 4. Select the desired number of columns below 'Columns:' 5. Select space between columns below 'Spacing:' and select the 'Ok' button. 6. Add a List to the report in layout view and insert the matrix inside it. 7. Right click the new list and select 'Properties' from the drop-down list, 8. Select the 'Edit details group...' button. 9. On the 'General' tab, below 'Group on:' and 'Expression' type in the following: =Ceiling(RowNumber(Nothing)/30) [NOTES: (a) The format above is: =Ceiling(RowNumber(Nothing)/ NumberOfRowsPerColumn). (b) Make sure that the new list is the full width of the first column. (c) The main column cannot be any wider than 3 and 1/8 inches.] Hope this helps. Regards, Enrique Martinez Sr. Software Consultant
[quoted text, click to view]
On May 18, 1:09 pm, EMartinez <emartinez....@gmail.com> wrote: > On May 18, 9:01 am, Kevin Blount <kevin.blo...@gmail.com> wrote: > > > > > I have a report that is 2 thin columns: a date and an avg value for > > that date. Naturally this doesn't take much space on the page, and the > > longer this report gets the more pages it takes up. Rather than waste > > this on-screen real estate, I was wondering if it is possible to have > > the matrix repeat across the page, either a set number of times or > > until the page determines that a new page is needed > > > i.e. > > > pg1 > > 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 > > 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 > > 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 > > > pg2 > > 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 > > 1/11/2007 | 8.2 1/14/2007 | 5.2 > > 1/12/2007 | 5.4 1/15/2007 | 7.3 > > > possible, or "would be nice, but..." ? > > Probably the best thing to do in this case is to use a multi-column > report and then limit your rows per column. here are some steps: > 1. In the BIDS 'Layout' view, select the 'Report' tab. > 2. Select 'Report Properties' from the drop-down list. > 3. Select the 'Layout' tab. > 4. Select the desired number of columns below 'Columns:' > 5. Select space between columns below 'Spacing:' and select the 'Ok' > button. > 6. Add a List to the report in layout view and insert the matrix > inside it. > 7. Right click the new list and select 'Properties' from the drop-down > list, > 8. Select the 'Edit details group...' button. > 9. On the 'General' tab, below 'Group on:' and 'Expression' type in > the following: > > =Ceiling(RowNumber(Nothing)/30) > > [NOTES: (a) The format above is: =Ceiling(RowNumber(Nothing)/ > NumberOfRowsPerColumn). > (b) Make sure that the new list is the full width of the first > column. > (c) The main column cannot be any wider than 3 and 1/8 > inches.] > > Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant Hi Enrique, Thanks for the reply and suggestion. I'll give this a go and let you know how I get on :) Kevin
How do i include other table with different dataset? We get error for it ? [quoted text, click to view] "EMartinez" wrote:
> On May 18, 9:01 am, Kevin Blount <kevin.blo...@gmail.com> wrote: > > I have a report that is 2 thin columns: a date and an avg value for > > that date. Naturally this doesn't take much space on the page, and the > > longer this report gets the more pages it takes up. Rather than waste > > this on-screen real estate, I was wondering if it is possible to have > > the matrix repeat across the page, either a set number of times or > > until the page determines that a new page is needed > > > > i.e. > > > > pg1 > > 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 > > 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 > > 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 > > > > pg2 > > 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 > > 1/11/2007 | 8.2 1/14/2007 | 5.2 > > 1/12/2007 | 5.4 1/15/2007 | 7.3 > > > > possible, or "would be nice, but..." ? > > > Probably the best thing to do in this case is to use a multi-column > report and then limit your rows per column. here are some steps: > 1. In the BIDS 'Layout' view, select the 'Report' tab. > 2. Select 'Report Properties' from the drop-down list. > 3. Select the 'Layout' tab. > 4. Select the desired number of columns below 'Columns:' > 5. Select space between columns below 'Spacing:' and select the 'Ok' > button. > 6. Add a List to the report in layout view and insert the matrix > inside it. > 7. Right click the new list and select 'Properties' from the drop-down > list, > 8. Select the 'Edit details group...' button. > 9. On the 'General' tab, below 'Group on:' and 'Expression' type in > the following: > > =Ceiling(RowNumber(Nothing)/30) > > [NOTES: (a) The format above is: =Ceiling(RowNumber(Nothing)/ > NumberOfRowsPerColumn). > (b) Make sure that the new list is the full width of the first > column. > (c) The main column cannot be any wider than 3 and 1/8 > inches.] > > Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant >
Issue resolved by sub report
[quoted text, click to view] "NAVIN.D" wrote:
> > How do i include other table with different dataset? We get error for it ? > > > "EMartinez" wrote: > > > On May 18, 9:01 am, Kevin Blount <kevin.blo...@gmail.com> wrote: > > > I have a report that is 2 thin columns: a date and an avg value for > > > that date. Naturally this doesn't take much space on the page, and the > > > longer this report gets the more pages it takes up. Rather than waste > > > this on-screen real estate, I was wondering if it is possible to have > > > the matrix repeat across the page, either a set number of times or > > > until the page determines that a new page is needed > > > > > > i.e. > > > > > > pg1 > > > 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 > > > 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 > > > 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 > > > > > > pg2 > > > 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 > > > 1/11/2007 | 8.2 1/14/2007 | 5.2 > > > 1/12/2007 | 5.4 1/15/2007 | 7.3 > > > > > > possible, or "would be nice, but..." ? > > > > > > Probably the best thing to do in this case is to use a multi-column > > report and then limit your rows per column. here are some steps: > > 1. In the BIDS 'Layout' view, select the 'Report' tab. > > 2. Select 'Report Properties' from the drop-down list. > > 3. Select the 'Layout' tab. > > 4. Select the desired number of columns below 'Columns:' > > 5. Select space between columns below 'Spacing:' and select the 'Ok' > > button. > > 6. Add a List to the report in layout view and insert the matrix > > inside it. > > 7. Right click the new list and select 'Properties' from the drop-down > > list, > > 8. Select the 'Edit details group...' button. > > 9. On the 'General' tab, below 'Group on:' and 'Expression' type in > > the following: > > > > =Ceiling(RowNumber(Nothing)/30) > > > > [NOTES: (a) The format above is: =Ceiling(RowNumber(Nothing)/ > > NumberOfRowsPerColumn). > > (b) Make sure that the new list is the full width of the first > > column. > > (c) The main column cannot be any wider than 3 and 1/8 > > inches.] > > > > Hope this helps. > > > > Regards, > > > > Enrique Martinez > > Sr. Software Consultant > >
I ran into the same problem and found this post. This was easy enough to do
but is causing a few small problems. Let me first describe my situation I need to show Group 1 Item 1, Item 2, Item 3.....Item N Group 2 Item 1, Item 2, Item 3.....Item N I can probably fit 5 items across the page. When I reach 6 items it puts a page break before going to the next line in the web view. On a print preview, each of the "Item Lines" is given its own page. Also, if I export it to excel, each of the "item lines" is give its own tab. Am I doing something wrong? [quoted text, click to view] "EMartinez" wrote:
> On May 18, 9:01 am, Kevin Blount <kevin.blo...@gmail.com> wrote: > > I have a report that is 2 thin columns: a date and an avg value for > > that date. Naturally this doesn't take much space on the page, and the > > longer this report gets the more pages it takes up. Rather than waste > > this on-screen real estate, I was wondering if it is possible to have > > the matrix repeat across the page, either a set number of times or > > until the page determines that a new page is needed > > > > i.e. > > > > pg1 > > 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 > > 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 > > 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 > > > > pg2 > > 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 > > 1/11/2007 | 8.2 1/14/2007 | 5.2 > > 1/12/2007 | 5.4 1/15/2007 | 7.3 > > > > possible, or "would be nice, but..." ? > > > Probably the best thing to do in this case is to use a multi-column > report and then limit your rows per column. here are some steps: > 1. In the BIDS 'Layout' view, select the 'Report' tab. > 2. Select 'Report Properties' from the drop-down list. > 3. Select the 'Layout' tab. > 4. Select the desired number of columns below 'Columns:' > 5. Select space between columns below 'Spacing:' and select the 'Ok' > button. > 6. Add a List to the report in layout view and insert the matrix > inside it. > 7. Right click the new list and select 'Properties' from the drop-down > list, > 8. Select the 'Edit details group...' button. > 9. On the 'General' tab, below 'Group on:' and 'Expression' type in > the following: > > =Ceiling(RowNumber(Nothing)/30) > > [NOTES: (a) The format above is: =Ceiling(RowNumber(Nothing)/ > NumberOfRowsPerColumn). > (b) Make sure that the new list is the full width of the first > column. > (c) The main column cannot be any wider than 3 and 1/8 > inches.] > > Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant >
We can resolve extrra page problem by reducing the the space provided below the matrix, reduce the body size to ur design size. Reduce it from right and bottom as well u can overcome the issue. [quoted text, click to view] "Kevin Blount" wrote:
> I have a report that is 2 thin columns: a date and an avg value for > that date. Naturally this doesn't take much space on the page, and the > longer this report gets the more pages it takes up. Rather than waste > this on-screen real estate, I was wondering if it is possible to have > the matrix repeat across the page, either a set number of times or > until the page determines that a new page is needed > > i.e. > > pg1 > 1/1/2007 | 2.5 1/4/2007 | 2.4 1/7/2007 | 5.4 > 1/2/2007 | 5.2 1/5/2007 | 8.2 1/8/2007 | 1.9 > 1/3/2007 | 3.4 1/6/2007 | 8.3 1/9/2007 | 7.0 > > pg2 > 1/10/2007 | 4.5 1/13/2007 | 1.4 1/16/2007 | 3.4 > 1/11/2007 | 8.2 1/14/2007 | 5.2 > 1/12/2007 | 5.4 1/15/2007 | 7.3 > > possible, or "would be nice, but..." ? >
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 |