In the previous chapter, we created a
SalesDetails report, which shows the Product Name, Unit Price, Sales Quantity, Total, and Grand Total of Sales No : 1 (One). This report shows the data of only Sales No. 1. So what will we do if we want to see the details of Sales No. 2, or 3, or others? Of course, we will not develop reports for each Sales No. because thousands of Sales Nos. will be generated. We will use a technique where we will develop only one report, which will work for any Sales No. In the
SalesDetails report of Chapter 4, Using Variables, we hardcoded the
SalesNo in the SQL commands. That's why it works only for Sales No. 1. In this chapter, we will use parameters instead of hardcoded data in the report. ...