Problem with CR and Excel Export

[Former Member]

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.)

[former_member11696]

Please remember to mark posts as answered

[former_member11696]

Hello,

Open the report up and add a sort to the ID field, CR will sort the matching row data with the id so when exported it too will be sorted and alined properly.

If you want to do this in code then post to the [.NET SDK forum|;.

But PLEASE search first in forums and in our knowledge base, someone has likely already asked and an answer has been given.

Another place for lots of samples is here:

http://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReportsSDKSampleApplications

Thanks

Don