Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Cross tab & Line Graph – Data Sorting issue Post Reply Post New Topic
Author Message
ThakurS
Newbie
Newbie


Joined: 07 Dec 2011
Online Status: Offline
Posts: 9
Quote ThakurS Replybullet Topic: Cross tab & Line Graph – Data Sorting issue
     Posted: 26 Dec 2011 at 11:05pm
Hi,

Want to display data in specific order in cross tab row & in graph as shown below

Account Name
Average
Median

In the same order data has been retrieved from the database but when it comes to Crystal report, its reordering the data in alphabetical order as shown below due to the order set in Group option

Example: 1
ABC
Average
Median

Example: 2
Average
Median
XYZ

Please note “Average” & Median” are constant but Account name will vary based on selection.
How this can be achieved? How Specific Order can be used in this case?
Please help... It’s urgent…

Thanks,
ThakurS
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 28 Dec 2011 at 12:17pm

You could try creating a group using a formula - something like this:

Switch(
  {TABLE.FIELD} = 'Average', '2',
  {TABLE.FIELD} = 'Median', '3',
  True, '1' + {TABLE.FIELD})
 
Group by this formula but display the field in the cross-tab.
 
-Dell
IP IP Logged
ThakurS
Newbie
Newbie


Joined: 07 Dec 2011
Online Status: Offline
Posts: 9
Quote ThakurS Replybullet Posted: 04 Jan 2012 at 12:23am
Hi,
 
Kindly give more details with exact syntax. And where this formula should be written?
 
Thanks,
ThakurS
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum