ASP.NET 3.5 Enterprise Application Development with Visual Studio® 2008: Problem - Design - Solution

9.2. Design

You have plenty of options when it comes to reporting and all of them are perfectly feasible as long as they accomplish the business need and do not hinder performance. One of the requests for the Paid Time Off application is for a report that displays the list of users and the capabilities associated with a role. This is a great report for an auditor.

Here are the requirements for the Role report:

• The company name must be at the top of each page of the report.

• The report must list each capability associated with a role and state the type of access (either Read Only or Edit). Access types of None should be hidden.

• The report must list each user associated with the role.

• The report must print each role on a separate page.

• Each page of the report must display the date and time the report was printed.

• Each page of the report must display the current page number and the total number of pages.

Figure 9-1 shows a screen shot of the report.

Figure 9.1. Figure 9-1

To create this report using Crystal Reports, follow these steps:

1. Add a new folder to the PaidTimeOffUI project and call it "Reports."

2. Right-click on this folder and select Add New Item.

3. Choose Crystal Reports from the dialog, name the file Roles.rpt, and then click the Add button. This adds the file to the project and then brings up the Crystal Reports Gallery dialog, shown in Figure 9-2.

Figure 9.2. Figure 9-2

Choose ...