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 Chriss Miller 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 oradba101

  1. oradba101

    crystal reports command and oracle tables

    Perhaps you need to schema qualify the table? Regards, William Chadbourne Programmer/Analyst
  2. oradba101

    Oracle reports bulider cannot use CASE WHEN statement

    Hi, Soushi01 Oracle reports earlier than 9i will not recognize CASE statements internally. You could probably get it to work from within the database. William Chadbourne Programmer/Analyst
  3. oradba101

    Oracle reports bulider cannot use CASE WHEN statement

    What is the database version? William Chadbourne Programmer/Analyst
  4. oradba101

    Creating a Running Total in PL-SQL (that refers to itself)

    Why don't you write a REF CURSOR package? I had to do it for a Crystal Report that needed to be able to define parameters before the report was run William Chadbourne Programmer/Analyst
  5. oradba101

    How to call crystal reports XI from Oracle Forms 10G

    Hi, IQ First of all are you running this from the host (application server) or from the client (local PC)? Regards, Bill Chadbourne William Chadbourne Programmer/Analyst
  6. oradba101

    Save As issue

    I didn't. It puts the saved report name there automatically. William Chadbourne Programmer/Analyst
  7. oradba101

    Need fundamental explanation of ORacle Package for Crystal

    This is from the official Crystal Reports documentation: In order for Crystal Reports to report off Oracle stored procedures, all of the following requirements must be satisfied: • To use an ODBC connection to access an Oracle stored procedure, you must create a package that defines the REF...
  8. oradba101

    Need fundamental explanation of ORacle Package for Crystal

    Did the package I uploaded help in any way? Regards, William Chadbourne Programmer/Analyst
  9. oradba101

    Oracle 10 G - Procedure Package for Crystal Reports

    Greetings, nkshah This package is used in a Crystal Report for the purpose of allowing the user to select how many "bars" a user wishes to see in a bar graph report. This is the package spec: CREATE OR REPLACE PACKAGE ANALYTE_HISTOGRAM...
  10. oradba101

    Oracle 10 G - Procedure Package for Crystal Reports

    I have a package I created to do this for a Crystal Report which I will upload when I get to work. I'll add comments to explain what is going on. Regards, William Chadbourne Programmer/Analyst
  11. oradba101

    Oracle 10 G - Procedure Package for Crystal Reports

    Yes, because Crystal will only recognize a table or a view so in order to use a package (Crystal will not work with a procedure) it has to return a REF CURSOR which Crystal will interpret as a table. Regards, William Chadbourne Programmer/Analyst
  12. oradba101

    Save As issue

    Actually, it doesn't. I have to manually change it in the File->Summary Info. William Chadbourne Programmer/Analyst
  13. oradba101

    Save As issue

    Greetings, I am using Crystal 10. If I have a report open and I want to save as a report with a different name, the name in the window bar in the top left hand corner still has the name of the original report. I know that if I select File->Summary Info from the menu bar then I can save it...
  14. oradba101

    Oracle Express Edition Export Results

    Greetings, Are you using Oracle Application Express as well? Regards, William Chadbourne Programmer/Analyst
  15. oradba101

    Replace first occurence of string from the right

    Hi, Dave Looks like exactly what I need Thanks, William Chadbourne Programmer/Analyst
See more

Part and Inventory Search

Back
Top