I am workin on Crystal Reports for VS2005

1>Can i create alerts in it,if yes how?

2>How can i read values that are calculated by formula fields in the application code?

Dell is right that can't get the value while the report is processing. But it has more to do with the Crystal Reports object model. When you reference the report object, you are doing so prior to the report being processed. Thus, no formulas have values in them yet. But the second problem is that Crystal Reports simply doesn't expose any properties that tell you the value of a formula. It only returns the text of the formula, not the result. So there is nothing you can do except what Dell mentioned and that is duplicate the processing of the data in SQL and analyze the values with that resultset.

Now, considering that, if you want to get REALLY advanced, you could do something like create an updateable command object that writes a value to a special SQL table as the report runs. Then in your .NET app you can query the SQL table for that value. I haven't actually done this yet, but I'm going to be working on it soon so I can put an example in the book (should be pretty cool).

I see what you are talking about. Unfortunately, Visual Studio CR 2005 doesn't have report alerts. If you have access to CR XI, then you can build the report in XI and call it from VS 2005. This will let you do alerts. Otherwise, you are stuck with you SQL workaround.

I'm not familiar with the Rows property of the report object. That must be new for 2005. I'll have to look into it. Thanks for the update!