Question Re: Chart a-axis with null data in Technology Q&A

Chart a-axis with null data

meemz — Mon, 17 Jan 2022 23:04:55 GMT

Hi All,

I want to truck shipment over specific period for example Q1 and Q2 for 2018 - 2019 and represent result in crystal report chart.

I do left join date table with shipment table but date with no shipment is not being displayed. I want to display all dates for each item even no shipment.

Kindly advise me

Re: Chart a-axis with null data

DellSC — Tue, 18 Jan 2022 14:42:17 GMT

I would create two formulas to set default values for these fields when they're null. They would look like this:

{@Item}
if IsNull({MyTable.Item}) then 'N/A' else {MyTable.Item}

{@Cost}
if IsNull({MyTable.Cost}) then 0 else {MyTable.Cost}

Be sure to set the null handling in the Formula Editor to "Exceptions for Nulls" so that IsNull() will work correctly. Then, use these variables in the chart instead of the fields.

-Dell

Re: Chart a-axis with null data

meemz — Fri, 21 Jan 2022 00:25:07 GMT

Hi, it doesn't work. chart showing a specific dates only but I want to display fixed date axis for each item. Each chart should display all dates from column A regardless ship date in column D

Re: Chart a-axis with null data

ido_millet — Fri, 21 Jan 2022 13:58:25 GMT

One simple solution is to select 'Numeric Axis' when selecting the chart type. Then, select 'Date Axis...'.