Can I set a table to display 20 rows and then scroll instead of expanding down the page? (SSRS 2005 )
Can I set a table to display 20 rows and then scroll instead of expanding down several page? (SSRS 2005 )
October 7th, 2010 6:30pm
can you be more specific .. thanks BB
October 7th, 2010 8:06pm
Hi JohnSLG, If I understand you correctly, you want to restrict the number of the rows to 20 in one table, there might be more than one tables on your report, now you want to display these tables with only 20 rows on one page. Okay, to this requirement, you could put the table into a list which grouped by =ceiling(Rownumber(nothing)/20) ,then set report’s INTERACTIVESIZE property to zero. For detailed steps, please follow below steps: 1. Drag a list control into your report body, then right-click the list ->Properties->Edit details group… 2. Type =ceiling(RowNumber(nothing)/20) in the expression . 3. Click Ok 4. Drag your original table control into this list. 5. Click on the little gray square in the top left corner or in the pale yellow section outside the report layout area, to find out the InteractiveSize property on the left property window, then set its value to zero. Browser it in IE, the whole report will be displayed on one page with 20 rows on one table Best regards, Challen Fu
October 8th, 2010 10:30am
I actually have three tables that I am trying to keep on one page. I tired the above and it created dozens of smaller tables over several pages...although it only claimed to be one page in length.
October 8th, 2010 3:31pm
Hi JohnSLG, There might be some misunderstanding to your requirement. Based on my understanding, In your first post, I notice that you want to display all the tables on one page with certain rows, in you second post, you mentioned that you just want to display three tables on one page. Could you please correct my understanding? If you want to display a certain rows on one table, you could utilize the list control groupbed by expression =ceiling(Rownumber(nothing)/N) , you could reset the N depending on your requirement, if you want to display only three tables on one page, you could add another list control to achieve this, refer to this similar thread . If you want to display all the report content on one page. You could set the value of InteractiveSize property to zero, which is used by the HTML rendering extension. Thanks, Challen Fu
October 11th, 2010 9:37am
I don't want a long table to push other tables off the page. I tired putting them all in lists with the ceiling expression and it didn't work. From reading other threads I got the impression that SSRS doesn't allow one to limit the growth of tables and adding a vertical scrollbar.
October 11th, 2010 4:06pm
Hi Challen , It works great for fixing the number of rows for a table. Thanx a lot. Regars, Chander Sharma
February 26th, 2011 6:45am