Monday, September 26, 2011

How to: Export a Discussion topic List item (SharePoint 2007) to excel or PDF ?

Here is  some tricky way to achieve this GOAL

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

I.e. to enable export to spreadsheet option URL should be http://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” tries following steps.

·         Open Excel
·         Click on DATA tab
·         Select from Web option
·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx
·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to insert required data to excel.
·         And from Excel you can easily export to PDF

Feel free to reach me in case of any queries / issues related to above post.

No comments:

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.