I have a view that displays a list of notes that have not been signed by a doctor.  Some doctors have signed all their notes and do not appear in this view.  I am using Crystal reports 11 and filtering the view by date.  I have imported a list of values for doctors, so that ALL doctors, not just those with unsigned notes, are readily available to select for the report.

What is happening currently, is if I select a doctor who has unsigned notes, the report will display all his unsigned notes on a page.  However, if I select a doctor who has no unsigned notes, he doesn't get a page in the report.  What I want, is for ALL doctors who I select to have their own page in the report.  If the view yields no unsigned notes for his doctor, then his page should be blank where the unsigned notes information would have gone.

This has been bothering me for weeks.  THANK YOU SO MUCH!

Thanks for the response, but it didn't solve my problem.

I tried using an outer join instead of an inner join and I got the same result:  When I select a doctor who does have unsigned notes, he gets a page showing the results.  good.  the problem is, when i select a doctor who DOES NOT have any unsigned notes (after i did the right join, his name IS in the database), and i run the report, this doctor does not get a page.

i think my issue may have less to do with the query and more to do with an option i have to select.  in other words, i want a print to page for all doctors i select whether or not any unsigned notes were found for this docotor.

I still havent been able to create the report that I need so let me be more descriptive.

I am doing an outer join so that the view has every doctor and every note, unsigned or signed.  unsigned notes have a status <10, and signed notes have a status = 10.

What I want is a report where I select as many doctors as I'd like, and then EVERY doctor that I selected from the list has a page in the report which displays his unsigned note status.  The nsigned note status would be a list of notes if the doctor has any unsigned notes, or a blank section of the doctor doesnt have any unsigned notes.

What the report is doing now is taking my selection and creating a page for every doctor who has unsigned notes (OP_NOTESTATUS < 10) and ignoring those doctors who only have notes with OP_NOTESTATUS = 10!  I feel as though I must be missing something really simple because the option to accomplish what I want could be easily done with a checkbox of some sort.

All I need is a page for every ?Doctor that I select on my list.

DBBlank:  your link was helpful, but my problem isnt quite the same.

Here's a little summary of my report as it stands:

Formula Fields: 
Date Range
cstr( {?StartingDate} ) + " to " + cstr( {?EndingDate} )

Doctor
{vw_DoctorNotes.Doctor}

Record Selection:
{vw_DoctorNotes.Doctor} = {?Doctor} and
({vw_DoctorNotes.ActivityDate}) in {?startingdate} to {?endingdate} and
{vw_DoctorNotes.OP_NOTESTATUS} < 10


Thank you so much!

Left join into your doc table.

Edited by DBlank - 18 Dec 2009 at 2:49pm

It's not that it is not possible, it's just a matter of finding the right way. If you can build a view/stored proc, you can create the dataset in SQL and see the results, then you can set the view/stored proc to be the input for the report making much of this simpler.