Group Sorting Problem

[maulae]

I am working on Crystal report 10/11 with SQL server, I am having problem in sorting on group,
My report is based on subreports also, I get the Qty.QtyID in main table (sting value i.e. x123, t345, g3kt etc.) and Qty value from subreport QtyDtl.QtyData( number value i.e. 8000, 2000,6000 etc,) I have grouping on QtyID in main report and display the data value from subreport.
The problem is - when I display this grouping I just display the Qty data (8000,2000,6000) and its related details information, I did sorting on the main report on QtyID, and QtyID for 8000 is less than QtyID of 2000, so, 8000 appears before 2000, but I need to display in sorting order of Qty Data (2000, 6000,8000).
I will appreciate if somebody give the solution –how can I display the sorted Qty Data value?

 

[synapsevampire]

Since the sort order is predicated on the subreport, you should make the subreport the main report.

-k

 

[maulae]

Thanks for your response, I really appreciate your time, actually I have used some other subreports which are linked to this main report table, so, I can not change my logic, is there any other way to sort as I need?
Thanks

 

[lbass]

You cannot do a group sort based on a summary unless it is created in your main report. The question becomes whether you need to use a subreport for this.

-LB