• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Recipe 6. Time Cards > Administrator Recipe: View Time Cards

Administrator Recipe: View Time Cards

Up to this point, our application overviews have been project-oriented. With the report_projectsummary page, you can get a bird’s-eye view of all the available projects. The report_hoursbreakdown page offers a more detailed view of the time cards for a specified project. In this recipe, we’ll build a page that shows all the time cards logged for all the projects, grouped by employee and displayed in daily, weekly, and monthly views.

Because we are using three different views of the same basic data, the construction of this page will be a bit repetitive. We’ll need three recordsets to bind data into three different content tables. When that is done, we’ll have to apply three Repeat Region server behaviors. It’s important to realize that all the calculations needed for these three different summaries—daily, weekly, and monthly—are all handled through their corresponding SQL queries executed in the data source. Each of the queries are, as noted at the start of this chapter, based on another SQL query, HoursBreakdown.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint