Possible to add in column from another data source in the same report?

  • Hi all,

    A burning qns. Currently my report displays 7 column from a datasource A. Is it possible to add the 8th column to the same report from another datasourceB?

    Got an idea to improve my report but stuck at this issue. The 8th column will help user to view report with better understanding

  • yes as long as DataA and DataB have a joining column, then you just need to use the lookup function to pull the right column from DataB where it matches the joning column in DataA

  • The lookup function is not available in SSRS 2005. Wondering if the OP still has this issue.

    ----------------------------------------------------

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

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