Home » Developer & Programmer » Reports & Discoverer » Oracle Reports works on Report Builder but not on Report Server (Oracle Report 10g r2, HP ux 11.31)
Oracle Reports works on Report Builder but not on Report Server [message #379503] Tue, 06 January 2009 18:12 Go to next message
mlee
Messages: 2
Registered: January 2009
Location: california
Junior Member
I am migrating a lot of reports from 9i to 10G.
Most of the reports are working fine except there are a couple reports that are not giving me trouble.
These trouble reports works PERFECTLY fine on Report Builder (9.0.4), BUT when I tried to launch it through Oracle AS, it kept giving me following error:

REP300: missing right parenthesis.
SELECT DISTINCT TO_CHAR(sample_time - 1/2880 , 'MM-DD-YYYY') day,
TO_CHAR(sample_time - 1/2880, 'DY') dayofweek,
decode(TO_CHAR(sample_time -1/2880, 'DY'), 'MON', 2,
'TUE', 3,
'WED', 4,
'THU', 5,
'FRI', 6,
'SAT',7,
'SUN', 1) sample_order
FROM rep_2dplot_temp
WHERE report_seq = :P_seq_currval
and TO_CHAR(sample_time - 1/2880 , 'DY') in (&P_Dayofweek)
and sample_time in (select sample_time + 1/24 from rep_2dplot_temp
where report_seq = :P_seq_currval)
&P_ORDER_BY_CLAUSE

The passing parameter for the report is following:
http://server:7777/reports/rwservlet?report=HourlyVolume&P_VDSID=763636&P_START_DATE=01/06/2009 00:00:00&P_END_DATE=01/06/2009 16:00:00&P_Dayofweek=''SUN','MON','TUE','WED','THU','FRI','SAT''&P_ORDERBY_DATE=1&destype=cache&desformat=PDF&use rid=uid/pwd@myDb&server=rep_server


The difference between these two reports and the rest is that these two reports are passing a list of string.
P_Dayofweek=''SUN','MON','TUE','WED','THU','FRI','SAT''

I tried to passin the parameter
P_Dayofweek='SUN','MON','TUE','WED','THU','FRI','SAT'
(with the single quote only) it doesn't work.

I also tried to pass in a single day,
P_Dayofweek='SUN', I have the same issue.

I am wondering if that would cause the problem. If so, is there workaround it? or has anyone encounter this problem? or is there any solution to it?

Thank you very much for your help.










[Updated on: Tue, 06 January 2009 18:22]

Report message to a moderator

Re: Oracle Reports works on Report Builder but not on Report Server [message #379505 is a reply to message #379503] Tue, 06 January 2009 19:22 Go to previous message
mlee
Messages: 2
Registered: January 2009
Location: california
Junior Member
BTW, those 2 reports works fine on Oracle Report 9i, Oracle Report 10G R1 (9.0.4). but does not work on Oracle Report 10G R2.
I wonder if it's a bug ???
Previous Topic: reports server failed
Next Topic: Solution for the error REP-52007
Goto Forum:
  


Current Time: Thu Dec 08 10:18:48 CST 2016

Total time taken to generate the page: 0.13849 seconds