Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT Preview Report(BIRT throwing error on one of the result set column)
BIRT Preview Report [message #882944] Thu, 07 June 2012 14:03 Go to next message
Carlos Ferrer is currently offline Carlos FerrerFriend
Messages: 18
Registered: July 2009
Junior Member
I have the following sql which works when previewing from the edit data set:
SELECT A.XREF_OIMS_SID_NO,
D.OIMS_NAME,
E.OFFT_PAR_ELIG_DATE,
E.OFFT_MAX_EXP_DATE,
DATE(F.WTSK_TME_CMPLTD) CS_SMRY_CMPLTD_DTE,
(CASE
WHEN (B.CPL_RVW_STATUS = 'x' AND
B.CPL_RVW_STS_DATE > E.OFFT_PAR_ELIG_DATE)
THEN B.CPL_RVW_STS_DATE
WHEN (B.CPL_RVW_STATUS = 'x' AND
E.OFFT_PAR_ELIG_DATE > B.CPL_RVW_STS_DATE)
THEN E.OFFT_PAR_ELIG_DATE
ELSE
E.OFFT_PAR_ELIG_DATE
END) DOCKET_DATE
FROM TPRELEASE_XREF A,
TPCASEPOOL B,
TPOFFENDER_STATUS C,
TAMASTER D,
TAOFFTIME E,
TPWF_TASK F
WHERE XREF_PRIMARY = x
AND A.XREF_CPL_ID = B.CPL_ID
AND A.XREF_ID = B.CPL_XREF_ID
AND B.CPL_OIMS_PREL_STS = 'A'
AND A.XREF_OIMS_SID_NO = C.OSTS_SID_NO
AND C.OSTS_STATUS = 102
AND A.XREF_OIMS_SID_NO = D.OIMS_SID_NO
AND A.XREF_OIMS_SETUP_DT = D.OIMS_SETUP_DTE
AND A.XREF_OIMS_SID_NO = E.OFFT_SID_NO
AND A.XREF_OIMS_SID_NO = F.WTSK_SID_NO
AND A.XREF_ID = F.WTSK_XREF_ID
AND A.XREF_CPL_ID = F.WTSK_CPL_ID
AND (
(
B.CPL_RVW_STATUS = 'x' AND
B.CPL_RVW_STS_DATE > E.OFFT_PAR_ELIG_DATE AND
DATE(F.WTSK_TME_CMPLTD) + xx DAYS > B.CPL_RVW_STS_DATE
) OR
(
B.CPL_RVW_STATUS = 'x' AND
E.OFFT_PAR_ELIG_DATE > B.CPL_RVW_STS_DATE AND
DATE(F.WTSK_TME_CMPLTD) + xx DAYS > E.OFFT_PAR_ELIG_DATE
) OR
(
B.CPL_RVW_STATUS <> 'N' AND
DATE(F.WTSK_TME_CMPLTD) + xx DAYS > E.OFFT_PAR_ELIG_DATE
)
)
AND F.WTSK_TASK_CODE = xI'
AND F.WTSK_STATUS = 'x'
AND F.WTSK_UPDATE_DATE =
(
SELECT MAX(WTSK_UPDATE_DATE)
FROM TPWF_TASK G
WHERE G.WTSK_SID_NO = A.XREF_OIMS_SID_NO
AND G.WTSK_XREF_ID = A.XREF_ID
AND G.WTSK_CPL_ID = A.XREF_CPL_ID
AND G.WTSK_TASK_CODE = 'x'
AND G.WTSK_STATUS = 'x'
)
ORDER BY XREF_OIMS_SID_NO
WITH UR

I am getting the following error when trying to preview the report:
Table (id = 128):
+ Column binding "WTSK_TME_CMPLTD" has referred to a data set column "WTSK_TME_CMPLTD" which does not exist. (Element ID:128)
data.engine.ColumnBindingReferToInexistColumn ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Column binding "WTSK_TME_CMPLTD" has referred to a data set column "WTSK_TME_CMPLTD" which does not exist. (Element ID:128)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)

It doesn't like DATE(F.WTSK_TME_CMPLTD) CS_SMRY_CMPLTD_DTE. CS_SMRY_CMPLTD_DTE is being displayed as a column under the data set. I dragged CS_SMRY_CMPLTD_DTE to my table column and tried to preview it.

How do I get BIRT to recognize this column?

