(SSRS 2005) I have a report with 4 tables, each in a rectangle. The tables will return varying numbers of rows based on report parameters. Is there anyway to fix the size of a table/box/rectangle/list and if more than a given number of rows are returned, scroll bars will appear? Currently I might get a table with 19 pages of rows which pushes the other tables 19 pages back. I want each table to be visible on the report but have scroll bars to show individual data rows.

Hi JohnSLG, Currently, we might not be able to achieve this requirement in SSRS2005, to workaround the issue, you could lay the four tables into a list control, then give the list a group, the group's expression is =Ceiling(RowNumber(nothing)/10), then the report will display table1's first 10 records, then table2's first 10 records, table3...table4....Then table1's 11-20 records, table2's 11-20 records, table3...table4....and so on, of course it is not a grace method, just a workaround. Thanks for your understanding. Thanks, Challen Fu

Challen RowNumber should be generated in T-SQL??Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I'm using MDX, not T-SQL.

It never ceases to amaze me that a company that designed an OS called "Windows" can't do windows in a report. Thanks anyway.

Hi Uri Dimant, RowNumber is a report level function in reporting services not in T-SQL, which returns a running count of all rows in the specified scope, you could click this link RowNumber Function (Reporting Services) for more informaion, hope this helps. @JohnSLG, I know your requirement is reasonable, I still hope Reporting service could meet this demand. However, Reporting services 2005 could not design this layout like your description. My first reply is workaround for you, you could get some reference from it. Here I would recommend you to submit a feedback to Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Regards, Challen Fu

then give the list a group Never used a list before...don't see how to "give it a group". I did edit the details group with =Ceiling(RowNumber(nothing)/10) but the report failed.

I thought you was aware of this step. From your information, I still notice that you have already give the list a group lastly, if you still have not get the steps for creating a group for the list, you could refer to below: 1. Right-click the list control, and select Properties. 2. Click Edit Details Group button in the list property dialog box. 3. Then you will see expression textbox, you could select the datafield or customized group in the expression. Here you mentioned the report failed, could you please more specific about your statement? if the report could preview but not your designed layout. I have already said this is just a workaround not a grace solution. If there is some error, could you please give the error message and detailed steps of creating the report? Then we could diagnose where the error come from, is it come from the incorrect steps or some incorrect expression. If your designed report layout must be achieved in your way, you could contact Microsoft Customer Suport Services (CSS) directly via http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

I thought you was aware of this step. From your information, I still notice that you have already give the list a group lastly, if you still have not get the steps for creating a group for the list, you could refer to below: 1. Right-click the list control, and select Properties. 2. Click Edit Details Group button in the list property dialog box. 3. Then you will see expression textbox, you could select the datafield or customized group in the expression. Here you mentioned the report failed, could you please more specific about your statement? if the report could preview but not your designed layout. I have already said this is just a workaround not a grace solution. If there is some error, could you please give the error message and detailed steps of creating the report? Then we could diagnose where the error come from, is it come from the incorrect steps or some incorrect expression. If your designed report layout must be achieved in your way, you could contact Microsoft Customer Suport Services (CSS) directly via http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS