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
incase i forgot to include the serverity, i needed this 5 hours ago
Hello spicish2222,
I have been looking through your post and I tested the scenario that you are referring using the approach shown in the following blog:
http://forums.infragistics.com/blogs/mihail_mateev/archive/2010/06/07/using-the-infragistics-xamgrid-with-ria-services.aspx and Northwind database.
Then I try to export the XamGrid using the XamGridExcelExporter and everything exports as expected on my side. Would you please provide me with a small sample where the issue is representable so I can continue my investigation on this matter.
Thanks in advance.
the sample is that blog post in NOT similar to what i am doing. i can not send a sample as we are not permitted to.
the sample has direct pulls off of tables with No (Includes) statements, and an auto generated grid.
i have included a document so you can put together a sample with all the vital parts to reproduce the issue.
I have been looking through your posts and based on them I am not able to represent your scenario on my side.
Still after some investigation I can suggest you handle the CellExporting event of the XamGridExcelExport in order to manually change the exported data in the excel cells. Also you can try manually exporting the cells of your XamGrid using the following approach:
http://help.infragistics.com/Help/NetAdvantage/Silverlight/2011.1/CLR4.0/html/SL_Exporting_xamGrid_Data_to_Excel.html
Furthermore, if you want I can make for you a private support ticket about this issue, so you can sent me a test sample where this issue is representable.
Please let me know if I can provide you with any further assistance on this matter.
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
Hi spicish2222,
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.
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
Let me know if you require further assistance on this matter.