SSRS DISPLAY DATA IN MULTI COLUMN TABLE
Hi there,
I have a sql query which I have set up in BIDS and am creating a layout with table to display the daat.
I can add columns (upto three )to the table and the data is displayed correctly.
When I add the 4th datafield and on. ie I drag and pull the field to the layout. the data for this 4th field is displayed only in the first row. How do I get to add the 4th row onwards such that all the data is displayed. OH How I DON'T LIKE REPORT FORMATTING ....
I have a sql query which I have set up in BIDS and am creating a layout with table to display the daat.
I can add columns (upto three )to the table and the data is displayed correctly.
When I add the 4th datafield and on. ie I drag and pull the field to the layout. the data for this 4th field is displayed only in the first row. How do I get to add the 4th row onwards such that all the data is displayed. OH How I DON'T LIKE REPORT FORMATTING ....
Which version of SSRS?
I'm guessing 2008, in which case when you drag a field over you should see a thick blue insert indicator.
As you drag it over various parts of the table it will change position.
Make sure it is on the right hand side of the last column.
In 2008, tables became "Tablix" a cross between a table and a matrix and with it came along some unintuitive behaviour which is what I think you are experiencing.
Once you get the hang of it it becomes easier.
I'm guessing 2008, in which case when you drag a field over you should see a thick blue insert indicator.
As you drag it over various parts of the table it will change position.
Make sure it is on the right hand side of the last column.
In 2008, tables became "Tablix" a cross between a table and a matrix and with it came along some unintuitive behaviour which is what I think you are experiencing.
Once you get the hang of it it becomes easier.
ASKER
I have SSRS2005 version.
I think it is somehow placing the tex field correctly. It is very frustrating. Is there any other way to include the text box in a table other than dragging the field.
I think it is somehow placing the tex field correctly. It is very frustrating. Is there any other way to include the text box in a table other than dragging the field.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER