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!

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

Recent content by cjmartin

  1. cjmartin

    View SQL Command w/out connecting to the database

    I would like to reuse the sql from a previously developed report, but I no longer have the ability to connect to the database from which the report was created. Is anybody aware of a way to view the sql command of a report w/o database connectivity? TIA, Chris
  2. cjmartin

    Calling Report from Oracle Stored procedure

    Oracle9Guy, Can you send that PL/SQL package to me? That may help us with our challenges... Thanks!
  3. cjmartin

    CE8.5: ? about saving instance sched to Excel format

    To clarify my question, I would like to know how the user can save the report instance (scheduled with a format of Excel) upon viewing it. Thanks.
  4. cjmartin

    CE8.5: ? about saving instance sched to Excel format

    Crystal Enterprise 8.5 After scheduling an instance to Excel format, I go in to view the instance. No menu bar is visible that would allow me to save the excel spreadsheet (ie to my local drive). If I make a change to the instance/spreadsheet, it will prompt me and allow me to save the...
  5. cjmartin

    Sending mail of user_jobs query results

    carp, I attempted to use your suggestion, had trouble with it, did some more research, and am now trying to incorporate ideas from a combination of resources (including yourself). Here my attempt... DECLARE CURSOR c1 IS SELECT job, failures, broken, what FROM user_jobs WHERE...
  6. cjmartin

    Sending mail of user_jobs query results

    karluk, Excellent suggestion. I customized the maildemo8i package (found on OTN) to my environment. I'm still stuck on passing the results of query (ie select * from user_jobs where failures = 'Y') to the message or attachment part of a procedure written against the maildemo8i.sql package...
  7. cjmartin

    Sending mail of user_jobs query results

    I am trying to create a procedure that accomplishes the following: 1) Queries USER_JOBS for any broken or failing jobs and 2) emails the query output. I have both the logic for the two separates parts of this, but am having trouble incorporating them. 1)USER_JOBS query: SELECT job...
  8. cjmartin

    use all_tab_columns tables with add'l query

    Thanks sem!!! That's EXACTLY what I was trying to accomplish...
  9. cjmartin

    use all_tab_columns tables with add'l query

    Hello, I am attempting to do the following: 1) Select distinct table names from all_tab_columns where column_name = 'ABC' and owner = 'XYZ' SQL: SELECT distinct table_name INTO tables_ABC_XYZ FROM all_tab_columns WHERE column_name = 'ABC' AND owner = 'XYZ'; 2) Query the tables...
  10. cjmartin

    Error formatting Field Object

    synapsevampire, You were dead on...that fixed the problem. Thanks a ton!
  11. cjmartin

    Error formatting Field Object

    I received the error message of "Error formatting Field Object" when running a Crystal report (ver 7.0). This report was run last year without receiving this error. The report uses an Oracle view and two Subreports. Any suggestions on where to start troubleshooting this error? I've...
  12. cjmartin

    Stored Procedure/Sub Report..???...Urgent please

    acr1, Based on the information you have provided, I believe that either a stored proc/main report or a subreport/main report would work. I tend to favor Oracle stored procs over subreports in Crystal b/c of processing speed benefits and the simplicity of its exception handling features, among...
  13. cjmartin

    Debian install issue

    Success! I was able to use jigdo to download a valid "binary-1.iso" file for 3.0...finally!. I burned it to cd and installed Debian (default flavor) without any problems. :-D Much configuration remains, but I'm looking forward to that part...
  14. cjmartin

    Debian install issue

    MJoyce, I purchased the the 3.0 cd's, however I've yet to receive or anything from the vendor in over a month. My patience led me to pursue the download of ver 3.0 cd images via jigdo, which led to my latest post/question.
  15. cjmartin

    Debian install issue

    Okay...trying to the 3.0 download via jigdo but the help file is somewhat confusing to me as the directions seem to be specific to Linux/Unix, whereas I'm downloading from a Windows 2000 platform (using jigdo-lite.bat). I've downloaded all 8 .template/.jigdo combos: woody-i386-1.jigdo...
See more

Part and Inventory Search

Back
Top