Search results for query: *

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

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

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.

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

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

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

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

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

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

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

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

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

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

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.

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

MrTom, Thanks for your advice (and encouragement). Actually, I ordered the 3.0 disks last month, but got impatient waiting for their arrival, and lacking a response from the vendor, I downloaded 2.2. I might wait to see if the cd's ever arrive or try the jigdo download. Thanks again!

Hello, I am attempting to install Debian 2.2 rev7 (i386) on a Pentium II box. I made it through some initial roadblocks (by removing modem/network card/sound card): after selecting the default flavor (idepci) it would hang shortly thereafter. I've configured the keyboard, partitioned for a...

rogar/rhinok/synapsevampire, Thanks for the feedback! I actually had the documentation on my desk...sometimes I just need to look right in front of me first. :)

Does anybody know if Crystal Enterprise 8.5 supports Oracle Views and/or Stored Procedures yet? I had heard that it didn't but they were working on it (possibly for 9.0?). Thanks!

Your formula works great...THANKS!!!