Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: sort by does not work Post Reply Post New Topic
Author Message
Jimm
Newbie
Newbie


Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
Quote Jimm Replybullet Topic: sort by does not work
    Posted: 24 Jul 2017 at 7:50am
one question: how to sort by one crystal report based on column 'Percentage'. This column calculated from 'Order/Visits', but the Group Sort Expert is gray out and can not use, I added column 'Percentage' into Report/Record Sort Expert, but it does not work either.

Page 'Details' is under another page if click each number under 'Order' column.

Anyway, I suspect the report format causes the sort by not working



RHb                      4     total signed orders
RHb      Doctor Order    visits           Percentage

GH1b      A        1        5                  20%
GF1
GH1b      B        2        6                  33%
GF1              
GH1b      C        1        10                 10%
GF1

etc.....

Any idea or suggestion? Thanks in advance
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 24 Jul 2017 at 8:42am
alas, you are not allowed to sort on a formula that is a calculation. If you are using a stored proc to pull your data, you could do the calculation there and then it would exist in data and then you could group by it.

How else can we get around this...if you are just linking directly to the tables, you might be able to create a command that would calculate the value that you want and then join the command to the actual table. That should work.

Just working straight from the tables will not, as you have already found out.

HTH
IP IP Logged
Jimm
Newbie
Newbie


Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
Quote Jimm Replybullet Posted: 24 Jul 2017 at 9:04am
Thanks,

I tried to get calculate data 'percentage' column, then sort by it, still does not work. I use Commend to have different columns(with SQl scripts at backend).

I am concern the issue caused by I have the percentage value number in Group Header #1B,not in Details section, any ideas?
IP IP Logged
Jimm
Newbie
Newbie


Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
Quote Jimm Replybullet Posted: 24 Jul 2017 at 9:06am
I mean I calculate Percentage in sql code at backend, then sort this column from COMMEND percentage column, but still can not SORT BY this column
IP IP Logged
Jimm
Newbie
Newbie


Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
Quote Jimm Replybullet Posted: 24 Jul 2017 at 9:49am
Also I tried to sort by column: 'Doctor', or 'order', or 'visits'. does not work either.

IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.