I need to design a small project for generating excel reports in .NET, which will be sent to users to use. The excel reports will contain PivotTables. I don't have much experience with them, but I can think of three implementation alternatives: Set a query for it, populate it, send it disconnected. This way the user will be able to g...
I have a workbook with 20 different pivot tables. Is there any easy way to find all the pivot tables and refresh them in VB? ...
I've used Excel PivotTable to analyze data from my database because it allows me to "slice and dice" very quickly. As we know what is in our database tables, we all can write SQL queries that do what PivotTable does. But I am wondering why PivotTable can construct the queries so fast while it knows nothing about the data and the meanin...
Can you use calculated fields in Excel 2007 pivot tables when the data source is an SSAS data cube? I am connecting to a SQL Server 2005 data cube with Excel 2007 and viewing the data though a pivot table. I want to create calculated fields in my pivot table, but the "Formulas" button is grayed out. How do I do create calculated field...
I have a pivot table on an olap cube. I can go into a page field and manually deselect multiple items. How can I do this in VBA based on a list of items I need excluded? (n.b. I do not have a corrresponding list of items I need included) I know how to exclude these items in other ways, by altering the underlying query for example. I spe...
I have a spreadsheet with a dataset of a number of transactions, each of which is composed of substeps, each of which has the time that it occurred. There can be a variable number and order of steps. I'd like to find the duration of each transaction. If I can do this in Excel then great, as it's already in that format. If there isn't...
Here is some sample VBA code: Sub Macro1() Dim pt As PivotTable Set pt = ActiveSheet.PivotTables("SomePivotTable") 'Set colOfFields = pt.PivotFields End Sub The third line is incomplete/broken. What is the correct way to get access to collection of all the fields in a PivotTable? I need to be able to loop over them. Act...
I am trying to find a good way of accessing a Business Intelligence OLAP Cube from C#. I don't really care much as to how this is done, but since currently I am trying to implement this with the codeplex WPF Toolkit, I would be happy if it was something directly related to the tool, but any suggestions are very welcomed. My WPF skills ...
We have an Excel spreadsheet with the Grand Totals at the top using a Forumla, but this isn't on the actual Pivot Table it's just in the spreadsheet. We have a client that wants the Grand Totals at the top of the Pivot Table and doesn't want us to use Formula. Does anyone know if this is possible (even using VBA or something, just so lo...
Hiii, I have a Database design as: Table File (FileID, Name, Details) Table Attributes (AttID, AttName, AttType) Table AttValues (FileID, AttID, AttValue) Till the runtime, it is not known how many Attributes are in a File and of what names. And I want to display after insertion at Frontend in a manner like like: FileID, FileName...
I want to change it from one database to another. There don't appear to be any options to do this on the pivot table context menu ...
I have an xls with a pivot table using a proc to populate it. I deleted the data connection in 'admin tools - odbc - file DSN' and it still works, how is that possible? Does that mean that the recipent doesn't have to have the file DSN present in order to see data in the pivot table? ...
Is there a way to perform updates on a PIVOTed table in SQL Server 2008 where the changes propagate back to the source table, assuming there is no aggregation? ...
I have 3 Worksheets. Following is an explanation of what I am trying to do. EM11 EM12 EM01 The steps below are meant for Sheet EM11 but I want to repeat them FOR Sheet EM12 and Sheet EM01 Select Sheet EM11 Copy J2:J65636 and copy G2: G65636 Create a new worksheet called EM11-Count Paste Column J into cell A2 of new worksheet ca...
I have a pivot table with a pivot field and contain many items. I've VBA code logic to decide if the pivot value should be visible or not. The problem is excel recalculates pivot table for each field shown or hidden which makes it very slow. I would like something where it recalculates only once, after all the values are set. I tried usi...
I have the following situation in database: Department table holds all departments in the company. Employee table holds all employees, together with their department id and AllowedAbsenceDays field, which tells us how many days is the employee alowed to be absent in the current year. Absence table holds all absences that occur in the...
I have a table of name value pairs where I am storing tags: TAGID | NAME | VALUE I have a table of 'Things' this tags apply to THINGID | TAGID I need a query to generate a resultSet were the columns/fields are all possible TAG-NAMES (NAME field in the TAG table)for a given THINGID and the values are the correspondent tag values. T...
Hi, Does anyone know how I can embed an Excel Pivot table control in a win form application developed in C#? The raw data for the form would be coming from a SQL Server 2000 database and loaded into a DataTable. Thanks, ...
To all, I have an Excel spreadsheet pivot table that is linked to an SSAS data source. The employee counts are aggregated and return the following values: Row Label Count North America 7 South America 2 Europe 5 Asia 1 Australia 3 Let's say the user modifies the South America Row to read ...
I've tried looking around all the chart options, but I can't seem to find a way to set the line width of the chart series once and for all. Of course, I could run a macro every time the series selection in the pivot chart is changed, but I'm hoping there's a simpler way... ...