adding data to a table region from multiple datasets how
hai, i have a scenario to add data from mutiple data sets to a single table region example i have did in two tables separatlely want to add to a single table region can anyboy find the solution
May 15th, 2012 2:11pm

If you are using SQL 2008 R2 or later, you can use the new lookup function. They can be very helpful. This allows you to 'link' two data sets in the same table. The only other way i can think of is to somehow combine your two datasets into one (union the two sets together in your sql statement). Then you only end up with a single dataset. I believe those are your two options.
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 2:28pm

hai BI Baracus , i have two datasets in a report for example in dataset 1: empname, gender, did, sal in dataset 2: did, phone , hod,dept i want a report as empname , sal , gender , dept , hod in tabular format
May 15th, 2012 2:39pm

Hi mohmad sharief shaik, Generally, RS doesn't support merging datasets at the report level. Possible workarounds include: 1. Don't merge datasets but use two table regions. 2. Assuming both queries connect to the same database, use an UNION query. 3. Use a subreport. 4. Create a wrapper stored procedure that merges the datasets. 5. Write a custom data processing extension that prepares the report data. Thanks, LolaPlease remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 2:22am

You can do this using the new SSRS Lookup function. This is available in SQL 2008R2 or Later. Your equation would look something like this. =Lookup(Fields!did.Value, Fields!did.Value, Fields!hod.Value, "dataset2")
May 16th, 2012 1:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics