Making Subreports

Xavier C · Post by **Xavier C** » Tue Mar 31, 2009 3:53 am

Hello i'm trying to make a Report and i want it to look like that

ContactId Name Firstname
4 DUbois THomas

StartC EndC StartS EndS MoneyS
1/1/00 31/12/00 1/1/00 30/6/00 1000
1/1/01 31/12/01 1/7/00 31/12/00 1200
1/1/02 31/12/02 1/1/01 30/6/01 1100
1/1/03 31/12/03 1/7/01 30/12/01 1000
1/1/04 31/12/04 1/1/02 30/6/02 1300
1/1/05 31/12/05

ContactId Name Firstname
5 DUbois Eric

StartC EndC StartS EndS MoneyS
1/1/00 31/12/00 1/1/00 30/6/00 1500
1/1/01 31/12/01 1/7/00 31/12/00 1700
1/1/02 31/12/02 1/1/01 30/6/01 1000
1/1/03 31/12/03 1/7/01 30/12/01 1000
1/1/04 31/12/04 1/1/02 30/6/02 1000
1/1/05 31/12/05

The data cames from 3 different Datasources ( Contact , Contract & Salar ) but they all have The ContactId in common , so i'd like to use it as a link to make my report look like that , is it possible ?

Brendan · Post by **Brendan** » Tue Mar 31, 2009 4:32 am

This looks to be a Master-Detail report.

First you need to create relations between the child datasources and the parent datasource.
You place your master databand onto the report (Contact) and then below it you place the detail databand. So set some properties on the detail databand to connect it to the master databand.

Have a look at these videos to see if it helps you:

How To: Create a Master-Detail Report

How To: Create a Master-Detail Report 2

Also check out some of the Master-Detail samples in the Demo application that comes installed with StimulReports.Net