[thelist] creating two-dimensional timetable in ASP/SQLServer
rudy
r937 at interlog.com
Sun Oct 13 15:21:01 CDT 2002
>and in it there is an unknown amount of records, each storing information
>about a class
>for example these records:
>32; bleh; 2; 17:30; 18:30
>45; bleh; 4; 17:00; 18:00
>
>what i need to do is display the records in a table with fixed axes. where
>the vertical axis (Y) is time and horizontal axis (X) is day.
hi elfur
how are you? we missed you around here
the two-dimensional report that you describe is frequently called a
"crosstab" report
if rows are the timeslot dimension (down), and columns are the days
dimension (across), you did not make totally clear what should goes into
the "value" slots -- this is usually a count of occurrences or a sum of
some value
hence most crosstabs are usually based on a GROUP BY query
>this wouldn't be a problem if i didn't have to display the length of the
>class as well.
>
>using the example rows above, i need to mark the Y-axis from 17:30 through
>18:30 on monday (X-axis) and from 17:00 through 18:00 on wednesday.
okay, that's a different take on it
this sounds almost like a gannt chart
what do you mean "mark the y axis"? a blob of colour? a vertical bar?
so, no count or sum of records in that slot, something else?
you know, if you were to produce an html mockup, showing what you want the
result page to look like, that would help a lot
rudy
More information about the thelist
mailing list