Workshop

The quiz questions and activities are provided for your further understanding of the current hour's topics.

Quiz

1:

What is the difference between the COM Data Source driver and a COM Data Provider?

A1:

The COM Data Source driver is the Crystal Reports Data Source driver that contains the mechanism for consuming COM Data Providers. A COM Data Provider is a COM Object written by a developer that performs some sort of data access and returns data back to Crystal Reports.

2:

What does a function in a COM Data Provider need to return in order to be used inside Crystal Reports?

A2:

A function inside a COM Data Provider needs to return an ADO recordset in order to be used inside Crystal Reports.

3:

How do you identify your Java class as a Java Data Provider?

A3:

To identify your class as a Java Data Provider, copy the file into a given directory, and then add an entry into the registry key discussed in this hour that contains the folder where you put the Java class files.

Activities

To ensure that you are comfortable with the topics discussed in this hour, try to perform the following tasks:

  1. Create a COM Data Provider in Visual Basic that returns customer data from the Xtreme Sample Database. The Provider should have a parameter that filters the customers by region.

  2. Create a Java Data Provider that makes a JDBC connection to an XML file and returns that data to Crystal Reports.

  3. Create a COM Data Provider that runs a basic query against the Orders table from the Xtreme Sample Database. Loop through the ADO Recordset and remove the Customer ID value for all orders over $1000.



Sams Teach Yourself Crystal Reports 9 in 24 Hours
Sams Teach Yourself Crystal Reports 9 in 24 Hours
ISBN: B003D7JUVW
EAN: N/A
Year: 2005
Pages: 230

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net