End User Sorting within groups

[SMosley804]

Crystal Reports XI
DB-IBM DB2

I have a report that has an on demand sub-report. I would like to be able to give the user the ability to sort the sub report based on the field heading.

The report is designed so that if the end-user clicks the Day(on demand sub report) the details for the day appears on the sub report. The report is displayed as below. I would like to add functionality to the subreport that if the user clicks the field column in the sub report the report is re-sorted based on that selection.

Ex. Main Report
Day Week
Total Total
Nf to Sel 1 2
NF to Clr 2 3
Sel to NF 3 4

Ex.Sub Report

Hour NF to Sel NF to Clr
1 17 3
2 16 6

So if the user clicks the NF to Sel column the sub-report would be resorted to look like the following.

Hour Nf to Sel Nf to Clr
2 16 6
1 17 3

Please Help!
Sonya

 

[MJRBIM]

Can't be done in CR-XI.

Header-Linked Sorting within the viewer is available in CR-2008.

Keep in mind that CR-2008 content is limited if you are looking to host it on the WEB or through an Application.

 

[SMosley804]

Thanks! I was thinking that but now I know for sure.

 

[IdoMillet]

If you need this functionality in versions prior to Crystal 2008, Consider a 3rd-party tool as a solution (for a list of such tools, see

http://www.kenhamady.com/bookmarks.html).

You can see a 1-minute video of how column header click to sort works in my DataLink Viewer at:

http://www.milletsoftware.com/Download/DLV_Sort_By_Click.wmv

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com