query help

[OCM]

Given the following:

Enrollment Term: 2010, 2011, 2012 etc.
Enrollment Status: New, Active etc
Student Standing: good, outstanding etc. (some sutdents might have blank for ‘Student Standing’ but I’m only interested the ones with value entered (good, outstanding etc.)

I’m trying to identify

1. How many of these 2012 students are enrolled also for 2013
(This is true when ‘Enrollment Term’ = 2012 and ‘Status’ = New)

2. What is their 'Student Standing' for 2012
(‘Enrollment Term’ = 2012 and ‘Student Standing’)

What would be the best way to achieve this, single query, sub query etc.?


TIA,


OCM

 

[CoSpringsGuy]

in record selection expert enter a formula similar to:
{Enrollment Term} = 2012 and {Status} = New
Use your own db fields of course ...
that should bring back the records you want to evaluate...
I would then group on {student Standing}
add {student} to your details section
right click and insert a count summary in the group footer and in the report footer
hide details

that should get you started anyway

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection