Drill down report

• lalit-450914

  SSC-Addicted

  Points: 462

  More actions

  June 11, 2007 at 10:03 pm

  #196280

   HI,

   

  I have the following tables :

  School - SchoolID(int), SchoolName(nvarchar)

  Class - ClassID(int), ClassName(varchar), SchoolID

  Section - SectionID(int), SectionName(nvarchar),ClassID

  Student - StudentID(int), SectionID, Age(smallint), Sex(nchar(1)), DateOfJoining(datetime)

  I want to create a drill down report that shows School/Class/Section wise student enrollments.

  Please guide.

  Thanks.

• David McFarland

  SSChampion

  Points: 11815

  More actions

  June 12, 2007 at 12:03 am

  #712175

  Sounds like homework.

  Post what you have coded so far to generate the dataset, and we can help you from there.