Thanks so much for the add'l recommendation synapsevampire.
The report had a parameter for provider, and coding all those different plans was getting to be a bit much. The cross tab filled the bill and I really appreciate the feedback.
Keep up the good work. This site is a lifesaver!
Using CR 8.5, oracle db.
Have a report which groups on siteid, then plan. I take the total number of plans times the cost and come up with a total Results look like:
Site ID: 11F4dC01
plan name Cost Cnt Total
Plan A $4.99 1 $4.99
Plan B $14.99 7 $104.93
Plan C...
I'm using ODBC connections to two different oracle databases with Crystal 8.5.
I've got a main report that provides data on invoice amounts, tax amts, etc. I have a sub report that pulls site data from another database. While I'm linking the sub report to the main report on the account...
Background: using Crystal Reports 8.5, two different databases, both oracle. (warning, I'm not a programmer, so formulas do not come easily to me :-))
I'm trying to link a subreport to the main report via a field called "provider". The problem is the main report uses one data source...
I've been trying to solve this problem looking through the forums and I'm just not getting it. Any help greatly appreciated.
I'm trying to get all "deals" even if they haven't been purchased (Deal left outer join to event_last_deal_purchase)
I believe that when service.service_type...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.