Returning 'NO Products Available' in one,many or ALL prompt

[system]

Hi ,

How do I change the prompt for one, many or all values to give me ‘No Product discounts Available’ when there is No actual product discount available? Here is the psuedo code for selecting one, many or all values of a prompt:

Products.Product_discount in @Prompt(‘Enter discount rate’,‘A’,)
or
‘*’ in @Prompt(‘Enter discount rate’,‘A’,)

I want to change this to give me ‘No Product discounts Available’ instead of ‘No Data to fetch’ when user selects All values manually and there is no data that meets all of the entered values. The ‘*’ functions OK and the 'No Product dicounts shows but if the user selects all values manually, it gives no data to fetch. SO i want to change this to:

case when Products.Product_discount is NUll then ‘No Product discounts Available’
else
Products.Product_discount in @Prompt(‘Enter discount rate’,‘A’,)
or
‘*’ in @Prompt(‘Enter discount rate’,‘A’,)
end case

but this gives the error of missing keyword.

Does anyone know how to give ‘No PRoducts Available’ instead of returning no data to fetch when user selects all the values individually and not ‘*’ and there is no data to show!!

thanks,
ajq

---

anushajq (BOB member since 2005-02-22)

[system]

Without using the SDK, no.

You could test for 0 row counts and display and hide cells depending upon the results received by each DP.

---

Mak 1 (BOB member since 2005-01-06)

[system]

Could you explain what you mean by hide cell for 0 count. How and where do I have to do it ? Is it done using the SDK?

---

anushajq (BOB member since 2005-02-22)

[system]

No, you can set this by clicking on the cell and selecting cell format, appearance choosing hide the cell depending when there is a row count >0.

You can show the cell by using a standard if then else variable row count =0 and display your message.

---

Mak 1 (BOB member since 2005-01-06)

[system]

Please Check this out.

Refer link

FAQ: Reporter

How can I supress the ‘No Data To Fetch’ message? There are multiple methods of supressing the ‘No Data To Fetch’ message. Programmatically… If you copy this code into the ThisDocument module, it should work. To implement the code, you will need to have your Report which gives you the No Data to fetch message open. Click on Alt + F11, and the Visual Basic Editor will open. On the left hand side you should see a list of all the documents you have open. Under the name of the documen…

Hope this helps

---

pinku (BOB member since 2006-08-23)