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 Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
Goto Forum:
Current Time: Tue Sep 10 20:24:38 CDT 2024
|