Lesson 3e: Building a Report Details page

Now that you have the pieces that allow the user to both view and schedule reports, you can compile the Report Details page. The Report Details page was first discussed in the section, Report Details page, and provides the following functionality:

• a link back to the folder view
• the name of the report, together with a thumbnail displaying its first page, as well as its description
• the list of instances that were run off this report (links that open the instance in the viewer)
• a link to a page that will display the entire report
• a link to a page that will allow the user to rename the report
• a link to a page that will allow the user to schedule the report.

One thing to note about the Report Details page is the listing of instances. Instances are owned by a report in the same way that reports are owned by folders. To retrieve all the instances of a report, the SELECT statement selects all instances (for example, SI_INSTANCE = 1) where the parent (SI_PARENTID) is equal to the report ID. This is very similar to the method used to retrieve the reports themselves. You can see this for yourself by viewing the following page, ReportDescription.csp

End of lesson

You should now have a clear understanding of how to build a web application that allows users to do the following: navigate through folders and search for, view, schedule, and rename reports.