Home » Archived » BIRT » org.eclipse.birt.report.data.oda.jdbc.JDBCException(org.eclipse.birt.report.data.oda.jdbc.JDBCException)
| | |
Re: org.eclipse.birt.report.data.oda.jdbc.JDBCException [message #689283 is a reply to message #689279] |
Mon, 27 June 2011 10:32 |
parasu Messages: 13 Registered: May 2011 |
Junior Member |
|
|
Hi Cyril,
Please find the below example and give the suggestion related mentioned issue
Thanks in Advace
Parasuram
Example :
select distinct
K.sfield_7 Period,
R.Opportunity Opportunity,
R.BSLA BSLA,
R.Mgmnt_Structure MGMT_STRUCTURE_COUNTRY,
R.SubPandL SUB_PL,
(SELECT EMSG.English FROM EMSG, ZS_DECODE D
WHERE EMSG.ID = D.EMSG_ID AND D.Attribute_ID = 5003 AND D.Value =K.Flag_23)
Frequency,
K.sfield_8 F1,
A.Group_code F2,
B.local_acriteria_no F3,
K.string_19 F4,
K.string_20 F5,
K.string_21 F6,
K.string_7 F7,
(SELECT EMSG.English FROM EMSG, ZS_DECODE D
WHERE EMSG.ID = D.EMSG_ID AND D.Attribute_ID = 5015 AND D.Value = K.Flag_46)
Risk,
(SELECT E.English FROM ZS_Decode D, emsg E
WHERE E.ID = D.EMSG_ID
AND D.Attribute_ID = 5177
AND D.Value = K.Flag_41) WorkflowStatus,
(CASE WHEN (R.criteria1=0 OR R.criteria2=0 OR R.criteria3=0 OR R.criteria4=0
OR R.criteria5=0 OR R.criteria6=0 OR R.criteria7=0) THEN 'open' ELSE 'closed'
END) Status,
DECODE(R.criteria1,0,'No','Yes')criteria1,
DECODE(R.criteria2,0,'No','Yes')criteria2,
DECODE(R.criteria3,0,'No','Yes')criteria3,
DECODE(R.criteria4,0,'No','Yes')criteria4,
DECODE(R.criteria5,0,'No','Yes')criteria5,
DECODE(R.criteria6,0,'No','Yes')criteria6,
DECODE(R.criteria7,0,'No','Yes')criteria7
FROM
MV_view R,
Item K,
Bank B,
Acgr A
WHERE
K.type=10013
AND B.acc_no=K.acc_no
ANDK.acc_no=A.acc_no
ANDK.acc_no=R.Acc_NO
ANDK.date_20=R.End_Date
[Updated on: Mon, 27 June 2011 10:35] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Fri Mar 29 05:12:39 GMT 2024
Powered by FUDForum. Page generated in 0.04005 seconds
|