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 ejeffcott

  1. ejeffcott

    Error:

    This worked! Thank you very much!
  2. ejeffcott

    Error:

    I have modified the code so it will return at least 200 characters. However, I now receive the following error: REP-2103: Column 'CF_2': PL/SQL formula returned invalid value or no value I'm at a loss... function CF_2 return VARCHAR is v_age NUMBER; v_return VARCHAR2(200); begin v_age :=...
  3. ejeffcott

    Error:

    Yes, it is a date.
  4. ejeffcott

    Error:

    I receive the following error after attempting to run the program unit below in a report. REP-1401: 'cf_1' : Fatal PL/SQL error occurred ORA-06502: PL/SQL: numeric or value error FUNCTION CF_1 RETURN CHARACTER IS v_age NUMBER; v_return CHARACTER; BEGIN v_age := TRUNC(SYSDATE) -...
  5. ejeffcott

    How to Group Dates

    I need to be able to group a set of dates by 30 days away, 60 days away and 90 days away. I'm new to Oracle Reports and I've been researching within the help tools, but have been unsuccesful in finding a solution. Can anyone please shed some light on how to accomplish this? I have included...
  6. ejeffcott

    Oracle Reports 10g - User Parameters

    Thank you! This worked perfectly. One more question, do you know of any good writte resources where I can learn to use Oracle Forms. I am having a difficult time figuring out the basics to the tool. Again, thank you.
  7. ejeffcott

    Oracle Reports 10g - User Parameters

    Instead of entering static values for the parameters, I entered a Select query to define each user parameter. The query in which my report is based is define below select DISTINCT maybe.casename, maybe.casenumber, maybe.intake, maybe.DOI, maybe.SOL, maybe.venue, maybe.casetype...
  8. ejeffcott

    Oracle Reports - Paper Layout

    Thank you so much! This worked perfectly.
  9. ejeffcott

    Oracle Reports 10g - User Parameters

    I have 2 user parameters: One that allows user to select the office. Here is the code: select DISTINCT e.lastname from t_entity e INNER JOIN t_entityrelationship er on e.entityid = er.childentityid INNER JOIN t_relationshiptype r on er.childrelationshiptypeid = r.relationshiptypeid where...
  10. ejeffcott

    Oracle Reports - Paper Layout

    Sorry for the delayed response, there is a repeating frame for office and another repeating frame for employee ||''|| extension. By way of the data model layout, i created a break group w/office. I can get the down-across layout with only one repeating frame report. However, i have to delete...
  11. ejeffcott

    Oracle Reports - Paper Layout

    Thank you for your response. I changed the print direction of my two repeating frames. Nothing changed. In the Paper Design, it outlined everything in red. I assume out of an error on my part. I'll keep playing, but if you have any other suggestions, I thank you.
  12. ejeffcott

    Oracle Reports - Paper Layout

    I want to create a report that displays employees & their corresponding extensions. However, I only know basic ways to manipulate the data appearance. As of right now, the data takes up less than half of the width of the paper. What I would like is for two columns of employees & extensions...
  13. ejeffcott

    Query to remove Carriage Return

    In need a query that would remove carriage returns from a section of a report. I've tried various different ways, this is my latest: select c.casesummary from t_case c replace(c.casesummary,chr(13)||chr(10),' ') I keep getting an ORA-00907 error "missing right parenthesis" ugh - i'm at...
See more

Part and Inventory Search

Back
Top