Display a message "No data avalaible for period xy"

[Former Member]

Hi folks,

I have a report where the user is prompted to enter a date via a BW variable. Then a small time series is shown in report with the entered date and 90days before(e.g. 31.12., 31.03). Sometimes there is no data for a date.

Can I build a formula which lets display a message like "No data for 31.12."?

I tried this:

While {date_field} <= {?parameter} do

   if Isnull({key_figure)

then {date_field}

But the formula gives an error.

Anyone a different idea?

Thank you very much!

[JWiseman · Accepted solution]

hello Seyhan,

have a look at the solution posted here.

this involves having a custom function that figures out which days are missing and creates an output for the missing days. the function is used on the details level so that for each day or set of days missing there is an output.

in this case the function outputs the days themselves, but you could easily customize the output of the function to display whatever you wanted.

cheers,

jamie

[Former Member]

Hi Seyhan,

If there is no data for a specific period then you can show / hide a text box.

Insert a text box having text as "No data for {?parameter}" in the Details section.

In the right click menu of this text box >> Format object >. Common tab >> X-2 fomula button for Suppress condition >> write following code:

Count(Table.Field) >1

Here, table.field is any object/column that you have placed on the 'Details' section.

Thanks,

Prathamesh