I need to modify an existing SQL Server report which already contains SQL with multiple table. The user has requested adding another table which will have multiple rows or values displayed based on a value in the current SQL. This not a problem exept the user wants the new multiple rows diplayed left to right in columns. How would this be done. Would I use a recursive query?

Hi, Tom A matrix can be used to pivot a group of column values across multiple rows in the result set to a column in the report. If I'm understanding, you will need to add the additional table to the dataset query using a join and then add the appropriate columns in the SELECT list. With the additional rows returned from the query and the new column return as a new field in the results, you can place the field into a column group in the matrix. Although I think I understand your question on the surface, your question is pretty high level and it will help to deal with specifics. Can you provide your query, list of fields and describe your report design? We'll need enough detail to understand the design of your report and the new requirement. Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*