Chart a-axis with null data

[meemz]

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

[ido_millet]

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

[DellSC]

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

[meemz]

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