Alert for Data Change

[BoeingSK]

Is there any way to create an alert or highlight formula that would capture data change. I have a report that covers all our orders over the last few years. I need to know if I can have something that would highlight any change when i update. I also on want only the changes to show suppressing everything else.
Crystal 11

Up and Coming Technical Guy

 

[Tatertot45]

How do you know if a field has changed?

 

[BoeingSK]

Sorry let me re-phrase that , not the field but the data in the field. If the price was $10.00 then change to $20.00 or if an order had a due date of 10/1/08 and changed to 1/1/08,I want to have these detail lines show only.

Up and Coming Technical Guy

 

[bdreed35]

Crystal doesn't "store" the data from the last time you ran it so you can compare it with new data.
I have done this in the past by building a stored procedure that updates a custom table with the new data, and then returns the new data to the report, along with the data from the previous run of the report.
I then compared fields for records with the same key value and to see what, if anything changed.

~Brian

 

[BoeingSK]

Any references on how to do that procedure.


Up and Coming Technical Guy

 

[2328]

In crosstab report in summary fields, I should produce one value based on 2 filed values(1.Ratio ,2.Color)
On the top of the color I need see the ratio.
Right now I am showing 2 fields(0:0 crRed)
but user wants to see only one value

[COLOR=red ]5:6[/color]

 

[lbass]

2328,

Please start a new thread as your issue has nothing to do with the current thread.

-LB

 

[IdoMillet]

BoeingSK,

This type of need is typically addressed by what's known as Snapshot Data Warehousing.

There are several ways to approach this. One alternative is to use a 3rd-party tool. For a list of such tools, see:

http://www.kenhamady.com/bookmarks.html.

For a description of how my Visual CUT software addresses this need, see:

http://www.milletsoftware.com/Download/Visual CUT ODBC Export Functionality.pdf

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[2328]

Hi friends,
I don't some how I am unable to find how to create a new thread, thats the reason , I am still reply here.
Sorry for that.
Lbass , can I know how I am going solve this, I am totally confused and waiting for result.
Advance thanks

 

[BoeingSK]

2328, Click on the Top of this page where it says Forum. Then there is a start new Thread Link at the top of all the Topics. Don't worry I used to be in your shoes!!

Up and Coming Technical Guy

 

[2328]

Thanks for every one, I created a new thread