Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Third Party Products (http://www.baanboard.com/baanboard/forumdisplay.php?f=24)
-   -   Sorting report by color (http://www.baanboard.com/baanboard/showthread.php?t=64206)

username 21st June 2013 03:25

Sorting report by color
 
Hi,
I am having trouble in sorting my report using Crystal Report. User request to sort this report by color. My formula cannot be as group.

if {@opening}+1 > {update_.overflow} then
"OVERFLOW"//crBlue
else if {@opening}+1 > {update_.ideal} then
"IDEAL"//crGreen
else if {@opening}-1 < {update_.critical} then
"CRITICAL"//crRed
else if {@opening} < {update_.ideal} then
"RE-ORDER"//crYellow

I don't have any idea to sort this report.:(

Thanks.

vamsi_gujjula 21st June 2013 11:36

its been quite some time that i have worked with crystal reports.

an alternative that you can try is .. have a variable lets say color_code .

if {@opening}+1 > {update_.overflow} then
"OVERFLOW"//crBlue
color_code = 1
else if {@opening}+1 > {update_.ideal} then
"IDEAL"//crGreen
color_code = 2
else if {@opening}-1 < {update_.critical} then
"CRITICAL"//crRed
color_code = 3
else if {@opening} < {update_.ideal} then
"RE-ORDER"//crYellow
color_code = 4


and try sorting it by variable..... although i am not sure... its just a work around .

regards
vamsi.


All times are GMT +2. The time now is 03:24.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com