Hi,

I need to generate reports in that way if data is not available for particular month it should say any custom message like "Data is not available for this month" instead of showing empty chart.

any suggestions please.

Thanks is advance !!

Faneshwar

In the Source Table, say field x is what you're displaying in the report.  You can create an if statement for that field to say if(Field X="","Data is not available",Field X).  This only works for a non-numerical field though since you wouldn't want text in a numerical based field.  Another option would be to make a separate field with an if statement that populates your message based on the value in the numerical field. 

Thanks Eric.

but in this case

a.  if we have multiple fields to show on report then we have to create multiple if statement, would that be a right way in regards of performance?

b. To achieve this we have to create formula columns or new columns in transform table (with if statement) for each fields. would that be a right approach?

Since you have multiple fields that need to display the message, my approach might not be very practical.  Unfortunately, I can't think of any alternate ways at the moment. 

If the entire report table is empty (no data at all) in some months, then one option is:

1. Switch to report edit mode.

2. Select the report table.

3. (top) Ribbon > Author > Visibility > Report Component Visibility: Component contains data > OK.

4. (top) Ribbon > Insert > HTML.

5. In the new HTML component, paste this text: <span style="font-size:200%">Data not available this month</span>

6. Move the new HTML component to overlap (visually block) the report table.

7. Right-click HTML component > Send to Back.

Now the report table will vanish in months with no data, and the HTML component will instead show up in its place for those months:

Thanks Christopher,

It has solved my problem. Cheers!!!