So, we will create a basic query to retrieve customer
information, which we will use afterwards to combine with a second Data Set to
have a master/detail type report.
1. Add a Data Set to the report called getCustomerInformation.
2. Use the following query:
select *
from CLASSICMODELS.CUSTOMERS
where CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = ?
3. Create a report parameter called rprmCustomerID and link it to the Data Set.
Data type will be Integer and set the Prompt text as Enter the Customer ID.
Use the Default value of 148 to make developing a little easier so that we can
debug and do not have to enter a value each time.
4. Save the report.
Report Projects and Libraries
[ 168 ]
5. Open the ClassicCarsLibrary.rptlibrary file. Drag the tab for the Library in
the Report Design file so that it is side by side with the Report Design file.
6. In the Outline for the Report Design, right-click on the
getCustomerInformation Data Set and choose Copy.
7. In the Data Sets branch of the Library's Outline, right-click and choose paste.
Chapter 7
[ 169 ]
8. Repeate steps 6 and 7 for rprmCustomerID.
9. Save the Library.
The problem with the above method is that the Data Set and the Report
Parameter are both two separate instances from the Report Design files and
the report Libraries. The way to link them is to delete the instances in the
report and consume them using the steps shown earlier in this chapter.
Pages:
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154