is it possible to create a Master Details Report?

is it possible to create a Master Details Report?

• Advait Supnekar

  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

  
  
  

• TommieJ

  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.

  
  

• matt humes

  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.

  
  
• is it possible to create a Master Details Report?