OraFAQ Forum: Reports & Discoverer » Oracle Reports works on Report Builder but not on Report Server

Home » Developer & Programmer » Reports & Discoverer » Oracle Reports works on Report Builder but not on Report Server (Oracle Report 10g r2, HP ux 11.31)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Reports works on Report Builder but not on Report Server [message #379503]

Tue, 06 January 2009 18:12

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

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

Report message to a moderator

Previous Topic:	reports server failed
Next Topic:	Solution for the error REP-52007

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 05 13:45:07 CDT 2024