Report Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this report. I need some help. It lists the Company, the Client
Company, and the product the Client has from the Company. The problem is
this...

Cornerstone Health Care only has AIC...MIT Medical only has TouchWorks...the
problem is that it is printing a detail line for each product. I think my
join to my Company Product Table is messed up but I can't figure out why
because the join type is defined as "Only include rows where the joined
fields from both tables are equal."

Any help would be GREATLY appreciated.

Thanks!

Company Name Company Client Name lngzProductIDCompany
Product Name

Allscripts Healthcare Cornerstone Health Care 1AIC
Solutions
Allscripts Healthcare Cornerstone Health Care
1Allscripts Direct
Solutions
Allscripts Healthcare Cornerstone Health Care
1Physicians Interactive
Solutions

Allscripts Healthcare Cornerstone Health Care
1TouchScript
Solutions
Allscripts Healthcare Cornerstone Health Care 1TouchWorks
Solutions
Allscripts Healthcare MIT Medical 5AIC
Solutions
Allscripts Healthcare MIT Medical
5Allscripts Direct
Solutions
Allscripts Healthcare MIT Medical
5Physicians Interactive
Solutions

Allscripts Healthcare MIT Medical
5TouchScript
Solutions
Allscripts Healthcare MIT Medical 5TouchWorks
Solutions
Allscripts Healthcare Central Utah 5AIC
Solutions Multi-Specialty Clinic
Allscripts Healthcare Central Utah
5Allscripts Direct
Solutions Multi-Specialty Clinic
Allscripts Healthcare Central Utah
5Physicians Interactive
Solutions Multi-Specialty Clinic
Allscripts Healthcare Central Utah
5TouchScript
Solutions Multi-Specialty Clinic
Allscripts Healthcare Central Utah 5TouchWorks
Solutions Multi-Specialty Clinic
 
I couldn't understand what your listing was supposed to be telling me.

You mentioned a join/query. Can you provide your SQL statement?
 
Back
Top