Friday, February 24, 2012

How to use Alerts

I have two fields in my report(Start Date and End Date).Start Date should be earllier than End Date.Please help me how to use alerts.

What do you mean by Alerts ? If by "fields" you mean report "parameters" there is no direct functionality. You could use embadded code: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=829175&SiteID=1|||

Thank you Swierzewski.I tried that but I am getting the following error.

An error occured during local report processing

The defination of report is invalid.

The value expression for the report parameter 'Validate' contains an error:[BC30201] Expression expected.

Please help me.

|||Your expression definition in "Validate" parameter is wrong. If you followed the steps from my link you should have something like this in your Validate.DefaultValue(non-queried):

=CODE.CheckSignificantDate(Parameters!<name of your "date from" parameter>.Value,Parameters!<name of your "date to" parameter>.Value)

i.e.

=CODE.CheckSignificantDate(Parameters!DateFrom.Value,Parameters!DateTo.Value)

Ofcourse you have to add to your report "CheckSignificantDate" function (everything is explained in the link i've posted).

|||

Now the alert is raising.But one more error it is showing

"An error occured during local report processing.Error during processing of 'Validate' report parameter."

please help me

|||

This error is OK :) This will show every time you enter wrong values for your date parameters and will prevent execution of the report (which is ok).

You should provide apropriate error message in the popup (edit message text and message header in your function definition).

|||

Swierzewski,I tried in different ways.But I can't able to eliminate this error.Please help me

|||

Frankly im lost I don't understand what is your problem right now so please clarify this a little bit

Maciej

|||

Ok

I can't able solve this error."An error occured during local report processing.Error during processing of 'Validate' report parameter."

|||

Look, this error is created by YOU (the function in Code) when YOU enter wrong dates. It appears with the popup which tells you that you entered wrong dates. Your only way to "solve" this error is to enter correct dates. If you enter correct dates you won't get this error and report will run.

It is not an error in your code/report definition. It is validation error of your parameters (created by your function). So why you want to solve this error ?

No comments:

Post a Comment