I'm currently running Visual Studio 2008 (Version 10 of CR). We have a Winforms application that runs various crystal reports. I can't say there's anything particularly sophisticated about it. Just slap the report in a viewer, pass in the parameters, and run. I am not an expert in CR or Excel.
The problem is, as near as I can explain, that a client wants to export reports in full Excel format (not data only) but he still wants to be able to sort on the first column, which is an id field. Unfortunately, as near as I can tell, if you do a full export that column is spread across several Excel columns and is not sortable.'
Suggestions? Is there any way around this? Or is the cllient asking the impossible?
(Someone in another forum mentioned a 'Simplify Page Headers Option' but so far I have been unable to find that.)