Notifications
Clear all
Topic starter
I have a referrals report that is perfect except that since it is grouped by BUSINESS_1.SEARCHNAME (which is primary insurance) the patients without primary insurance never show up. In this case the left outer join doesn't seem to help. Is there an easy way to make them appear at the beginning or end of the report somewhere?
Posted : July 31, 2013 11:27 pm
Left-outer joins in Crystal won't work if you use the outer table in your criteria/formulas. If you are just displaying the 'outer' information, however, the join should be OK.
-- the amount of hours wasted on this issue, for something that only takes moments to do in Oracle, Access or MS... If you google this, you'll see lots of items.
Depending upon your situation:
1. You could use a running-total function
2. You could use the Section to suppress excess data, even though the data is still there.
3. You could create variables to pass the information back from a subreport
4. You could create a View with the data you want outside of Crystal
5. You could use the Crystal SQL Command (which nominally is similar to a View although I find it doesn't work quickly)
Posted : August 13, 2013 4:20 am
Topic starter
Thank you, I actually have a Crystal Reports class tomorrow so I will bring your ideas and the report along with me to see if I can figure this out.
Posted : August 13, 2013 4:48 am
Topic starter
By the way, have you ever used Access with Centricity? I have never tried it with Centricity but I do use it for other databases. I use MS Query sometimes for my reports, maybe I can try it in there too if I can't get Crystal to work.
Posted : August 13, 2013 4:54 am
I have used Access for years. I am not good at sql and I like Access better than Crystal. The one issue I had on the Oracle database is when Centrcity went from a 32 bit server to a 64 bit server the normal ODBC connection did not work well since my Access application is a 32 bit application. I had to create a separate ODBC connection to use with Access on the large tables. Jim [email protected]
Posted : August 14, 2013 12:26 am
Topic starter
Thanks! I think I will give Access a try then
Posted : August 14, 2013 1:02 am
