Print

Print


Crystal Reports

Hi,

We are using BB 6.3. Just wanted ask if anyone has used Crystal Reports v11 for stats and if they found the info useful/reliable?

I have queried the bb6 database, using the fields in the following tables:

Course_Roles

Users

In the USERS table, I have used the field Last_Login_date

In order to get the number of students who logged in between Aug_06 and Aug_07

The query results in multiple entries i.e. same userID at the same moment in time and date, so I have to do a DISTINCT COUNT.

Why should I get multiple entries? Does this have any significance e.g. number of courses the student accessed?

Any advise welcome.

Najib Maan

TVU Online (Blackboard) Administrator

Learning Resource Centre

Slough Campus

01753 697832 (8057832)

[log in to unmask]

[log in to unmask]