Sorting at runtime in Crystal report
I am new to crystal reports and I need to some complex sorting on some reports
I have a crystal report with 2 groups (in order to implement drill downs)I am showing this report on the website by using crystal report viewer control in asp.net.
I have a combo box. I need to populate the combo with the relevant fields in each of the report level. ie I have field1 and sum(field2) in the first level group by field1. On clicking one record, I get level 2 which has field3 and sum(field2) group by field3 for the particular value of field1 from level1.
And finally, when I click one of those records, I get a detail level drill down with many fields.
So in the first level,the combo should have field1 and sum(field2) and so on.
On selecting a value from the combo and clicking a button, I want the data in the particular level to get sorted.
I am able to sort reports with no drill downs or groups. But for group by reports, I get some problems.
If anyone has tried this out, pls help.