this is the third or forth control i have had issues reguarding the use of WCF RIA services
here is my exporter
<ig:XamGridExcelExporter x:Name="excelExporter" ExcludeGroupBy="False" ExportRange="All" ExportEnded="excelExporter_ExportEnded" />
when i pull a service with an Includes
From p In Me.ObjectContext.tblRequests.Include("tblWorkFlowStatu")
i can see the data in the grid
<ig:TextColumn Key="tblWorkFlowStatu.StatusDesc" HorizontalContentAlignment="Stretch" VerticalContentAlignment="Center" HeaderText="Status" />
'Completed'
however when i export it comes out like this, this is the colum in the xls:
please answer as to how to fix this
the work around works
thanks!
i do not. i ended up rewriting the whole before the last two posts.
i have not tested to see if the proposed fix will work
Hi spicish2222,
Let me know if you require further assistance on this matter.
I've gone over your sample and I can see where the issue is occuring and this issue has been resolved in the latest service release. As we no longer ship updates for Silverlight 4 and focus solely on Silverlight 5 support, the latest service release contains the fix for SL5.
If it is not possible for you to upgrade to SL5 you can resolve this issue by updating the exported object from within the XamGridExcelExporter.CellExporting event. The code inside the event handler would look like this:
If e.Column.Key = "Status.StatDesc" Then MyRequest request = DirectCast(e.ExportObject, MyRequest) e.ExportObject = request.Status.StatDescEnd If
Let me know if you have any questions on this.
i have now wasted time creating you a sample so you can acuratly represent it on your side
use the files in the 'scripts' folder to make the DB. the connection in the config is set to local. run the app and click the local button on the page Home. i have placed two tested in the testExports folder so you can see what exactly i am refering to.
i am aware you can spin a grid in the code behind with the obj model. that is not what i wanted to do. that is not the point of the XamGridExcelExporter which is supposed to do that for you.
please provide me the exact reason as to why this does not work
feel free to send me your export file once you are done testing