Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Creating a statistics report with JSP

Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everyone. I have a question which will take a bit of explaining so please bear with me.
I am creating a Help Desk call tracker web based application for my company and something has me stumped. What I am trying to do is to create a means of collecting the number of calls per day for each caller, remote location, date and so on.
I want to be able to sum the number of calls for each day and generate a report showing the top ten callers and dates with the most calls.
I would classify myself as a novice when it comes to java so I am unable to work something out for tackling this problem.
The calls are stored as tickets in a database with fields for Callers, IT Systems, Locations and dates reported, among others.
Can anyone suggest some documentation or tutorials which could shed some light on this issue? I've been unable to find anything reliable on line and all the books I have read through cover pretty basic stuff. I would appreciate any help you can give. Thanks.
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Tony:
One solution could be.
1. Have a column in the table that stores the number of times a user accessess the help desk
2. Every time the user uses the system, increment the count by 1
3. When ever you want to generate a report, use a SQL statement
SELECT * FROM CallHistory
4. You can take the first 10 entries of the returned rowset
Hope this works.
The problems of the world fade way as you eat a piece of pie. This tiny ad has never known problems:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic