Thank you for your reply, Peter. I don't exactly get what you are asking. But, I will explain what the report is doing.
This report pulls the patients who have appointments on a selected date with a selected provider. I have used a SQL Command as the data source.
Parameters are date and provider. Date is a static parameter. Provider is a dynamic parameter. The parameter is a field of the SQL command. When I run the report inside Crystal Reports I am able to see all the providers. But, when I run it inside Centricity EMR, some of the providers are missing.