Solved

interactive sorting by clicking on column header

Posted on 2006-06-27
4
239 Views
Last Modified: 2008-03-10
Dear experts

Is it possible to change the sort order of a report by clicking on the column header? I'm using version 11 of CR.

If that doesn't work I will have to do it with a parameter I pass to CR or pass through to my stored procedure and to the sorting there. Since that means a lot of adaptions I would like to work around that.

Thanks
Roger
0
Comment
Question by:SnyTek
4 Comments
 
LVL 28

Accepted Solution

by:
bdreed35 earned 125 total points
ID: 16991660
Unfortunately, Crystal does not give you a way to do this.  I wish they did as I could have used that funcitonality a few times myself.
Your assessment of having to use parameters is the correct way to go.
0
 
LVL 22

Assisted Solution

by:Ido Millet
Ido Millet earned 125 total points
ID: 16992164
No way to do this in Crystal alone.  

Consider a 3rd party tool (see list at: http://www.kenhamady.com/bookmarks.html)
My DataLink Viewer allows you to sort by clicking on column headers (but this requires some formula work inside the report).  For a 1-minute video demo of how this works, see: http://www.milletsoftware.com/Download/DLV_Sort_By_Click.wmv

- Ido
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

864 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now