Post reply

SSRS 2005: Two Datasets to align horizontally

  • 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 2 posts - 1 through 3 (of 3 total)

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