Bar Chart reports do not show correct data when stacked by a reference field with a String field with display as true on the table - Known Error

Bar Chart reports do not show correct data when stacked by a reference field with a String field with display as true on the table Description On bar chart type reports, a reference field can be used in the Stack by fields. The report does not render data correctly if the referenced table has a String field set to Display = true.

Steps to Reproduce

Create a custom table, u_rma_actual_faults as example

Create a new dictionary field on this table Type = String Label = Actual faults Name = u_actual_faults max length = 60 Display = true Active = true Save

Create a new custom table extending from Task u_test_PRB1347726 for example

Create a new reference field on this u_test_PRB1347726 table Type Reference Label = Actual faults Name = u_actual_faults Reference table: u_rma_actual_faults Save Add some data on both the tables. You might need to configure the form on u_test_prb1347726 to add the RMA actual faults field. Create a new report based on u_test_prb1347726 table Type = Bar chart Table = u_test_prb1347726 group by = Assigned to Stacked BY = Actual faults Check setting for Display data table

Save and Run report. The chart shows as no data to display, but the data table shows the records correctly.

Workaround After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make this decision lightly, and we apologise for any inconvenience.

Removing the display setting from the field allows the report to render correctly, but shows sys_ids on the stacks. Add a new name field on the table with same data as Actual Faults, so the name will have by default display = true and the chart will render correctly.