[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