Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yvonneNZ
Starting Member
2 Posts |
 Posted - 2009-05-05 : 19:53:44
|
| I need to chart and report student counts where student is male or female, part time fulltime, and many other parameters around items selected in an enrolment formI can either create the counts in SQL or in reporting services, and as this is a large database I would prefer the quickest optionThere is one enrolment table holding all the statistical data I need to report on |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-06 : 01:59:04
|
Do all the counting math in DB. That's what the DB is build for.Let the report present the result.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Countif() equivelent Reporting Services or SQL