So let's start creating our report:
The SQL query that we will use in our report is shown in the following screenshot:
We will create a new TableAdapter using this SQL query and name it
ProductsOrdersTableAdapter, as seen in the following screenshot:
Add a new crystal report to our application and name it
crProductsOrders. As we see in the following screenshot, we can create our report by selecting the Using the Report Wizard option and then choosing Cross-Tab as an Expert, or we can select As a Blank Report and we will add the Cross-Tab from the report itself. We will take the second option to see how we can add or modify our Cross-Tab at any time after creating the report, so we will choose As a Blank Report as shown in the following screenshot:
Right-click on Database Fields in Field Explorer and select Database Expert, and then a window appears, as shown in the following screenshot. As shown below, we will choose our TableAdapter ProductsOrders as a data source:
Right...