Warning message in Prompt selection

[Former Member]

Hi,

We are working on a requirement, where we need to display a warning message in prompt screen when the value of End Date is less than the Start Date. Please let me know if this is possible in BO 4.1. Also any workaround solution is appreciated.

Thanks,

Karthik K

[Former Member · Accepted solution]

You can validate it after the prompt selection, as probably the query will return no data, when the report is to be rendered you can test for the condition.

If the condition is met (Start Date > End Date), you use Javascript tp show thw popup and after it you force the refresh (take a look at).

Create a filter variable {filter] = If ([Start Date] > [End Date];1;0)

Drop a blank Cell on the report, create another variable , [script] = If ([filter] =1;

"

<script>

  alert("Start Date grreater than End Date");

  self.parent._askConfirmationBeforeClosingDoc=false;

  setInterval(function(){window.parent.parent.location.reload();},n*1000);

  </script>")

Save the report, re-open it set the property of the blank cell "Read as" to HTML and assign [script] to the blank cell (drop it on the blank cell.

Save the report again.

If the user enters an Start date greater the End date, the report will show the mesage "No data retrieved for Query ", when the user closes this pop-up, the pop-up with the alert will be shown, closing it will force the documents refresh.

Take a look at

It will only work in the HTML client.

Cheers,

Rogerio

[sateesh_kumar1]

Hi Karthik ,

It is not possible to validate conditions at prompt level .