Recent content by ejeffcott

This worked! Thank you very much!

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

Yes, it is a date.

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

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

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.

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

Thank you so much! This worked perfectly.

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

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

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.

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

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