We found few issues related to Export to Excel ...
1. Group Totals are not appearing in Excel output. We have tested both ExcelML and BIff... Group Header and Grand total row appear in Excel but Group totals not appear. We have not set any GroupFooter template and expect simple total should appear.
2. We are getting Excel Sheets without formatting. Is there any easy way that Excel should get same formatting as it view like Winform grid.
If not then what is the generic way to format it, as we are creating single Viewer for different grid based report - generated dynamically thru code and placed on Asp form.
3.While adding Java script for handling Double click Event, we found a solution to use Client Side Event RowDbClick ... which pass args..
in that ars._datakeyvalues.Id (ClientKeyName) ... now the problem is that we have same asp page used as viewer for different kind of grid based reports.
each have different fields .... We can set ClientKeyNames thru code but how to make this Java script dynamic...
In one Report we have Id field, in Second report we have ProductId .... This makes difficult to pass different key thru clientside event..