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

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

Exporting to Excel2007

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :ASP.Net

Hi All

While working on a Project recently I came across to know that the ReportBuilder2.0 from SQL server doesn't allow us to save the excel file in 2007 format.

Why I need this is because of we have large number of data to export in from the report to excel which may be around 2lakhs+.

So, if any one having the idea that how we will make the report builder work that it will allow us to export in excel2007 format, please let me know.


View Complete Post

More Related Resource Links

Exporting web from MOSS 2007 to WSS 3.0

Hi! I'm trying to export SharePoint web site from MOSS 2007 to WSS 3.0.

There are some problems, which prevent me. WSS doesn't include two features: DataConnectionLibruary and TransMgmtLib. This features are not avaible on WSS, so I tried to deactivate these features using site capabilities. It wo'nt help. Here is the exception text:

Could not find Feature TransMgmtLib
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.VerifyFeatureDefinition(SPRequirementObject reqObj)
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.Validate(SPRequirementObject reqObj)\
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.DeserializeAndValidate()
at Microsoft.SharePoint.Deployment.SPImport.VerifyRequirements()
at Microsoft.SharePoint.Deployment.SPImport.Run()
at InfoCenter.ConsoleTestingApp.Program.ImportInfoCenter()

The question is: which way must I go to solve this problem? Is it really possible (I mean export from MOSS to WSS)? And what is the purpose of TransMgmtLib feature? Thanks.

Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

Exporting SharePoint list to excel.

Hi All,   We have a SharePoint list in which one column is "Person or Group" and it can take multiple values. When we export it to spread sheet this column contains some junk data.We are using MOSS 2007 and Office 2007. Previously asked question on the same issue http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/00cc338d-8201-4b8d-b2ea-5979ee58a464 Does any one know of a Microsoft published article for this issue as we need to provide it to our higher ups for this issue.   Thanks.

Exporting a gridview into word landscape

Hi,  I have managed to export a gridview into word but is there a way when i export the gridview into Word that Word opens in landscape? Thanks in advance, Jon 

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

Issue while exporting to Excel

Hi All, We are having report in SSRS 2005, everything is working fine while Running the report on BIDS as well as on Report Server, but as soon as we export the report to Excel it is creating issue(S) not just a issue. First - I'm not able to see "Footer" in Excel, although it does exist in BIDS as well as Report Server. It is visible while doing Print-Preview in Excel, why so is it a bug, is their any work around to make it visible without doing Print-Preview, please do let me know! Second - It is regarding "Header", I have couple of text boxes in my Report Header, as soon as I include text boxes in Report Header and when I export to excel, the rows & columns height as well as width is getting disturb (meaning some getting compressed and some getting expanded), so to make it look attractive we have to manually arrange in proper order before delivering to our end-user, Can anybody tell me why rows & columns are getting disturbed and also how to arrange with exact height & width without any manual interpection, please help me out, this is getting me crazy?   Thanks Regards, Kumar

Blank Pages - When exporting reporting to Adobe Acrobat

I have a report in Reporting Services 2005, when the report is exported to Adobe Acrobat, i keep on getting a blank page between every pages! How do i get rid of them? Thanks

Exporting multiple gridviews in multiple excel tabs

Hi All, I am able to export multiple gridviews in a single excel worksheet My question is can I separate these gridviews in multiple tabs under the same excel file ? This is my current method under the link buttonprotected void lnkExport_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition","attachement;filename=TrendAnalysisRpt"+StoreNum); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); HtmlForm frm = new HtmlForm(); this.grd_Inj.Parent.Controls.Add(frm); this.grdBody_1.Parent.Controls.Add(frm); frm.Attributes["runat"] = "server"; frm.Controls.Add(this.grd_Inj); frm.Controls.Add(this.grdBody_1); frm.Controls.Add(this.grdBody_2); frm.Controls.Add(this.grdBody_3); frm.Controls.Add(this.grdBody_4); frm.Controls.Add(this.grdMonth); frm.Controls.Add(this.grdDay); frm.Controls.Add(this.grdHours); frm.Controls.Add(this.grdLengthOS); frm.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); } Thanks again!    

Exporting SQL Maintenance Plans

I have taken a look at the new maintenance plan designer and have come up with a maintenance plan I would like to be able to deploy on an enterprise level.  Anyone know of a way I can export the plan to another SQL 2005 server - without directly pulling from the msdb system tables?  I like the fact that you can script the output of most of the wizards, but the maintenance plan wizard does not appear to be one of them.Thanks,Matt

sharepoint exporting

can anyone help with exporting one sharepoint site collection from one computer to another. a teammate and I are working on creating a sharepoint site, and we are working from two separate sharepoint sites on two computers. we are able to back up our work, but when we attempt to export one site to another computer to combine attributes it continually fails and returns an error message. can anyone help out on this?

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

Exporting my query result to .CSV or .Txt fomat?

Hi everyone, i would like to ask if there is way on how to export my query result into .csv or .txt file?   Thanks

exporting to excel templates

Hi all, I currently have an excel file that has 2 spreadsheets. 1 is the raw data (formatted) and the second is the validation spreadsheet. I want to create a new file biweekly that has the new raw data, but the same validation spreadsheet/same formatting sheet for raw data. I created a file system task that copies the sample template into a different location, then renames it as an excel file with the date included in the name (@newfile). My question is, how can I now connect to the new excel file within the data flow task and insert the data into the formatted sheet? I have tried creating an excel connection to another workbook in the same path and setting the connection string = @newfile, however I am getting the following error; Error 1 Validation error. Data Flow Task: Excel Destination [67]: The AcquireConnection method call to the connection manager "AG010908.xls" failed with error code 0xC0202009. Package.dtsx 0 0  Even with that connection working, how can I insert the data in the first row of the formatted spreadsheet (since it won't be available until after the file is created. The name of the formatted sheet will remain static) Thanks!

SSRS Report Problem while Exporting into PDF

We are trying to generate a report in SSRS 2005 with Landscape  layout. The report if fine but when we export it into PDF format the result comes in 2 pages that is fine but there is an image in the footer which is only displaying in the last page of the report footer the text fileds are fine only image is not displaying in every page while exporting. Please guide.............

Convert from Number to Text- Exporting to Excel from SQL Reporting services 2000

I was trying to export a report which contains a number format. When I do that, all the numbers in excel will have a green small tag beside it saying "Convert from Number to Text". Is there anyway that I can change the format to a number when I export it to excel?

Cannot choose language of word exporting document with Reporting

I am creating report (in word) with Reporting Services 2008. I can't find a way to specify the language of the document. It is always in english.
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