Post reply

build report from two different data sources (SSAS and SQL) in report builder

  • December 8, 2016 at 4:13 am

    #319611

    I have to build report from two different data sources (one SSAS and one is SQL) in report builder 3.0.

    eg:

    Dataset1 - Data in SSAS

    col1 - col2

    1 - One

    2 - Two

    Dataset2 - Data in SQL

    col1 - col2

    1 - ABC

    1 - DEF

    2 - GHI

    Output required in report is

    1 - One - ABC

    1 - One - DEF

    2 - Two - GHI

    I have tried with Lookup but it is showing #Error :hehe:.

    If I am taking from same Data Source with two dataset its working fine using lookup.

    Can anyone help me.

    Thanks in Advance 🙂

  • December 9, 2016 at 2:57 am

    #1916990

    Analysis Services returns it's values as text even if it's a number. You usually wont notice as it gets implicitly converted during most operations - however not in a Lookup.

    Try converting your lookup value to a string e.g.

    =Lookup(CStr(Fields!Col1.Value), Fields!Col1.Value, Fields!Col2.Value, "DataSet2")

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

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