Zero Record Question 1

[crzycrystlgrl]

ok....CR 9, SQL server, ODBC

So I am trying to include records which have no return...

example: so if I had three doctors i was looking to track referrals on- and 2 of the 3 referred patients - I would still want to see the 3rd doc....which doesn't show up on the report -as there were on records for that doctor...does anyone have a formula to have that 3rd doc show up?

shown in CR

Doc 1 5 referrals
Doc 2 6 Referrals

Want it to look
Doc 1 5 referrals
Doc 2 6 Referrals
Doc 3 0 Referrals

Thanks in advance
-C

 

[kskid]

Do you have a table of physicians with a physician_id. If so, add the table and left outer join the referral table to it.

{Physician.physian_id} -> Left Outer Join -> {referrals.physian_id}

Group on physian_ID and insert a summary count of referal ID. That should yied what you need.

-LW