SQL Queries and Reports

Preacha

Registered User.
Local time
Tomorrow, 00:18
Joined
Jul 3, 2004
Messages
34
I have this database here (http://www.cs.newcastle.edu.au/~c3003364/TrafficCounterDatabaseBETA.zip) I want to create 5 different types of reports

I want create a report on "Hourly volume" which will look like this . . . ..
On the top of the report should be Site and Direction (from the headers table)
Code:
Hour  Date --->    Weekday Avge All day Avg
|      X X X X              |                      |
|      X X X X              |                      |
|      X X X X              \/                     \/
\/
Total - - - >
Where X is the Total Classifications

I similiarly want "hourly mean speed" and "hour 85th percentile speed" in the form as above

I want "Hourly Class"
Which will look like
On the top of the report should be Site and Direction (from the headers table)

Code:
Date    Hour   Classification ---->
|          |       X X X
|          |       X X X
\/         \/
Total   - - - - >
Where X is the classification totals (as above)

And finally I want a report with "Hourly class by day"

On the top of the report should be Site and Direction (from the headers table)

Code:
    Day,Date

             Classification ----->    Weekday average    All day average
             Hour                                |                       | 
              |       X X X                     |                       |
              |       X X X                    \/                      \/
              |       X X X
              \/
            Total - - -- >
I mainly concerned about getting the "Totals" at the bottom of each column in the report, like a subtotal for that classification or that date or whatever.
I also have put in some TBL files, can somebody tell me a better way to import these files? Because they take forever Thank you. I read in another post that you can use the excel function instead of the functoin I got in there but it seems to work ok. Btw the reports should come from the SpeedImport table. (I think)
Thanks
 
Last edited:

Users who are viewing this thread

Back
Top Bottom