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

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

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

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

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

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

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!

I have a procedure with a varchar input parameter. I'm trying to schedule via dbms_job, but am having problems. Here's how I scheduled other procedures (without input parameters): DECLARE job_no NUMBER; BEGIN DBMS_JOB.SUBMIT (job_no ,'begin myprocedure; end;' ,TRUNC(SYSDATE...

When attempting to schedule Crystal Reports that use Oracle (PL/SQL) Stored Procedures, I get an error message stating "PEStartPrintJob : Error detected by database DLL". This error message is received regardless of whether report parameters exist or not. I have not read anywhere...