CODEWITHSUNDEEP
c#asp.netreporting-services
M3ra
M3ra

Reputation: 229

How can i add a field to dataset from another dataset in ssrs?

I want to add a field to dataset from another dataset in ssrs?can anybody help me to solve this?

Thanks in advance!!!

Upvotes: 0

Views: 1904

Answers (2)

Jason Horner
Jason Horner

Reputation: 3690

if you are using SQl Server 2008 R2, you might be able to use the lookup functions to join the data inside of SSRS:

http://blog.datainspirations.com/2010/03/19/sql-server-2008-r2-reporting-services-look-up-look-down-look-all-around-part-i/

otherwise you can use a SSIS package as a datasource to do you any type of join and then have your SSRS report use that. This is a little complex to setup, and not recommended for production; but it can work:

http://msdn.microsoft.com/en-us/library/ms345250(SQL.100).aspx

http://msdn.microsoft.com/en-us/library/ms159215(SQL.100).aspx

Good luck

Upvotes: 1

gbn
gbn

Reputation: 432190

In general, you can't merge datasets in SSRS.

You can explicitly ask for a value in a text box (using FIRST for example with the correct scope) from another dataset.

Upvotes: 0

Related Questions