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

[Former Member]

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]

Hi Sumanta,

Are you, by any chance, trying to see the graph when you 'Preview' your query? It won't show up there. You will have to run it as a report and then the graph should be displayed.

If you are getting the tabular output correct and have chosen the correct type of graph, there is no reason why it should not be displayed.

Thanks

Devesh

[Former Member]

Hi Devesh,

In report view it is thorowing error like "*The creation of the chart failed for the query: Category Project Status Chart with GL*"

Please let me know if you have any idea ?

Regards

Sumanta

[Former Member]

Hi Sumanta -

What does the chart configuration for the report have in it? Also, have you checked the system log files to see if there are more details about the error there?

Regards,

Rob

[Former Member]

Hi Rob,

Now the chart is displaying , however the color notaion is not showing, It is showing only one yellow color.In Chart defination i used as *

Color Palette: High Contrast and Legend: East*

as it is in original.

Please let me know if any configuration required.

Regards

Sumanta

[Former Member]

Hi,

Could you please let me know the Root Cause of this issue, I am facing similar issue.

Thanks and Regards

Ram