is it possible to create a Master Details Report?

is it possible to create a sort iof Master Details Report?

mean one dataset returning the master data while the other dataiset returns the details

and then relate this two datasets on a common key and show the report .

You can use drillthrough or subreports to do this. The dataset in the main report would return the master data, which is displayed in the main report. In the drillthrough link or subreport, you can then pass the key through parameters.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_interactive_v1_38tn.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp

|||

hi thanks for your reply, i understand that we can do this using drill down reports, what i want to know is is it possible that in a same report i.e. RDL file can i have master and detail datasets and relate this two and report them in a table.

Example:

MasterDataset has following records

EmpNo. FirstName Last Name.

1 john Smith

2 Tom Knight

DetailsDataSet

EmpNo. DepNo DeptName

1 1 prodcution

1 2 Accounts

2 1 production

2 2 Accounts

I want this two datsets to be related on empno and then display them on the table, such that each employees is shown on a new page, with its department details.

Thanks.

|||

You would really be better off creating a subreport with the details. Then link the master report to the subreport based on a paramater. Then you can put a pagebreak at the end of the first report, thereby putting the details on the next page.

So, you'll have two .rdl files but the user will only see one report.