use two different datasets in single report

Question

I have two different-2 datasets with different fileds which are getting populated through two stored procedures with same input parameters.each datsets have different colums and no of columns around 180,my concern is how will i use these two different datsets in single report with two differents fields(two differnt tables).for one dataset i have used report wizard,but not able to figure out for the second dataset.Please suggest for the same..

Tawanda

Answer 1

You can use two different datasets in different reports regions on one Report. For example, If you have two datasets, lets say DS1 showing EmployeeDetail and DS2 showing SalesInfo. You can use them separately in two tables one showing Employees Details and other showing Sales Info. If you plan to merge this data and use it in one table, These are option.

1. Recommended option : Re-write your query to create single dataset containing possible data you want to show in tabular fashion.

2. Would work but would be lot slower : Use DS1 in a table in Main Report where each row contains Epmloyee Detail, Wihtin that Row call a Sub-Report passing EmployeeDetail's key which is related to a column in SalesInfo. Create sub-report showing SaledInfo data, call this report in main report passing key value from DS1 to this sub-report.

Seaboard

Answer 2

Specify data set name in third column Example:

=First(Fields!fieldname.Value,"DataSet1")

Rhodie

Answer 3

Using two different or multiple datasets in a report is not a problem at all, as long as they do not belong to the same data region (charts, tables, etc.)

• In addition to Ron's answer, if you are looking to get data from different datasets in one data region, you could also use Lookup or LookupSet in the field expressions.
• Additionally, you may also create one dataset and filter out some data from it in data regions. For example, if you have one big dataset of all employees, and you would like to display all employees that joined in the year 2012 in a table, you could filter out the dataset using Filter properties of table.

Mozarab

Answer 4

You can simply add multiple table in your report , and change datasetName from tablix properties for each of your table .

you will also need binding source to fill that dataset .

this.invoiceTableAdapter.Fill(this.ARQutationDataSet.invoice);

Kg

question has nothing to do with report viewer control – Abert