Hi, In SSRS 2005, is there a way to have 2 tables on a page, each displaying a row of data from the same dataset? In other words: Page 1, Table 1 data = row 1 Page 1, Table 2 data = row 2 ---- new page ---- Page 2, Table 1 data = row 3 Page 2, Table 2 data = row 4 and so on?

Just realized, I should clarify what I had above. I'm not using a table in the traditional sense of static column headers and rows of data underneath them. I am using them in this way: | Item ABC123 | | Date: 01/01/2010 | | User: John Smith | Dept: Accounting | | Office Location: NYC | --------------------------------------------------------- | Item XYZ456 | | Date: 01/01/2010 | | User: Jane Dough | Dept: Sales | | Office Location: SFO | Each set above would be a "table", using fields from a single row in the same dataset, grouped by a particular field using detail grouping (item number in the above example). I need to have two of these "tables" per page, one per row in the same dataset.

Hi Psx790, If I understand you correctly, your dataset concludes these datafields: Item/Date/User/Office Location/Dept. What you want is to display the first row of the dataset in the first table, the second row on the second table…..Actually, you could utilize the list control grouped by Item to achieve this requirement. For detailed steps, please follow these: 1. Right-click the detail row to insert other detail rows, based on your draft, you might need to insert four detail rows. 2. Drag the datafields into the textboxes in the detail rows. 3. Drag a list control into your report body, then right-click the list ->Properties->Edit details group… 4. Select Item datafield in the expression 5. Click Ok 6. In list property diagram box, click the checkbox of Insert a pagebreak after this list. 7. Click OK 8. Drag your original table control into this list. Preview the report, you will see one table which contains the information Item/Date/User/Office Location/Dept on one page. Thanks, Challen Fu

Hi Challen Fu, Thank you for your reply. I followed your directions to create a list with a table inside the list. However, I require TWO tables to be displayed on one page. Each table contains data from a row from ONE dataset. So each page will display two tables: Page 1, Table 1 data = row 1 Page 1, Table 2 data = row 2 ---- new page ---- Page 2, Table 1 data = row 3 Page 2, Table 2 data = row 4 and so on. The "tables" in the illustration above are described in my previous post. I tried placing two tables into the list you described above, but the page breaking did not work correctly. I also tried two separate lists, but the grouping did not work correctly either. I also tried two lists inside a large third list that fills the entire page, but wasn't sure what grouping was needed for this large third list. Any other suggestions? Thanks again.

Don't mean to bump my thread repeatedly, but does anyone have any suggestions for my issue?

Hi Psx790, Sorry for the delay, we could achieve this in both SSRS2005 and SSRS2008, firstly, remove the checkbox of Insert a pagebreak after this list in my first reply, then add a second list to your report, add a group to this list as the steps in the first reply, type =Ceiling(rownumber(nothing)/2) in the group expression->select the checkbox of Page break at end->click ok Then put the first list into the second list, I think you will get two tables per page. Actually, you could also utilize the textboxes to display your information besides the table control, maybe textboxes will be better to control the layout. If you have any question about the steps or any concern, please feel free to ask. Thanks, Challen Fu

Hi Challen Fu, Thank you very much! That fix worked perfectly.

Hi Challen, I am making fetchxml based report for crm on-premise, report run fine in BIDS but when it uploaded on server it not run due to query time out. I have to incerase query timeout. How? I tried many ways like webconfig but nothing working? My report has more then 50 dataset. Any Suggestion !!