Report that display percentage below certain level
I got a spreadsheet contain inventory number from remote site. I need to run
a report to display when inventory below a certain percentage. I try to use
privot table to display the infomration. But it doesn't display everything
below 40%. Is there anyway you can enter an percentage and display all
remote site that below certain percentage (Eample: like 35%) on a report?
A pivot table groups like items, and makes a calculation on each group --
not what you need. You need a filter (Excel's way of saying "query" in
database parlance). If your table...Problem of viewing the text in Visio 2003
I've a visio 2003 doc with most of the texts in font size of 6pt or
5pt. I setup to 150% zoom to view it. It has no viewing problem so
far. However, when I open up the doc today, all the texts are
displayed like a rectangular block. I can't see each character at
all. Only the text in 10pt or higher can be display correctly. Or if
I increase the zoom to 300%, then I can see the texts. And I found
that all of my docs have the same display problem. Can anyone help?
With me it works.
Has the font changed, or the display settings in the control panel ?
Changing ...printing transparency problems still
In a previous post, said publisher has problems with transp.
Would installing a new graphics card cause a problem.
I tried using the transp. on pictures, and it still gives me the problem.
It is alright till I go to print. In print preview looks fine, I haave the
printer set up to have a separate print pre view,
when it does that, you can see the picture is going to be blotchy. I have
unstalled and reinstalled the drivers, without any luck.
Would it be the printer or the program?
Trying to figure this out where I did not have the problem before. Could
their be a setting in publisher I have...Inventory Turnover Rate reporting?
I'm looking to get my stores Turn Rate for various departments and am doing
this by using Annual COGS / Avg value of Inventory (same 12-month period).
The COGS figures are easy to get from w/in RMS using several of the sales
reports w/ some filters applied, however the avg inventory value seems like a
bit of a challenge...I can see my current inventory value based on the # of
items currently in stock and their cummulative cost -- but don't see any way
to get this as a historical figure...any ideas? Anyone else have a better
way of calculating Turn Rate w/in RMS?
...Sheet name problem
while i was renameing a sheet as n1 it was coming as N1. ANYONE KNOWS
THE REASON FOR IT
Message posted from http://www.ExcelForum.com/
Did you have the caps lock on or hit the shift key by mistake.
Can you reproduce it in another worksheet?
"gmangad <" wrote:
> while i was renameing a sheet as n1 it was coming as N1. ANYONE KNOWS
> THE REASON FOR IT
> Message posted from http://www.ExcelForum.com/
...Working directory problems
My application runs from C:\Program Files\Superna\ConfigNet\Bin (a.k.a Bin
My shared dll are in C:\Program Files\Superna\Common Files (a.k.a
CommonFiles Directory) directory.
My application dllz are in the Bin Directory.
My application uses dll files both from my Bin Directory and my CommonFiles
My application shortcut exists both in Start->Programs->Superna and on the
User can doubleclick an nfg file so the application will run and load the
nfg file (my network file).
In order to support this behaviour I did the following...Printer problem
I am running a Brother HL-1230 printer from a computer under Windows XP
Professional. Nearly every time I send something to print, the lights flash
as it receives data and then the lights go out and nothing happens. The
second attempt is always successful. I have re-installed the Brother
printer driver. Any ideas what is going on and how to get over the problem
Bill R wrote:
> I am running a Brother HL-1230 printer from a computer under
> Windows XP Professional. Nearly every time I send something to
> print, the lights flash as it receives d...Calender consolidated report
There is requirment from one of our user.
He wants to calculate how many hours he is spending only attending the
meetings. He wants to get consolidated monthly or weekly reports like
that. Is there is any way or tools available???
It's possible to export free busy using getfreebusy method, but even
with this it cannot distinguish whether the user was not available due
to meeting, vac etc.
James Chong (MVP)
MCSE | M+, S+, MCTS, Security+
On Apr 12, 7:34 am, "RANG" <hair...@gmail.com> wrote:
> There is requir...VBA problem to open a file which is allready opened
After a horrible nights sleep, caused by spooky VBA macro-gosts that
are harassing me and chasing me through the bright and flowering fields
of Visual Basic and into the dark woods of soul-searching lack of
VBA-qualifications, I have no other choice than ask You to conjur one
of these small devils in mind, by helping me solve my VBA-problem:
I try - and manage (hurray!!) - to create a macro that copy a specified
range from one workbook, then open a specified new one and finaly paste
the data (pluss - of course - do some other stuff) into this
My problem i...Reporting services update automatic data?
i need to know if a report wrote in VisualStudio.NET for CRM automatic
updated the information? In Crystal i remember, have 2 options when save a
report and one of them, not updated data.
And one more question?
How add my report to reports menu in opportunity form?
Thanks for any help.
> i need to know if a report wrote in VisualStudio.NET for CRM automatic
> updated the information? In Crystal i remember, have 2 options when save
>...Hyperlink to child report is LOCALHOST when exported to Excel
We have a report that has a link to a child report for each row. We used the
"Go to report" for the field's Action. Everything works fine through the
browser. However, when we export this to Excel, the links turn into
http://localhost.. which does not work for the user.
How can we fix this?
...Purchase Advice Report with SOP exploded through BOM
Does anyone have info about a Purchase Advice Report that includes components
of Bill of Materials that are generated by Sales Order Processing finished
Thanks, Dan Lapp
I am having a major problem with these two lines of code in my otherwise
great reporting tool:
These 2 lines freezes up my computer to the point that I can't use any other
application on my computer. It takes forever (over an hour, the last time I
let it run complete) to calculate one sheet in the workbook. I need to find
out if there is another way to get this done faster.
Any help will be appreaciated.
There's no need to select the worksheet in o...Problems with Outlook 2000 after upgrading to Windows XP SP2
Hi everyone. We have been running Exchange 5.5 with
Outlook 2000 clients on Windows 2000 and Windows XP
machines for a few years. Everything has always worked
perfectly. We recently upgraded a few machines to Windows
XP SP2 and noticed problems with Outlook 2000. Outlook
2000 installed on a Windows XP SP2 hangs all the time when
exiting. When I close Outlook 2000 on one of these
machines there is a 50-50 chance that it will exit
properly. When it does close properly you have to hot CTRL-
ALT-DELETE, choose Microsoft Outlook (listed twice for
some weird reason), and click END TASK. Cli...connection problems after returning from screen saver
When I leave Outlook 2002 running in Windows XP, and
return to the logon screen, Outlook times out while
checking for new messages.
I have 2 email accounts setup. One is Hotmail the other
is Verizon.net. The hotmail account goes offline and the
verizon account can't connect to the server.
To solve this, I have to exit outlook and restart the
Any ideas what is causing this and how to fix it?
...problem in opening excel 2003
hi, myself Debashis
whenever I am opening excel 2003, it is opening having rows in right side
and column number starting from right side of all sheets.
but if I create the file first, as like new> New Microsoft Excel Worksheet,
it is opening normally
thanks in advance
Set left to right.
Gord Dibben MS Excel MVP
On Fri, 26 Dec 2008 11:48:46 +0530, "Debashis" <firstname.lastname@example.org>
>hi, myself Debashis
>whenever I am opening excel 2003, it is opening having rows in right side
>and column number s...Error in report pls help
I receive an error msg "Microsoft Access can't find the field 'unitweight'
referred to in your expression" allthough the field is there and belongs to
the record source.
When I run the sql query which represents the record source I can find all
the records and fields and nothing seems to be wrong?
Inside the report I refer to that field 'unitweight' inside an expression
from the detail 'on print' event.
Can anyone help me pls?
If you don't have the field used on the report then Access will not be
aware of the fie...Logon Problem
have microsoft windows xp professional version 2002 /
network setup; my station is administrator; cannot open
microsoft outlook; error is called "Personal Address Book
Logon" which says, Your Personal Address Book could not
be opened. The file is either not accessible or is not
personal address book. Please advise. Thank you.
...Exchange Categorizer Problem.
I've read many usenet posts and websites regarding this problem, and
from what i can figure out, its a problem, and there are many
solutions for it, but no one solution. I have tried almost everything
to figure out this, so I'm posting here in hopes someone will know
whats causing it.
First, the problem:
Some emails are getting stuck in the categorizer (see below),
particularly for one user, but it is happening for other users. Not
all emails for this one user have the problem, are there is no rhyme
nor reason that I can see.
It is not:
a) Any particular destination (multiple emails s...Automating a report
Can you do a .bat file to schedule a report to run at specific time?
Owner wants to come in in the morning and have several reports already ran
and waiting for him.
Amy, I cannot speak to a batch file, but take a look at a program called
"Quick Macros" (http://www.quickmacros.com). I have a customer that uses
this program to run a macro that will run reports on a schedule and print
them, so they are waiting on him when he arrives in his office. Program
license is 40.00 and updates are free.
> Can you do a .bat file to schedule a rep...Mailbox Move Problem
I have two Exchange 2000 servers in a Windows 2000 domain. I used Active
Directory Exchange Tasks to move a mailbox from one server to the other. I
archived the mailbox so that it would be as small as possible to move. The
wizard said it moved the mailbox, no problem - seemed simple enough.
However, when I try to access the mailbox by setting up a new profile to the
new server, I get an "Outlook cannot open the folder" message and it does
not open up the mail store. If I use OWA as a quick way to check the mailbox
(\\server\exchange\username) I get a "Page Cannot Be Displ...How to add field to report from the bound table?
I have report (data source is table) when i built report i selected specific
fields as usual,now i need to update report and add one field which is in a
bound table, but it wasn't selected initially,
I set in the property window Control Ssource to a field in the table, but
when i try to print report it shows "Enter Parameter Value" and show
since report fields doesn't have this particular field How can i add field
from the table (data source for the report)?
First, the field you want to add must be in the table or query that is t...copy&paste problem
good lord, after 7 years of using MS Pub 2000, today it will not copy and
paste between pub documents.
i can open a new pub blank, draw a text box, type some text, copy that text,
open another new pub blank, draw a text box, and it will not paste the
copied text into the new doc.
it won't copy objects, pictures, old stuff, new stuff, nada.
i was going to restore with my office 2000 cd, but it said it was service
pack 1, and i knew we've been on service pack 2 for quite a while.
any suggestions would be appreciated.
What happens when you try?
A full install of Microsoft Office 2003 with Business Contact Manager
will fail when opening Outlook 2003 for the first time with an error dialog
Object Reference not set to an instance of an object.
Contact Business Contact Manager Support.
When this error-dialog is dismissed, a "Serious Error" dialog will be seen
indicating a problem with the Business Contact Manager.
When that dialog is dismissed, another dialog will be seen indicating a
problem with Microsoft Outlook itself.
If Norton AntiVirus is installed, another dialog will ap...Outlook 2002 Coonection Problem
I used outlook 2002 from the day it was available in the
market. It worked like a charm! However, about a week or
so ago, my Outlook fail to connect to my Exchange Server.
So, I deleted the account added with the hope of fixing
the broken links or to refresh the connection. So I added
the Name of Exchange Server and the Username and clicked
on Check Name, then it came up with cannot connect to
Exchange Server. To date, I have tried several things but
Two of my collegues are having the same problem. But for
others Outlook works just fine, so its definitely not the