Home Forums Article Discussions Article Discussions by Author Discuss content posted by Martin Cremer Reporting Services: Read Data from SSAS and SQL Server in One Dataset RE: Reporting Services: Read Data from SSAS and SQL Server in One Dataset

  • November 19, 2011 at 7:40 am

    #1410307

    Martin Cremer (11/19/2011)

    Rick,

    Maybe I get your question wrong, but wouldn't it help to do a left join to the last query, so it would return the results of the first two queries even if there are no results of the third query?

    Hope this helps

    Martin

    It would be great if a left join would work, but because the field doesn't exist (the [DealerInformation].[Organisation ID].[Organisation ID].[MEMBER_CAPTION]) it still errors.