slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: Trend Report in Crystal

RJ Eaton
Posts: 234

Trend Report in Crystal Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Sep 07 1:47 PM

I am in the process of creating a new Crystal Report in XI.. I have a table that captures the actual status of an item each time it changes..

I am collecting the change of the field as .. Changed_From and Changed_To along with the date.. I'd like to take the last change and then based upon the values display either an Up arrow or down arrow.. so if my data row looked like:

09/11/2007 | 3 | 4 |--- I would display an Up arrow because it changed from a 3 to a 4..

How would I accomplish this in the crystal report

[Reply][Quote]

RJ Eaton
Posts: 234

Re: Trend Report in Crystal Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Sep 07 11:44 AM

Ok Found out how to handle this.. thought it might be worth while for someone else...

Create a formula - call it Change Value - to subtract the two values {Changed From} - {Changed To} Then Create an alerter on the Change Value and if negative, display a down arrow character - probably a wingding font and if positive - display an up arrow - or whatever logic is correct.

if(Changed_To - Changed_From>0,"h","i")

the values "h" and "i
" in Wingdings 3 font is Up and Down arrows respectively..

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 12:48:53 PM