Go Back > Forum > Baan SIGs > Third Party Products

User login

Frontpage Sponsor


Google search

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

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
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

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
else if {@opening}+1 > {update_.ideal} then
else if {@opening}-1 < {update_.critical} then
else if {@opening} < {update_.ideal} then

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

Reply With Quote
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
color_code = 1
else if {@opening}+1 > {update_.ideal} then
color_code = 2
else if {@opening}-1 < {update_.critical} then
color_code = 3
else if {@opening} < {update_.ideal} then
color_code = 4

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

Reply With Quote

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 01:47.

©2001-2017 - -