locked
I have created a joined view (with a Data View Web Part in SharePoint Designer), how can I export it to Excel RRS feed

  • Question

  • I have created a joined view (with a Data View Web Part in SharePoint Designer), how can I export it to Excel

    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS

    Monday, May 14, 2012 10:24 AM

All replies

  • Hi Hasan, open the DVWP in designer and select it and edit click on data view property and under General tab select the check box for SharePoint List Toolbar this will enable the same toolbar which is being displayed on SharePoint List and this will give you an option to export the table into Excel. hope this helps.

    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

    Monday, May 14, 2012 11:48 AM
  • Hi pratik,

    Its happen only when i have take list onlye in dataview web part but when i try to take current data soucrce with join on that time expeort fiunctinality is not thare.

    Please sugges me other way.


    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS

    Tuesday, May 15, 2012 8:28 AM
  • Hi Hasan,

    I need same functionallity.. did u get any solution regarding this.. if u have, pls let me know.. its urgent...


    NS

    Friday, December 21, 2012 5:57 AM
  • Dear NvzS,

    No with dataview web part its not possible so u can try as

    uses CAMEL query and then through Spquery join uses in vs costume web part,

    last write code for export in excel.



    Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Share Point Application Developer,TCS

    Friday, December 21, 2012 6:19 AM