| Author |
Message |
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
   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 Logged |
|
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
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 Logged |
|
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
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 Logged |
|
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
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 Logged |
|
Jimm
Newbie
Joined: 10 Nov 2016
Online Status: Offline
Posts: 32
|
Posted: 24 Jul 2017 at 9:49am |
|
Also I tried to sort by column: 'Doctor', or 'order', or 'visits'. does not work either.
|
|
IP Logged |
|
|
|
