Reports Developer 2000 question

From: Cynthia Langevin <clangevin_at_tcipro.com>
Date: 1998/06/10
Message-ID: <EuCozy.5p6_at_iglou.com>#1/1

Hello,

[Quoted] [Quoted] I have a question regarding report development. I hope to receive answers as it is most important to me.

The question regards the following report:

Header:                Physician Status

Run Date and Time:
User Id:
Page Number of Total Pages
Company, Facility or Team Name

Body:

Physician Name/Degree        Status
Joe Doe, MD                      FT  (full-time)
John Smith, MD                 PT  (part-time)
Cynthia Lang, MD              PRN (part-time as needed)

ordered by physician id

Total Number of Physicians: xxxx
Total FT: xx
Total PT: xx
Total PRN: xx

The question is how do you calculate the summaries for the individual status'? There is a function created that creates the total for Phy_id, but I am not sure how to do the other individual total counts for the 3 different status.

The other question is regarding the physician privileges have to be active for the date that the report is run on. There is a phy_privileges table that has privilege_status in it and if it is not active, they are not supposed to appear on the report. The report can be run for individual company, team or facility or for all companies, facilities or teams. Would you check the systemdate against the start_date for the physician privilege and how would you do that?

Thanks so much for your help in trying to assist me. You can respond directly to me at clangevin_at_tcipro.com or I will check the newsgroup daily.

Cynthia Received on Wed Jun 10 1998 - 00:00:00 CEST