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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Possible to add in column from another data...

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

Rate Topic

Display Mode

Topic Options

Author

Message

10e5x

Posted Monday, January 14, 2013 10:52 PM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, February 02, 2013 11:09 AM
Points: 97, Visits: 180

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

Post #1407029

anthony.green

Posted Tuesday, January 15, 2013 2:00 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407089

mmartin1

Posted Monday, March 18, 2013 10:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 193, Visits: 642

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

Post #1432267

« Prev Topic | Next Topic »

Permissions