Master Detail Report:
There are more than one query in a single report.
On this report, first query(Master) drives the data in second query(detail).
Excercise: Get the cumulated sales data in a list and then display a yearly graph each for every country.
Steps for Creating a master detail report:
1- Create a list report.
2- Drag Country, Sales Amount and Sales Qty.
3- From the toolbox, drag a chart and drop it in the list.
4- Drag and drop Country, Year, Sales Amount and Sales Qty.
5- Click on the chart; from the Data menu, click on master detail relationship
6- Create the link between the Two queries on Country...
Lets do it......
Post a Comment