Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jayster7

    Oracle DB's on different boxes a problem!

    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
  2. jayster7

    Oracle DB's on different boxes a problem!

    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...
  3. jayster7

    Vanishing data in CR 10/Oracle 9i back-end (Maybe join problem?)

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

    Vanishing data in CR 10/Oracle 9i back-end (Maybe join problem?)

    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...
  5. jayster7

    Vanishing data in CR 10/Oracle 9i back-end (Maybe join problem?)

    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...
  6. jayster7

    Vanishing data in CR 10/Oracle 9i back-end (Maybe join problem?)

    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...
  7. jayster7

    NO DATA BEING EXPORTED WITH REPORTS

    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...
  8. jayster7

    NO DATA BEING EXPORTED WITH REPORTS

    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...
  9. jayster7

    Scheduling same report for multiple clients

    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
  10. jayster7

    Scheduling same report for multiple clients

    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...
  11. jayster7

    Two table join problem

    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...
  12. jayster7

    Two table join problem

    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...
  13. jayster7

    Multiple pages with separate subreports?

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

    Multiple pages with separate subreports?

    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
  15. jayster7

    Multiple pages with separate subreports?

    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...
  16. jayster7

    Multiple pages with separate subreports?

    Hi I was looking through the forums and found a posting for Crystal reports 8.5 How to print different text on bottom of each copy I have similar issue. I am using CR10 in Windows currently accessing .dbf files via ODBC, which will change to an Oracle 9i database in 2005. My firm offers...
  17. jayster7

    Print margin problems from web browser

    Hi, Using CR 10 to develop form letters with standard margins for letters (8 1/2 by 11 paper). The CR 10 objects are being deployed in BEA WebLogic 8.1 Server, using an Oracle 9i database on the back end. The letters will display fine in a browser when selected, but when printing appear to...
  18. jayster7

    Receiving 'CANNOT FIND TABLE ERROR'

    Synapse, You've done it again! I was connecting using Oracle's driver. I went to Business Objects and got their Crystal Reports 10 drivers supplied by DataDirect and I installed the Oracle driver and it all appears resolved. Thanks again. You're kung-fu is the best! :) The path up and...
  19. jayster7

    Receiving 'CANNOT FIND TABLE ERROR'

    Hi, Using CR 10 accessing an Oracle 9i database. Using 3 tables , PROVIDER, PROVIDER_CONTACT_INF_LKUP, and CONTACT. The PROVIDER...LKUP table has the PROVIDER_ID field as an FK from the PROVIDER table and also the CONTACT_PERSON_ID as an FK to the CONTACT table which contains address info for...
  20. jayster7

    Parameter/Formula Question

    Synapse, apologies for not giving the tech specs. I used the range values that you specifed and it worked like a charm using "yyyy"! Using CR10 accessing .dbf tables from a medical provider database, but it gave exactly what I was looking for, provider records, where their credentialing was 2...

Part and Inventory Search

Back
Top