straight table cal condition message when no data

[surajap123]

Hi Experts,

I have straight table has some list of rows. The chart shows just chart skeleton with nulls, when it has no data for the user selection.

My requirement is to show a message in the chart when there is no data for the user selections.

I thought to create a calculated condition, but not sure which field to put there as user can do selection on any listbox for which chart may have no data.

Please help

[vishsaggi]

May be create a flag in your script and use that calculated filed in our condition. Like

IF(Len(Trim(YourfieldName1)) =0 OR

    Len(Trim(YourfieldName2)) =0 OR

    Len(Trim(YourfieldName3)) =0 OR

    ..... = 0, 0, 1)                                       AS ExistDataFlag

This would be just one time creation in your script.

[vinieme12]

What is the Dimension in your Chart?

What is the expression in your Chart?