how to perform a distinct count on a record over 2 sub reports
hi all, i have a report returning list where it is grouped by city. it contains fields: ID (each record has unique id), serial(each client will have a serial to idenfy a person) group1 (A<B<C<D) and group2(A<B<C<D) and group date each client can have multiple entries based on how many times they have visited a centre [...]

Answer Question   |  February 28, 2012  12:50 PM
Crystal Report XI, Distinct Records

SQL query to select highest test score
I am writing a sql to bring someone’s highest test score into a table. The sql is bringing in the highest test score possible, rather than the person’s test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What [...]

Answer Question   |  November 21, 2008  11:42 PM
Distinct Records, MAX, SQL, SQL Query, SQL tables