.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Exporting to spreadsheet showing no results

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint
Hi guys,

I have a list that contains a few columns including calculated fields. When I export to a spreadsheet (via Actions => Export to Spreadsheet), I get the usual authentication prompt and thereafter the column headers appear but not the data. I don't have item-level security or anything fancy running on that list.

This is really confusing me. Has anyone had this problem?


View Complete Post

More Related Resource Links

Excel file not showing in search results

We have a strange issue. I have one Excel document (or at least one that I am aware of) that will not show up in search results for content within the document. I can find the document by title just fine, but when I search for words within the document I do not see it. The document was originally a 2003 Excel document and was recently converted to 2007. Other than that there isn't really anything unusual about it (some formatting stuff, but mainly just background colors and whatnot, nothing fancy). The crawl log shows the document was crawled without error. Anyone know anything else I can check on?

Group Results By Month, showing each month as the column

I have to list 50 states and the # of population per month. right now my results look something like..   CA, June, 5000 CA, July, 6000 CA, August, 7000 CA, September, 7230 I want it to show.. State, June, July, August, September CA, 5000, 6000, 7000, 8000 NJ, 4013, 5030, 7020, 7310   I was going to use a PIVOT table but.. I want the columns to expand as the coming month  comes upon us.

Showing Solr XML results in gridview using xmldatasource

I have the XML below, generated by Apache Solr.I want to assign the results (2 <doc>nodes in this case) to a gridview using an XML datasource.<response>-<lst name="responseHeader">    <int name="status">0</int>    <int name="QTime">0</int>    <lst name="params">        <str name="facet">true</str>        <str name="fl">        id,title,city,score,location_rating,introtext,location_rating_total,themes,features,official,services        </str>        <str name="indent">on</str>        <str name="start">0</str>        <str name="q">*:*</str>        <arr name="facet.field">            <str>province_raw</str>            <str>services_raw</str>            <str>themes_raw</str>           &

Search results page showing random characters instead of item's description

I have an email-enabled document library that a few Japanese people email PDF files into (all external to the company). When I search for any PDF file sent from particular email addresses, the search results page displays random characters instead of the item's description. Here is an example: From Screen shots These characters don't appear for all email senders, just some of them. Our MOSS site is in English and we don't have any language packs installed. The PDF file contents are also in English. Can anyone point me towards a solution for this?

Search Results Web part not showing all results

Hello, I have an issue with the people search results web part not showing all the results that exist for a particular query. The query in question returns 106 results, and it is showing 50 per page, but the paging bar only goes up to page 2, and the results summary says it is showing "x of 100 results". If I manually change the query string to say start=61 instead of start=51 for page 2, it will show me the last 6 people, and the search summary will say "showing 57-106" Why is it not showing me the option for a page 2? When I perform a similar query that returns 140 results, it will show me all three pages correctly. I have tried turning duplicate trimming off but it makes no difference either. Any ideas why this is happening? Thank you

People search results showing members deleted from AD

Hi guysWe've configured a full nightly import of users from AD, but I'm seeing users who have been deleted showing up under the People Search function.  Does the import job delete accounts from SharePoint that no longer exist in AD?  If not, is there a way to change this?Tks,steven

aspnet_regsql results not showing in administration



I'm trying to tie my login controls to my externally hosted database. I used the aspnet_regsql tool to create the appropriate tables in the database, but when I try to administer them through the "Administer Website" smart tag on the login control I cant connect to the new tables and such in the "Providers" tab.

Any ideas?

Mysite profile pictures not showing in people and groups, or search results

My organization is running MOSS 2007 Enterprise with search.  Picture profiles uploaded to the user's mysite only appear while browsing from the Default zone.  When browsing the Internet zone, a broken link appears in place of the picture when viewing pages such as "People and Groups" or search results.  For example:

Default zone:

http://moss1:5154   <---- mysite
http://moss1:5155   <---- main sharepoint site

Internet zone:

https://mysite.domain.com  <---- extended mysite
https://domain.com             <---- extended main sharepoint site

The picture profile url that is appearing while browsing the Internet zone is:


Instead of:


All of the textual information is coming over fine, just the images have invalid urls for the current zone.
Does anyone know how to fix this?

Any insights appreciated,


Exporting data to an excell spreadsheet



I am trying to export data to an excel spreadsheet using SSIS, but I do not have excel installed on the server where I am running the SSIS package. When I try to create the excel file, I get an error. Do I have to have excel installed in order to create the file?

Any help would be appreciated


Dave SQL Developer

search results showing label text


I have a custom page layout where I have site columns. My search results shows site column names as part of description. Actually it should show data within those site columns. To dig into this I looked into managed property "Description" which is mapped to following different crawled properties - 


I don't know what are those crawled properties. Can anyone help here?

Thanks in advance.


Errors in the Crawl log and files not showing up in the search results


MOSS 2007:

Problem:  Errors in the Crawl log and files not showing up in the search results

Symptoms/ Error messages: "The filename or extension is too long. (The item was deleted because it was either not found or the crawler was denied access to it.)"

What I have done:  The file paths are under the limit imposed by MS, I already checked that.  The indexing account has access to the files security wise.

·          <

Exporting all surveys' results


Hi All,

Is it possible to export all the surveys' results?

I understand there is already an out-of-the-box feature which lets you export survey results, but this is only for a single survey. Is it possible to export all the created surveys' results to a spreadsheet with a single button/web part. If so, what is the general concept to do it? By developing using web parts? Or is there already a third-party software with this feature?

I just need to know if it is doable, so I can start developing the solution. Any help is much appreciated.

Warmest Regards

Formula showing in OSSR Excel spreadsheet exported from SharePoint list


I exported a list of SharePoint issues into an Excel workbook (2010).  The workbook seemed to work normally as I added new columns and  formulae until just now.  Now when I add a variance calc formula in a cell I see only the formula.  The formula is in a format like "=([@[Prior Est]]-[@[Actual (3/27)]])" instead of "=(G2-F2)" and nothing I do seems to get it to show the actual value.

Is there some sort of bug in the SharePoint excel exports after so many columns are added, or what?

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Creating an Excel Spreadsheet programmatically using VB.NET

The Interoperability services make it very easy to work with COM Capable Applications such as Word and Excel. This article reveals using Excel from a managed application. Excel is the spreadsheet component of Microsoft Office 2000. The majority of Excel programmatic functionality is exposed through Automation via the type library Excel9.olb. The intention of this article is to express that a managed application can interrelate with Excel as a COM server.

Creating an Excel Spreadsheet and Adding Data to It Programmatically

The Interoperability services make it veryeasy to work with COM Capable Applications such as Word and Excel. Thisarticle reveals using Excel from a managed application. Excel is thespreadsheet component of Microsoft Office 2000. The majority of Excelprogrammatic functionality is exposed through Automation via the typelibrary Excel9.olb. The intention of this article is to express that amanaged application can interrelate with Excel as a COM server.

want to execute url without showing that page or url to client.


hello friends,

I need ur help,what i want to do is to execute a url ("To send a text message to client") on client registration but without showing that url page, in short executing url without displaying any page or url to the client.

please help and thanks in advance.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend