How to pop up alert "No Data found" if there are no values in database

[Former Member]

Hi All,

Please tell me how to pop up alert if there is no data found and all fields are null in report for given parameter value. or else is there any way to trigger user while entering parameter value that wrong parameter value. (I dnt want to use drop down) in my report.

Please help me. Any help will be valuable.

Thanks.

[Former Member · Accepted solution]

There's no way that I know of to do this as a "Pop-up", but providing a "no records returned" warning still easy enough to do.

Just insert a new Report Header section...

Add a text box that has whatever message you'd like to display.

Right click the new header section and choose Selection Expert

Click the X-2 button next to Suppress (No Drill-Down)

Enter a formula similar to this...

IF COUNT({TableName.FieldName}) < 1 THEN FALSE ELSE TRUE

This will suppress the warning if records are present and display it if there are none.

HTH,

Jason

[Former Member]

Hi,

This is applicable for CR 2008:

In the "Prompt Text" of the "Edit Parameter" window you can use the valid range to be keyed-in for each parameter.

Further with the use of Edit Mask you can check the value of the text keyed-in by the user.

For more details on how to set the edit mask please refer the Crystal Reports Help in the help menu.

Thanks,

Prathamesh A