- see footer for list info -<
Hello.
I am trying to develop a reporting page that shows reports fetched between
two dates.
The idea is to show a graph of visits to schools by LEA senior staff.
I have been reading up on cfchart (mx6.1) and it seems ffairly straight
forward however ....
The database is a sort of calendar which holds school visits.
I want the user to be able to select 2 dates start and end and show a graph
which displays the visitors on the x axis and vists on the y axis.
I think the cfchart needs this data presented correctly to work (I think) so
how do I 'group' the number of visits for each visitor?
I have a query like this ....
<cfquery name="GetEvents" datasource="#application.CalendarDSN#">
SELECT cfpagesSchools.dbo.tblSchools.SchoolName,
cfpagesSchools.dbo.tblSchools.SchoolIDPK,
dbo.tblEvent.EventIDPK,
dbo.tblEvent.SchoolIDFK,
dbo.tblEvent.EventName,
dbo.tblEvent.StartDateTime,
dbo.tblEvent.EndDateTime,
Day(tblEvent.StartDateTime) AS EventStartDay,
Day(tblEvent.EndDateTime) AS EventEndDay,
dbo.tblVisitors.VisitorName
FROM cfpagesSchools.dbo.tblSchools
INNER JOIN dbo.tblEvent ON cfpagesSchools.dbo.tblSchools.SchoolIDPK =
dbo.tblEvent.SchoolIDFK
INNER JOIN dbo.tblVisitors ON dbo.tblEvent.VisitorIDFK =
dbo.tblVisitors.VisitorIDPK
WHERE (tblevent.StartDateTime BETWEEN CONVERT(DATETIME, #StartDate#, 102)AND
CONVERT(DATETIME,#EndDateTime#,102))
ORDER BY StartDateTime
</cfquery>
What do I need to do to get this into cfchart ...?
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
