Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Third Party Products

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st June 2013, 04:25
username username is offline
Junior Member
 
Join Date: Dec 2010
Posts: 5
username is on a distinguished road
Baan: Baan 5c - DB: SQL Server - OS: Windows Server 2003
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.
Reply With Quote
Sponsored Links
  #2  
Old 21st June 2013, 12:36
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 240
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
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.
__________________
Regards,
Vamsi
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
color in report fields klixy23 Tools Development 15 28th September 2015 09:35
Printing Color Logo on ERP LN report. deepakb Tools Development 2 24th November 2008 12:26
solving recursion problems rmarles Tools Development 2 25th January 2005 22:23
sorting of records in report mostrightfuture Tools Development 7 9th October 2004 08:12
Sorting in the report mprakash Tools Development 3 21st July 2004 08:03


All times are GMT +2. The time now is 19:34.


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