Post reply

SSRS 2005: Two Datasets to align horizontally

  • December 5, 2008 at 3:04 am

    #203788

    Hi,

    I have two tables which provide data from two separate datasets and I would like them to align horizontally. I cannot seem to find anyway to do this. An example is:-

    Table 1

    id Name Age

    1 Tom 21

    2 Ed 33

    3 Jo 23

    Table 2

    Time Score

    17:33 5

    12:21 3

    09:10 9

    I would like the first row in Table 1 to align with the first row in Table 2 and the 2nd row in Table 1 to align with 2nd row in Table 2 etc.

    These are in two separate tables and two separate datasets. How can I align them at the moment they are all over the place even though the tables cells are set to the same size in height and width.

    Any help would be appreciated.

    Thanks in advance.

  • December 5, 2008 at 7:49 am

    #908306

    As far as I know and remember, SSRS doesn't support multiple datasets joining

    so I always join them in the Dataset T-SQL query, so it appears as 1 dataset to SSRS

    You should join the 2 tables first as well, hopefully based on the [id] in both tables

    I don't think Matrix structure helps either

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • December 5, 2008 at 9:13 am

    #908405

    Thanks Jerry,

    I have altered my script to make it one dataset however I still think it is a limitation of reporting services as it should be able to do something such as what I was proposing. But thanks at least I now know that this isn't possible.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply