Solved

Sort Columns in Crystal Reports

Posted on 2011-02-28
2
468 Views
Last Modified: 2012-06-27
Hi all,

I have a table in Oracle  with columns like this

Location,
Time,
error code 1
error code 2
error code 3
...
Error code 15.

 columns error codes 1 .. 15 etc show  counts for particular error code. I want to be able to
sort the columns grouped by location and time.

for example data might be like this

location 1 , Feb 1 2011, 10,20,30 etc etc
locatin2    , feb 2 2011, 20,30,40 etc etc


I want to be able to sort them descending
for example

Location 1
        feb   1 2011     30    //error code three  description...
         feb   1 2011     20    // Error code 2  descriptionl...
         feb    1 2011    10   // Error Code 1


Is there a way to sort columns for a date   in crystal reports?
 
0
Comment
Question by:maverickxx
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 35001360
Not really with the data you have

You could put the fields into an array and sort them then print them line by line.

Another idea would be to  use a command to select each field in turn and union the results

Select Location, Date, COlumn1 FROM table
UNION
Select Location, Date, COlumn2 FROM table
UNION
Select Location, Date, COlumn3 FROM table
etc

You can then group by location then date and sort by the column value

mlmcc
0
 

Author Closing Comment

by:maverickxx
ID: 35017902
thanks mlmcc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question