Changing Sort Order @ Runtime

[ChuckVanT]

I have a report that might be sorted by vendor, or might be sorted by manufacturer. Is there a way that when I give the user a parameter to select the report type, that the sort order can be changed 'on the fly'?

Thanks in advance,
Chuck

 

[Reebo99]

Create a formula based on the parameter then make this your sort order.

i.e.

If {?parameter} = "Vendor" then {table.vendor} else
If {?parameter} = "Manufacturer" then {table.manufacturer}
etc. etc.


Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[Katy44]

This might help:

http://msdn.microsoft.com/library/d...lmn/html/crconcustomizingdatapresentation.asp

 

[Katy44]

...assuming you're using .NET of course...silly me!