Good day. I have ssrs 2008 installed. Lets say i have two sql tables - tableA and tableB. Relation between them is one to many(For each row in tableA can be many rows from tableB). I joined this tables and now want to display result. My report is simple table - first 5 columns is from tableA, and sixth column is a tableS, which is the rows of tableB that response to speciefied row of table A. So i add in that column another table(subtable). In preview mode all works perfect and rendering takes a few seconds. But when i deploy report to server, it's not rendering at all(i have message "Loading...", waited for an hour). If i remove subtable its works. What can be a cause of this problem? Best regards, Chernobrivec

Hi Chernobrivec, Thanks for your question. Based on your description, it seems that tableS is a report table, it displays the Database table tableB’s records, there is another report table, for example, we called it tableM, its first five columns display the result of Database table A, you dragged the tableS into the tableM’s six column, right? If I misunderstand you question, please let me know. Generally speaking, since the tableA and tableB have one to many relation, the easiest way is displaying their joined results in a report table directly, rather than binding the tableB’s results to another report table and dragging it into one column. For example, supposing that tableA and tableB’s structures and records just like this: Using this T-SQL query in the dataset: select * from Dept d left join emp e on d.Deptcode=e.depcod Please bind this data to the report tableM directlly. Hope it helps you, if your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Good day. Thank you for you answer. Yes, your are right about what i want to do. My query looks exactly like yours. But if i just put it in one table i will get something like this: A 001 A 002 So, it would be repeating values in first 5 columns and i dont want that. So i putted another tablix control in sixth column and got A 001 002 It's looks like one table in another. I can't just turn on "Dont display repeating values" cause my real report is more complicated than those, which i described in first post. In real report sixth column has a subtable, which is filtered by some criteria, and there is another four columns, which has subtables in them and different filter criteria. So, its looks like some sort of matrix, where on cross is a table. Adding one table in detail cell of another is a new feature of ssrs 2008, it wasn't available in ssrs 2005. Maybe this could be a problem? Best regards, Chernobrivec.

Hi Chernobrivec, I am sorry for didn’t follow up your question in time due to the unusual alert mail. Based on your last reply, there are two new questions I would like confirm with you: 1. It seems that tableS in the sixth column of the previous tableM, and tableS has four columns, these four columns also contain sub tables? 2. You create the report in SSRS2008 then post it into SSRS2005? Please help me collect these two questions, may be they can help us to find the solution. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.