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
Registered: January 2009
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,
'SUN', 1) sample_order
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)
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.
I tried to passin the parameter
(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
Current Time: Fri Jul 21 14:09:30 CDT 2017
Total time taken to generate the page: 0.12716 seconds