Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Category Project Status Chart report is not viewing in graphical chart.

Hi,

I created a dupilcate "Category Project Status Chart with GL " of "Category Project Status Chart ",however not able to generate the graphical chart on the report.

My Query Defination for the Catagory Report Chart

SELECT <%RESULTS%> FROM ( SELECT DISTINCT INTERNAL_CAT_OBJECT_NAME AS CATEGORY,CASE WHEN

((<%SCHEMA%>.FCI_PRJ_STATUS(T1.OBJECTID,3)) = 1) THEN <%RES_ID(projects$project.status.red)%> WHEN

((<%SCHEMA%>.FCI_PRJ_STATUS(T1.OBJECTID,3)) = 2) THEN <%RES_ID(projects$project.status.yellow)%> WHEN

((<%SCHEMA%>.FCI_PRJ_STATUS(T1.OBJECTID,3)) = 3) THEN <%RES_ID(projects$project.status.green)%> WHEN

((<%SCHEMA%>.FCI_PRJ_STATUS(T1.OBJECTID,3)) = 4) THEN <%RES_ID(projects$project.status.future)%> WHEN

((<%SCHEMA%>.FCI_PRJ_STATUS(T1.OBJECTID,3)) = 5) THEN <%RES_ID(projects$project.status.complete)%> ELSE

<%RES_ID(projects$project.status.unknown)%> END AS PRJ_STATUS_NAME,<%SCHEMA%>.FCI_PRJ_STATUS(T1.OBJECTID, 3)

AS PRJ_STATUS_CODE, <%SCHEMA%>.FCI_DOC_CUR_CONVERT(COALESCE(ESTIMATED_PRICE,0),ESTIMATED_OBJECT_ID,<%COMPANY_CURRENCY_OBJ_ID%>)

AS PRICE,(SELECT DISPLAY_NAME FROM <%SCHEMA%>.FCI_MAS_CURRENCY WHERE OBJECTID = <%COMPANY_CURRENCY_OBJ_ID%>) AS

CURRENCY FROM <%SCHEMA%>.FCI_PRO_PROJECTS T1 WHERE T1.INACTIVE = 0 AND T1.IS_TEMPLATE = 0 AND

T1.CONTEXTID = <%CONTEXT(projects.projects)%> X inner join <%SCHEMA%>.FCI_DYN_$2147483538 ON OBJECTID = <%SCHEMA%>.FCI_DYN_$2147483538.OBJECTID ) GROUP BY GL_DESCRIPTION_OBJECT_NAME,CATEGORY, PRJ_STATUS_NAME, PRJ_STATUS_CODE, CURRENCY <%ORDERBY%>

The report i am seeing is

Normal report with one column as "GL Description" with values in a table.

Please let me know if you have any idea ?

Regards

Sumanta

Former Member
Not what you were looking for? View more on this topic or Ask a question