Home » Developer & Programmer » Reports & Discoverer » placeholder problem
placeholder problem [message #496556] Mon, 28 February 2011 23:37 Go to next message
helloworld_28
Messages: 60
Registered: October 2010
Member
hi,

i have problem
Re: placeholder problem [message #496557 is a reply to message #496556] Mon, 28 February 2011 23:48 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I have another problem Smile
describe your problem so that we will try to help you

Sriram
Re: placeholder problem [message #496618 is a reply to message #496557] Tue, 01 March 2011 07:51 Go to previous messageGo to next message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Just remember:

The solution to 67.2 percent of programming problems is to add the missing semicolon.

[Updated on: Tue, 01 March 2011 07:53]

Report message to a moderator

Re: placeholder problem [message #496620 is a reply to message #496618] Tue, 01 March 2011 08:15 Go to previous messageGo to next message
CajunVarst
Messages: 54
Registered: April 2010
Location: Washington, D.C.
Member
Quote:
The solution to 67.2 percent of programming problems is to add the missing semicolon.


Also, remember that 87.3 percent of statistics are made up.
Re: placeholder problem [message #496891 is a reply to message #496556] Wed, 02 March 2011 21:49 Go to previous messageGo to next message
helloworld_28
Messages: 60
Registered: October 2010
Member
sorry,

i have upload the file ,but it is not found because oracle report generated .jsp file , it is not also in this forum now i upload the file rdf extension.
Re: placeholder problem [message #496914 is a reply to message #496891] Thu, 03 March 2011 01:47 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so now we have a file, we know you have a problem.

We still don't know the problem itself.
Re: placeholder problem [message #496954 is a reply to message #496914] Thu, 03 March 2011 05:19 Go to previous messageGo to next message
cookiemonster
Messages: 10930
Registered: September 2008
Location: Rainy Manchester
Senior Member
Your rdf doesn't appear to be an rdf. My oracle reports doesn't recognize it.
Re: placeholder problem [message #496970 is a reply to message #496954] Thu, 03 March 2011 06:03 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That might depend on Builder's version (yet another information we don't know).
Re: placeholder problem [message #497085 is a reply to message #496970] Thu, 03 March 2011 22:32 Go to previous messageGo to next message
helloworld_28
Messages: 60
Registered: October 2010
Member
hi,

i have placeholder column which not working,here formula column
function cf_calc_maxformula return number is 
begin
if :sal=:cs_max_sal then
:cp_max_earner := (:ename||'in department'|| :deptno);
end if;
return(0);
end;



here problem is it shows error value error or numeric error how to solve this.
Re: placeholder problem [message #497101 is a reply to message #497085] Fri, 04 March 2011 00:10 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe CP_MAX_EARNER is too short to store (for example) "SCOTT IN DEPARTMENT 10" in there.
Re: placeholder problem [message #497219 is a reply to message #497085] Fri, 04 March 2011 08:54 Go to previous messageGo to next message
dude4084
Messages: 213
Registered: March 2005
Location: Mux
Senior Member
deptno is numeric while ename is charcter type.

Use to_char() to convert numeric into char.


This might help you
Re: placeholder problem [message #497273 is a reply to message #497219] Fri, 04 March 2011 13:10 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Reports to test, but I *believe* that Oracle will implicitly convert number to a character. SQL and PL/SQL on 10g XE don't complain about it:
SQL> select 'scott' || ' in department ' || 10 from dual;

'SCOTT'||'INDEPARTMENT
----------------------
scott in department 10

SQL> declare
  2    l_var varchar2(200);
  3  begin
  4    l_var := 'scott' || ' in department ' || 10;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL>


But, if a variable is not large enough, it will raise an error:
SQL> l
  1  declare
  2    l_var varchar2(10);
  3  begin
  4    l_var := 'scott' || ' in department ' || 10;
  5* end;
SQL> /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 4


SQL>
Re: placeholder problem [message #497351 is a reply to message #497101] Fri, 04 March 2011 21:58 Go to previous messageGo to next message
helloworld_28
Messages: 60
Registered: October 2010
Member

hi
thank now its working.


i want to know oracle 10g reports generates .jsp file , it not rdf that how to convert jsp to rdf
Re: placeholder problem [message #497425 is a reply to message #497351] Sat, 05 March 2011 08:48 Go to previous message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
While in Reports Builder, go to "File - Save As" menu and choose RDF as target type.
Previous Topic: report using join condition
Next Topic: Report is bringing duplicate records in Excel
Goto Forum:
  


Current Time: Tue Sep 02 09:06:05 CDT 2014

Total time taken to generate the page: 0.15201 seconds