Recent content by jayster7

TB & Synapse, YOU BOTH ROCK!!! Thanks! I passed that along to the DBA and it did the trick ! Thanks! [peace] The path up and down is one and the same. -Heraclitus

Hi, Using CR10 w/ CE10 using Oracle 9i. I have a set of reports published on CE using a database that lives on the same box as the CMS. So for my reports that use this, the 'Process' tab shows the server name as CMS and in this case the user name is warehouse. These reports run splendidly...

Thanks LB I will give it a try! The path up and down is one and the same. -Heraclitus

The report structure is all report footers RF-a through RF-am. The report gets broken into 9 pages with some sections being conditionally suppressed. In the first section, RF-a, there is a product summary of services and here the online services and case services should be combined and...

Thanks lbass! What I'm trying to do is take calculated from each table (online services and cases) and create shared variables of those to be used later on down the report (report is a series of report footers broken into pages). I could actually use the online services report in a sub-report...

Hi guru's HELP! Working a report with 2 types of utilization data, online services and case data. Key fields in each table are a client number which is joined to a third organization table containing client info. I have a couple of parameter fields to pass in the client number value and...

Hi Synapse, In Crystal Enterprise, through the CMC on the Process tab, I set parameters manually. It is actually happening in all export types. I tried Excel and Word also, but still no data, just a blank report, but again, using the CR Viewer, there is data and I can export to wherever I...

Hi, Working with CR 10 Developer off of an Oracle 9i DB. I have a simple report loaded on CE10 and when I preview it, the data is there and I can print it or export to wherever I choose, but when I try and schedule it to export toa directory as a .pdf I get indication that the run was a...

Thanks ShortyA! I've gone to APOS' site and have downloaded an eval copy of the software. Tomorrow I'm giving my boss a quick brief on it, and hopefully it'll be a go. The path up and down is one and the same. -Heraclitus

Hi, Using CE10 (Solaris version) running CR10 reports via native Oracle connection. We have a report that is run against all of my company's clients on a quarterly basis, which is about 1,400 reports, give or take. Is there anyway to schedule the report to run each client's report rather than...

Thanks Turkbear, but that doesn't seem to be it. The name 'Carolinas' does exist in the Division->emrdivname field. The corresponding emrdivno in both files is '006'. I've put the Case->emrdivno field onto the report just for audit purposes and the '006' shows for the Case->emrdivno, but the...

Hi, using CR10 with an ODBC connection to an Advantage server to access a Clipper database (dbf tables). I have a Case table containing employer number (emrno) and employer division number, (emrdivno) and a Employer Division table containing the emrno, the emrdivno and then also the employer...

Wichita, you are the man!! It's working... THANK YOU!!! The path up and down is one and the same. -Heraclitus

Wichita, that's exactly it! I was playing with the subreports in the report header, or in the Group headers or footer, but I wasn't thinking of the detail. Thanks I'll let you know what happens! The path up and down is one and the same. -Heraclitus

Hey Wichita, Here's a sample of some output. Mind you the report is simply calculating on different types of counts on the same table, but in different groups, one group which is called 'Referral Source' takes codes in the table based on the type of contact that initiated the transaction so...