Skip to Content
0
Former Member
Jun 02, 2011 at 12:57 PM

How get my report design working?

52 Views

I have a report card report that i need to get working. I have the school name , address , and students name and report card information at top correct but the classes are not displaying correctly.

I will post the sql query here but if you need to see my report i can post a picture.

Sql query:

SELECT dbo.Course.number, dbo.Course.name, dbo.Calendar.endYear, dbo.Calendar.startDate, dbo.Calendar.endDate

FROM dbo.Calendar INNER JOIN

dbo.Course ON dbo.Calendar.calendarID = dbo.Course.calendarID

WHERE year(getdate()) BETWEEN year(dbo.Calendar.startDate) AND year(dbo.Calendar.endDate)

My objective is to get classes from a specific school year to show up for a specific student. The students courses and the calendar year are in different tables though. For instance, for john willy i want his 2010 -2011 classes to show up.