Reporting IRA distributions
I have an IRA account with corresponding cash account. I
am trying to get the distribution from the IRA to show up
as "Retirement Income" in the Tax-Related Transactions
report. How to do it?
The distributions are handled as a transfer from the IRA
Investment cash acct to a checking account.
Thanks for any help. Money 99, BTW. Do I need to
upgrade to a later version?
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Performance By Investment Account
I've been trying to analyze the return calculations that MS Money
provides in both the Portfolio Manager and also the Performance by
One curious thing that I've come across and had previously not paid
attention to is a feature in the Performance by Investment Account.
If you click on "Customize' for this report, under the "Rows &
Columns" tab there is a customizable setting called "Do not show
performance based on data of less than: xx days." It defaults to 90
Does anyone know if this feature actually does anything? I'v...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...How to split an account into two accounts
8 years ago I started my 403B and 401A retirement accounts with Fidelity
as a single account. It did not both me that the paper showed them as
two accounts and I should have fixed it sooner. Now that Fidelity is
allowing me to download the information it is clear that I should have
two accounts. However I have purchased 4 mutal funds every two weeks for
the past 8 years and now to split them it appears I need to move 2 of
these sets of fund transactionss to a the account. The move one
transaction at a time is growing old. Is their an easy way or to
accomlish a mass move of all transac...Report Can Grow not aligned horizontally
I have a report where I have 1 row of text, memo, number, and date fields.
The memo field can contain up to 4-5 lines of wrapped text. I have set all
teh rows to "can grow". However, on my report, the conditional formatting
For instance, the fill (which I have set to a gray color) in the memo field
is about 3 lines deep when there is a lot of text in the memo field, but the
text and number fields associated with that record are actually only 1 line.
This essentially looks like a mess, small gray filled boxes for the text
fields and a large gray ...Custom reports #3
I want to pull a report on how many customers I am getting
every hour of the day. Does anyone out there know how to
do that? I can try writing a query if someone can tell me
which table I can find this information in (timestamp,
transaction etc). Any help is appreciated.
This info is given at the end of the Z report.
If you want to use it in a query open the Z report
recipt file using the Notepad and see the fields that
are used... Report.Hour.HourSales etc...
Hope this helps...
> I want to pull a report on how many cust...how to run onhand value report
I get the message enter parameter when entering the zoom feature
On Sat, 6 Mar 2010 17:36:01 -0800, junebugg
>I get the message enter parameter when entering the zoom feature
You'll have to give us some more context than that, junebugg. What's the
"onhand value report"? What's the "zoom feature"?
You can see your database; we cannot!
John W. Vinson [MVP]
...Shared email account
I am new XP user. I have set up separate XP accounts for me and for my
wife. I would like to have both of us to be able to use the same Outlook
email address. How do I set up Outlook so that the 2 XP accounts look at the
same Inbox, Sent Items, Address Book, etc.?
Locate the pst-file for the account that now has all the e-mails in it.
Move the pst-file to a location both can reach (for instance C:\Outlook)
Start Outlook fot that user and it will prompt you for the new location.
Once configured close Outlook for that user and logon as the other user
Open Outlook and choo...Frx and "invalid procedure call or argument"
I am running Frx 6.7 in a TS environment.
When I generate a report (using 'Financial and Account' detail level)
the report generates to DDV but if I try and drill down to any lines detail,
or export the detail to excel then I get an "invalid procedure call or
This problem exists for all of my 12 reports I have tried.
I have checked my column headings and these do not overlap or have reverse
I resolved this myself - it was due to the option 'Sort GL Accounts By'
being marked on the Report Opti...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...Report: Cell #1, Cell #2, Cell #3, Cell #4
I am stuck again and would love som help :(
I would like to repeat all words found inside ~25 cells, separated only
by ", ", ignoring empty cells.
A1: [Apple ]
A5: [Syrup ]
A6: [ ]
A7: [ ]
A8: [ ]
The result should be something like:
[Apple, Orange, Banana, Tomato, Syrup]
JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945
View this thread: http://www.excelforum.com/showthread.php?thre...Admin Account
Why do I see my administrator account logging on to every
mailbox in the Event Viewer when I reboot. Also, the login
list shows my admin account logged into many mailboxes. Is
"Myrick" <firstname.lastname@example.org> wrote:
>Why do I see my administrator account logging on to every
>mailbox in the Event Viewer when I reboot. Also, the login
>list shows my admin account logged into many mailboxes. Is
Probably because you've got some sort of software that's accessing
those mailboxes (like some AV software might do), and it's runn...Departments on Z Report
I have noticed that as I set up new departments and
categories into the database, the new departments are
always printed last...or below all of the other
departments. Is there a way to change this, and possibly
have them organized alphebetically or in an order I would
Perhaps if you modified the department table usinfg Microsoft Access 2003
.... not that I would advise that :-)
Vince... is this you... my buddy?
Since you don't use an email address... I'm never sure if it you... and then
I worry I'm getting too personal with someone I don'...How do I assign a name to a PDF report via VBA
Thanks to the internet site:
I have the following subprocedure:
Private Sub Print_to_PDF_Click()
On Error Resume Next
Dim reportName As String
reportName = "HCBS CMgr Smmry Report"
DoCmd.OpenReport reportName, _
Set Reports(reportName).Printer = _
DoCmd.OpenReport reportName, _
This appears to be a good start; however, it stops and
waits for me to enter the n...How can I count unique values in a query in the report footer 12-16-07
I have a report that gives me the count of the status of individuals . This
works fine as long is there is only one record in the query (in my query
there is one record per month). When I query 12 months (individuals may
appear in various months) it counts each record of an individual. For
Example in a query considering 12 months for a widow Jones it may count her
12 times and for a survivor named Smith may count her 8 times:
I would like to add a count in the report footer that will tell me how many
unique individuals I have in the report (Example widows: Tot...PM Purchase Account
When running a Payables Transaction Smartlist the Purchase account column
pulls the information from the Vendor card. Is there an option to have the
list pull the PURCH account from the transaction? I can't seem to see an
available column that will give that information.
Nope. That would require creating a customer SmartList in SL Builder
or a report in Crystal or SSRS.
MCP-GP, MCT, MVP
East Coast Dynamics
get your GPtip42today at www.gp2themax.blogspot.com
On Jul 27, 9:19=A0pm, "Frank Hamelly, MCP-GP, MCT, MVP&...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...Bulk Edit Parent Account
I seem to have the problem of not being able to bulk edit parent accounts in
CRM 4.0. I have tried to follow the instructions for fixing this in 3.0,
http://support.microsoft.com/kb/933898/, but the lines they have you change
are not in the 4.0 version of the account entity xml file. Is this a known
bug in 4.0 and is there a fix?
...printing problems with memorized reports
We have recently been running into printing problems with our memorized
reports. We will print preview a report and it will look fine on screen,
then we will send to the printer, and the report print extremely small in the
corner of the page. However if we go back in and re-print the report then it
will print normal size on the page. We are not making any settings changes
at all, and when it does this appears to just be at random. We are printing
to an HP laserjet 4000 series printer that is on our network. We've used RMS
with the same configuration for approx. 5 years now and ...Reports and sub-reports problems
Dear Sirs,I have a report with 4 sub-reports.How can it be that 2 sub-reports are showing the data triple.Can someone help?ThanksKlaus I just realized. It's not due to being a subreport - it's already showing on the normal report triple data. It was not before and I did not change anything. I hope that someone can help me.Thanks Klaus"Amateur" wrote:> Dear Sirs,> I have a report with 4 sub-reports.> How can it be that 2 sub-reports are showing the data triple.> Can someone help?> Thanks> Klaus...multi-company FRx reports
in FRx 6.5 and GP10, if company A and Company B have the same COA structre,
can I create a report pulling data from both company databases and create a
consolidated financial statement? Can I combine both the budget and actuals?
Yes, what you're asking for is exactly what FRx does. If you are just
starting out with FRx, I highly recommend a little training. An hour or two
is typically enough for most users to be off creating their own reports.
A little surprising to hear you say that you're on FRx 6.5 with GP 10.0 -
the current version of FRx is 6.7 and ha...