Thanks.
Re: BIRT Preview Report [message #883123 is a reply to message #882944] Thu, 07 June 2012 21:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If you drag the whole data set to the canvas, which creates the table,
does it work?

Jason

On 6/7/2012 10:03 AM, Carlos Ferrer wrote:
> I have the following sql which works when previewing from the edit data
> set:
> SELECT A.XREF_OIMS_SID_NO,
> D.OIMS_NAME,
> E.OFFT_PAR_ELIG_DATE,
> E.OFFT_MAX_EXP_DATE,
> DATE(F.WTSK_TME_CMPLTD) CS_SMRY_CMPLTD_DTE,
> (CASE
> WHEN (B.CPL_RVW_STATUS = 'x' AND
> B.CPL_RVW_STS_DATE > E.OFFT_PAR_ELIG_DATE) THEN B.CPL_RVW_STS_DATE
> WHEN (B.CPL_RVW_STATUS = 'x' AND
> E.OFFT_PAR_ELIG_DATE > B.CPL_RVW_STS_DATE) THEN E.OFFT_PAR_ELIG_DATE
> ELSE
> E.OFFT_PAR_ELIG_DATE
> END) DOCKET_DATE
> FROM TPRELEASE_XREF A,
> TPCASEPOOL B,
> TPOFFENDER_STATUS C,
> TAMASTER D,
> TAOFFTIME E,
> TPWF_TASK F
> WHERE XREF_PRIMARY = x
> AND A.XREF_CPL_ID = B.CPL_ID
> AND A.XREF_ID = B.CPL_XREF_ID
> AND B.CPL_OIMS_PREL_STS = 'A'
> AND A.XREF_OIMS_SID_NO = C.OSTS_SID_NO
> AND C.OSTS_STATUS = 102
> AND A.XREF_OIMS_SID_NO = D.OIMS_SID_NO
> AND A.XREF_OIMS_SETUP_DT = D.OIMS_SETUP_DTE
> AND A.XREF_OIMS_SID_NO = E.OFFT_SID_NO
> AND A.XREF_OIMS_SID_NO = F.WTSK_SID_NO
> AND A.XREF_ID = F.WTSK_XREF_ID
> AND A.XREF_CPL_ID = F.WTSK_CPL_ID
> AND (
> (
> B.CPL_RVW_STATUS = 'x' AND
> B.CPL_RVW_STS_DATE > E.OFFT_PAR_ELIG_DATE AND
> DATE(F.WTSK_TME_CMPLTD) + xx DAYS > B.CPL_RVW_STS_DATE
> ) OR
> (
> B.CPL_RVW_STATUS = 'x' AND
> E.OFFT_PAR_ELIG_DATE > B.CPL_RVW_STS_DATE AND
> DATE(F.WTSK_TME_CMPLTD) + xx DAYS > E.OFFT_PAR_ELIG_DATE
> ) OR
> (
> B.CPL_RVW_STATUS <> 'N' AND
> DATE(F.WTSK_TME_CMPLTD) + xx DAYS > E.OFFT_PAR_ELIG_DATE )
> )
> AND F.WTSK_TASK_CODE = xI'
> AND F.WTSK_STATUS = 'x'
> AND F.WTSK_UPDATE_DATE = (
> SELECT MAX(WTSK_UPDATE_DATE)
> FROM TPWF_TASK G
> WHERE G.WTSK_SID_NO = A.XREF_OIMS_SID_NO
> AND G.WTSK_XREF_ID = A.XREF_ID
> AND G.WTSK_CPL_ID = A.XREF_CPL_ID
> AND G.WTSK_TASK_CODE = 'x'
> AND G.WTSK_STATUS = 'x'
> )
> ORDER BY XREF_OIMS_SID_NO
> WITH UR
>
> I am getting the following error when trying to preview the report:
> Table (id = 128): + Column binding "WTSK_TME_CMPLTD" has referred to a
> data set column "WTSK_TME_CMPLTD" which does not exist. (Element ID:128)
> data.engine.ColumnBindingReferToInexistColumn ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: Column
> binding "WTSK_TME_CMPLTD" has referred to a data set column
> "WTSK_TME_CMPLTD" which does not exist. (Element ID:128)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
>
>
> It doesn't like DATE(F.WTSK_TME_CMPLTD) CS_SMRY_CMPLTD_DTE.
> CS_SMRY_CMPLTD_DTE is being displayed as a column under the data set. I
> dragged CS_SMRY_CMPLTD_DTE to my table column and tried to preview it.
>
> How do I get BIRT to recognize this column?
>
> Thanks.
Re: BIRT Preview Report [message #885243 is a reply to message #883123] Tue, 12 June 2012 17:09 Go to previous message
Carlos Ferrer is currently offline Carlos FerrerFriend
Messages: 18
Registered: July 2009
Junior Member
Sorry for getting back with you so late. Yes what you suggested worked. Thanks.
Previous Topic:Missing pre-defined styles for grid-row, grid-cell, table-row, table-cell
Next Topic:Linking query with Parameters in Data Set - Reports
Goto Forum:
  


Current Time: Wed Nov 26 15:33:35 GMT 2014

Powered by FUDForum. Page generated in 0.02117 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software