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