|
|
| Re: Error for report on view [message #115523 is a reply to message #115520] |
Tue, 12 April 2005 08:18   |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
It is very difficult to ascertain the problems you are having without a coded example. Also, if you are interested in the error messages I believe you can search the OTN (Oracle Technology Network -- www.oracle.otn.com) for documentation on the error messages, their meaning, and (possibly) how to remedy the problem. Reports help (within Builder) also offers limited help with error messages.
Good luck,
Steve
edit - forgot link to OTN
[Updated on: Tue, 12 April 2005 08:18] Report message to a moderator |
|
|
|
| Re: Error for report on view [message #115535 is a reply to message #115523] |
Tue, 12 April 2005 09:33 |
wall_walker
Messages: 2
Registered: April 2005
Location: Karachi
|
Junior Member |
|
|
Thanks Steve for ur concern. I m sorry I should have given the coding.
I created my like this:
CREATE VIEW SAL AS SELECT M.BILLNO,M.BILLDATE,M.CCODE,C.ITCODE,C.KGS,(C.KGS*C.RATE)-(C.KGS*C.RATE*M.DISCOUNT*.01) AMT FROM MASTER M, CHILD C WHERE M.BILLNO=C.BILLNO AND M.TYPE='S' UNION
SELECT M.BILLNO,M.BILLDATE,M.CCODE,C.ITCODE,C.KGS,(C.KGS*C.RATE)-(C.KGS*C.RATE*M.DISCOUNT*.01) AMT FROM MASTER@DBLINK M, CHILD@DBLINK C WHERE M.BILLNO=C.BILLNO AND M.TYPE='S'
Now when I ran this query:
SELECT TO_CHAR(BILLDATE,'YY') YY, ITCODE, SUM(KGS), SUM(AMT) FROM SAL WHERE TO_CHAR(BILLDATE,'MON')='JAN' GROUP BY ITCODE, TO_CHAR(BILLDATE,'YY');
It gave me the required results but when I ran this in Report with a Parameter instead of 'JAN' and even passing 'JAN' in parameter it gave same errors.
Please check this again.
THANKS in advance 
|
|
|
|
| Re: Error for report on view [message #115559 is a reply to message #115520] |
Tue, 12 April 2005 11:55 |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
Consider the following example:
SELECT
TO_CHAR(sysdate, 'RR') YY
FROM
dual
WHERE
TO_CHAR(sysdate,'MON')= :p_month_abbreviation
Substitute 'APR' for :p_month_abbreviation and yield '05'
You may need more assistance. In the meantime, look on metalink (metalink.oracle.com) or OTN for the error messages (and post here what they are). I have a feeling the errors are raised due to the way that BILLDATE is analyzed in relation to the parameter you are entering, but I am not sure without definitions of the errors.
Regards,
Steve
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
