• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

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 ....
0
SMadhavi
Asked:
SMadhavi
  • 2
  • 2
1 Solution
 
SMadhaviAuthor Commented:
i CAN SEE THAT THE PARENT TAB FOR THE NEWLY ADDED TEXTBOX HAS TO BE TABLE1, i CANNOT CHANGE THAT SETTING. Any idea what I am doing wrong?
0
 
chrismcCommented:
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.
0
 
SMadhaviAuthor Commented:
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.
0
 
chrismcCommented:
OK, 2005 should be easier.
The alternative and easier way in 2005 is to right click a column heading in the table and you will get an option to add a column before  and add a column after the highlighted column.
That creates a blank column and you can then drag the field into the blank cell which in turn uses the field name as the column header.

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now