I have an assignment in which I am to prepare a report displayed in excel to return counts of various attributes in the database. However, the count is a bit
challenging because it requires counting certain attributes in a pivot format illustrated below.
The counts for each category by recruiter, rolled up by Division, within the specified time frame.
The tables that I would have to deal with are as follows:
User: Has the number of Accounts…user accounts with no Recruiter are unassigned
Recruiter: Has the recruiter information
LoginHistory: Has a record of all logins
EForm: Has the various forms, for example: Release and Authorization, Provider Service Agreement
EFormUserXref: You can filter it to return the Physican AppForms
View Complete Post