Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a lot of confusion on what is the best tool to use...
As we know, we can easily export SSRS reports to excel file. But, sometimes there is a user requirement to automatically refresh the data in the excel file when user opens the file again. Robert Bruckner has written this excellent post for doing this using inserting a image file into the World or Excel...
In some situation it is required to have a page break in HTML rendering for better display. But this leads to the multiple excel sheets when we exports the report to excel file. Sometimes, users want to do some further analysis on the exported excel file and if data is exported to multiple sheets, users...
I have already posted a blogpost on how to query directly on a EXCEL file using a query. Here is the link http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx But for EXCEL, verions starting from 2007, different Provider should be used. Here is the provider which...
I came to know that Most of the people do not know what is Pivot table and their importance in analysis of the team status reports, bug report or appraisal reports whatever it may be. These can be used by mid-level to Top Management people or Business Analysts, Account managers in order to view Monthly...
Posted to
Hima's blog
by
Hima
on
10-06-2010
Filed under:
Filed under: BRH, #DOTNET, #ASP.NET, Pivot table Grouping, Pivot tables, Excel2010, Office 2010, Pivot, Pivot charts, #PIVOT, Excel pivot, Excel, Excel 2010
If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it http://support.microsoft.com/default.aspx?scid=kb;en-us;281517
Apart from using DTS and Import/Export wizard, we can also use this query to export data from SQL Server2000 to Excel and vice versa To export data from SQL Server table to Excel file, create an Excel file named testing having the headers same as that of table columns and use this query insert into OPENROWSET...