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)
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)
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)
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
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 - - - >
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 - - - - >
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 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: