Search results for query: *

I am on the business side of providing requirments for a reporting application and I just received some perplexing perfomance stats from the Database team. The execution time (database run time only) was as follows for the 4 different levels of data. Region 65 , Division 651, Territory 65100...

Below is an example of some data that I would like to rank using MS access. It would be similar to using the window funstions of other database applications. Does anyone know how I would create an expression to come up with DATE_RANK? CUSTOMER DATE_OF_PURCHASE DATE_RANK LARRY...

Is there a way to extract a list that shows the sheet name and the pivot table name for all of the pivot tables in a workbook?

When I cut and paste linked cells or charts from Excel into PowerPoint, it autofits all the other text boxes, charts etc. Is there a way to be able to paste (paste special, links) into a Powerpont presentation without impacting any of the other objects on the slide? Thanks, Sam

I am using MS Access to query an Oracle database using an ODBC connection. The query returns an error after 60 seconds that says that the user cancelled execution of the query. I am pretty sure that there is a ODBC timeout set to 60 seconds somewhere within Access but I cannot find out how to...

I have a line chart with month on the x-axis and a Percent Metric on the y-axis. I would like to keep the x-axis static with 12 months (Jan 2006 to Dec 2006). I have data for the first 6 months and do not want the graph to plot the months without data (July - Dec). Basically, there would be a...

I have a horizontal bar chart that has division names on the Y-axis. Can I individually format one of the names to be bold or a different text color? I would like to do this without VBA if possible Thanks, Sam

Is there a way to display alphnumeric values along the y-axis. My current values are 0, 0.5, 1, 1.5 and 2. I would like the values to be 0X, 0.5X 1X, 1.5X and 2X. Is this possible (ideally without VBA). Thanks, Sam

I use the pivot table function often and waa wondering if there is a way to have the format of the table like that of a normal database table, without haveing spaces for records with duplicate values. For example, this a a typical result for a pivot table:PivotCol1 PivotCol2 PivotCol3 USA...

I created a form combo box that filters data in a spreadsheet (Excel 2003) and would like the first value to be "ALL". When selected, all the values would be shown. This is the code that I currently have: Sub DropDown20_Change() Dim r As Range Set r = Range("DATASET")...

I created a form combo box that filters data in a spreadsheet and would like the first value to be "ALL". When selected, all the values would be shown. This is the code that I currently have: Sub DropDown20_Change() Dim r As Range Set r = Range("DATASET") r.AdvancedFilter...

Hi, I have a data set that I would like to create a percent of total on. the hard part for me is to create this with a break. The example below is a sample with territory number and units. The data is sorted by territory number (asc) then units (desc) I can get the PctOf Ttl column by...

We have just selected BO XI and possibly the dashboard manager for our reporting needs and need to develop a project plan for universe/report report development. Does anyone have a sample plan that we can use to build upon? Since BO is new to our organization and we are relativly new to the use...

Is it possible to use the Group and Outline funcitonality on a protected spreadsheet? We have a spreadhseet that needs to be protected and we want to add this functionality but I recieve an error that "You cannot use this command on a protected sheet. ect." Is there a way around this without...

This should be a simple one. I have created 2 buttons, each with the following macro: Sub ShowTab() ActiveWindow.DisplayWorkbookTabs = True End Sub Sub HideTab() ActiveWindow.DisplayWorkbookTabs = False End Sub I would like to change this to a check box for "Show Tabs" so that if...

Using Excel 2003... I have a pivot table that has a Row field for Territory. When I use the drop down menu, I see the territories that I can choose from. The problem is that I am seeing old values in teh dropdown list and I cannot get rid of them. The old values do not exist on the source...

Is there a way to grant select access to a schema without specifying the tables? I would want to grant access to a role, not user. I think that other DBMS can do it but was just wondering if oracle can. Thanks, Sam (newbie)

I have a Pivot Table and I want to create some derived columns. When I right click on the pivot and select "Show Pivot Table Toolbar", nothing happens. Does anyone know what is going on? I am using Excel 2003 Any help would be appreciated! Sam

I have a pivot table with the following format Reg Div M1 M2 ABC 100 10 20 101 20 80 102 10 30 DEF 100 10 20 101 20 80 102 10 30 I would like to create a 3rd metric that is M1/M2 Reg Div M1 M2 M3 ABC 100 10 20 50% 101 20 80 25%...

Is there a SQL sytax to strip out "bad" data from a column? By bad data, I mean tabs, carriage returns, and any non-printable characters. The Excel equivalent of the CLEAN function.