Pivot Table Cycling Through Page Fields Automatically
Hi. I am trying to cycle through a complete set of data in one of the
parameters in the "Page" field. For example, there are 500 investments, and I
want to compute the internal rate of return (IRR) for each investment based
on a series of cashflows for each investment.
The IRR is a function that is placed outside the pivot table. As each
investment number is chosen, the underlying pivot table cashflow data
changes, allow the IRR function to pick up these cashflows and compute the
IRR. However, if there are 500 investments, this becomes very time consuming
- especially if the...How to restore reports in CRM 4.0
I deleted all of the reports in CRM 4.0 from the GUI (using the X)
How can I restore these?
Try the command:
C:\Program Files\Microsoft Dynamics CRM Server\Tools>PublishReports.exe
"JamesE" <JamesE@discussions.microsoft.com> wrote in message
>I deleted all of the reports in CRM 4.0 from the GUI (using the X)
> How can I restore these?
Peter, I have already run this comand and the reports have been added to MS
Repo...Item Dynamic table size
I've been doing some cleaning in our HQ db on items that are no longer sold
in our locations. I've had success in deleting the appropriate items however
I noticed that our item dynamic table is quite large, over 2,000,000 rows. Is
there an sql script available to update the Item Dynamic table based on the
Items in the Item table? Thanks in adavance
This is a multi-part message in MIME format.
Bad idea to de...want to do piovt table, where rows over 100,000
i have around 100,000 rows of data...
of cousres the worksheet i can only put 66000 or so rows per sheet.
i want to do a pivot table that combines the two sheets.
how can i do this?
Message posted from http://www.ExcelForum.com
if you have that many data I would suggest you store this data in a
real database (e.g. MS Access). With Excel's pivot table wizard you can
then access this database as datasource.
Another way would be to split the data in two worksheets and within the
pivot table wizard choose the 'non contigenous ranges' for the data
Reg...pivot table #21
I have a question on Excel. When I update a pivot table,
I used to be able to hold down the shift and ctrl keys
and highlight the area, but lately I found that I cannot
use this short cut method. Is there another short cut
method? Thanks for your help.
In step two of the Pivot Wizard, you should be able to select a starting
cell on the worksheet, then hold the Shift key, and tap the End key,
then the Down or Right arrow key, to select a range of cells.
Or, base the pivot table on a dynamic range, which will expand
automatically as new records are added. There are instructions here:...Add a specific Record to a Table based on a check box
I have a Table called ServiceTypes. Based on a User's input on a
ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
For instance, I have a Check Box on the ProposalForm. When a Check Box is
clicked Yes, Access must search the ServiceTypes Table, select a specific
ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
How can I add the proper Service record from the ServiceTable to the
ProposalServicesTable based on the Check Box?
I wouldn't do it that way. I'd use a listbox (with multi-select set to YES)
that was sourced to the ServiceTab...transfer inbox in table format to word
In my older version I could cut and paste the table
format in Outlook to a word file. Now I don't seem to be
able to do it although I can print the file in that
format within Outlook. When I export the inbox to word I
get the whole text not just the headings. Is it possible
to transfer the table format to a word file?
...This query not giving correct results
I am trying to find the date when we had the most rainfall out of 3234
records, so with the first query to get the maximum rainfall in a month
I get 110 records with one null and one '0' value.
So this query is saying that out of 3234 records there has only been 108
days when we had rain. We probaly had more than that in one year never
mind in 10 years.
This cannot be right because we had 24 days of rain in November 2009 but
the query only shows 16 for that month!. So how does it actually work?
SQL for this below:
SELECT Max(tblWXDataLeeds.ReadingDate) AS MaxOfReadin...cannot view objects
Since 01/07/2005 I can't view objects in MS Publisher 2003. I could prior to
that. I haven't done any OS updates. Help!
Have you tried
View, pictures, detailed display...
Mary Sauer MS MVP
"Jay in Colorado" <Jay in Colorado@discussions.microsoft.com> wrote in message
> Since 01/07/2005 I can't view objects in MS Publisher 2003. I could prior to
> that. I haven't done any OS updates. Help!
Yes, thanks but it...Workflow rule on (Order)Products and columns of related entities in advanced find view
Does anyone know whether it's possible to create workflow rules on
(Order)Products, since the entity Products isn't part of the standard
In my example I have added a new (expiry) date attribute on the
Now I would like to add a workflow rule on that datefield to create a
task when the expiry date is nearly reached; but the problem I have is
that i can't "reach" the fields on the OrderProduct form to put a
workflow rule on?
Another problem I have is that I've created an advanced find query in
which I query customers who have or...pivot table -repeating "months or days" after grouping
I have data that includes the month, day, hour, min. When I run th
pivot table function to reduce the data to hourly I need the date t
repeat in the date column.
9/19/2002 0:00 2.7
9/19/2002 0:10 3.7
9/19/2002 0:20 3.8
9/19/2002 0:30 4.6
9/19/2002 0:40 4.8
9/19/2002 0:50 4.8
9/19/2002 1:00 5.6
9/19/2002 1:10 5.2
What I get when I group the Pivot table:
Sep 19-Sep 12 AM 2.7
- - 1 AM 3.7
- - 2 AM 3.8
- - 3 AM 4.6
- - 4 AM 4.8
What I want is:
Sep 19-Sep 12 AM 2.7
- 19-Sep 1 AM 3.7...Create interactive pivot table chart based on item selected
I'm trying to remember how to drag a chart object to the top left cell of a
pivot table thus displaying a charted image of the detail item selected. Any
...Access 2007 Reports
I'm using an Access 2000 mdb (split ends) in Access 2007. I cannot up-
convert because other terminals don't have Office 2007.
It works as a database just fine except:
When I try to change a (front end) report from the default printer to
another specific printer in design view, page setup, it all LOOKS good
except it does not save my changes upon return and goes back to the
I never had this problem with earlier versions of Access and the
specific printer in questions works fine with other apps and
Any ideas people? Many thanks.
This is a known prob...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to
SQL 2000) to ASP.NET(using store procedure in SQL 2000).
Finally, I tested them and found that ASP.NET is slower than Access.
The mojority job of program is select some data from SQL 2000 tables, modify
and then insert into some tables.
Is store procedure always fast than Access linked table via ODBC?
Message posted via http://www.sqlmonster.com
Stored procedures don’t add any overhead and they can save compile time.
It's the code in the stored procedure and the underlying tables / indexes
that ...Error in Detailed Sales Report
Have you encountered a strange scenario wherein in your shop you have sold 1
item in that particular invoice/receipt # but when it got connected and
process the WS401 and when you run the detailed report in HQ level , it was
added up with some items which is not in the original shop transactions.
Trx # item Qty
1023 apple 2
Store Trx# Item Qty
A 1023 apple 2
A 1023 orange 3
A 1023 banana 2
Which in the store A transaction, those items where not in that trasaction
but somehow when it was connected and process...Cannot stop using online services with First Tech Credit Union
My bank, First Tech Credit Union, recently upgraded their online banking
services. This upgrade also included a change to the user name and password
used for online banking in Money 2006.
Their upgrade instructions
(http://www.firsttechcu.com/help/help_guide_money.html) say to disable online
services for your Money file as the third step to upgrading to the new
services. The problem is that when I click on Stop Using Online Services in
Money nothing happens. I click on OK and Money hangs for a bit then comes
back with no change, clicking on OK again has the same effect, clicking on ...graph add ins for dials or dashboard reports?
I am trying to create some dashboard reporting at my company and cannot find
any addins for this purpose. Can anyone help ???
I've heard from a few people that like Charley Kidd's dashboards. I
haven't tried them:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I am trying to create some dashboard reporting at my company and cannot find
> any addins for this purpose. Can anyone help ???
...Create incident on website : localhost ok
when i open a new case in
it creates the "incident" normally
but when i open a new case in
Operation failed due to a SQL integrity violation.
System.Web.Services.Protocols.SoapException: Server was unable to process
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response,
Stream responseStream, Boolean asyncCall)
at System.W...Query Problem in Test.
I keep getting errors on the WHERE part of my query. I'm sure it's something
I don't know if you will need the whole code to see what the problem is. It
is lengthy, so I will start with just where the problem is.
Set rs = DBEngine(0)(0).OpenRecordset("SELECT T2.Distance, T1.* FROM
(Church AS T1 INNER JOIN qryChurchZip1 ON T1.ChurchID =
qryChurchZip1.ChurchID) INNER JOIN DistanceQuery AS T2 ON qryChurchZip1.Zip5
= T2.ZIPCode WHERE " & strWhere)
' See if found none
If rs.RecordCount = 0 Then
MsgBox "No Churches meet your crite...Creating a Check Box
I would like to learn how to create a check box. Is there
a way to do that?
The simplest checkbox (I think) is from the Forms toolbar.
So View|tool bars and show that Forms toolbar.
Click on the checkbox and then click on the topleft corner where it should be
placed. Then draw to the opposite lowerright corner.
When you've placed it correctly, right click on it and select "Format Control"
On the Control Tab, you can assign a cell link that you can use to determine if
the checkbox is checked or not.
=if(A1=True,"It's checked","It's not checked")
...odd files created
Every time I open and edit an excel spreadsheet on a
network share, small odd files get created. They are
usually no larger than 25-40k and don't have any
extensions to them. Looking at the properties page for
any file, the file description says File. Anyone know
what this is from or how to get rid of them? Permissions
are setup correctly for me, Word files don't have this
Excel 2000 SP3
A file the same size as the workbook would be created
in the same directory as the workbook. The filename
would be nonsensical (or appear to be random) character...Create Login with T-SQL
I am creating, using T-SQL, a database with its file groups, tables,
Can I also create, using T-SQL, a Login with Username and Password to
access that database?
Usually, I go to Security > Logins of SSMS to manually create the
However, if I could do the same using T-SQL I would have it all made
EVERYTHING that the GUI does winds up as tsql executions on the server. :-)
Most of them you can generate a script for using the Script menu in the
upper left of the current dialog window. This is a great way to ...Report Writer
I am trying to modify the Financial Trail Balance in Summary in Report Writer
in GP10 to have two separate columns: one that shows the ending credit
balance and the other column to show the ending debit balance. Also at the
bottom of the total for the debit and credit columns I need to show the
profit/loss that would display on an income statement. If possible provide
some details if they have every created this modified report or let me know
where I can find more information on generating these reports. Below is an
example of how the report layout.
Account Description ...Ad Hoc Reporting #2
I am putting together an ad hoc report in Excel. My query is in the VB
editor. I am trying to specify criteria
Select x,y,z where...
in the WHERE, I am struggling.
I want to take a range of ids specified in the worksheet, F2:F55.
Select x, y, z where IDs IN ( F2:F55 )
I tried to use WHERE IN ( Range(F2:F55) ) but it did not like it.
What syntax should I use to make this work? Thanks!