best use for x,z and zz report
now we are using z report for end of day and zz report for end of month (x
report just to get hard copy of inday sales)
is thier a better or more usefull way to use this three reports?
Hi Bacha11....you describe what most RMS users (I believe) do with the X, Z
and ZZ reports - if you have multiple shifts (example a morning shift and a
afternoon shift) on your registers you could use the X and Z reports for
shift reporting and the ZZ for end of day (it will include both Z reports
from both shifts) - other than that I think you're good to go....
"BACHA11" wrote:...Generating report in Access
Is there a limit of length of the report? I can't make it longer than 21 inch... :( You have paper longer than 21 inches? Are you trying to fit everything onone "page"?You should be able to use as many pages as you need to fit it all in.-- RegardsJeff BoyceMicrosoft Office/Access MVPhttp://mvp.support.microsoft.com/Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/Microsoft Registered Partnerhttps://partner.microsoft.com/"Yue Zhao" <email@example.com> wrote in messagenews:eKf7l8YYHHA.944@TK2MSFTNGP06.phx.gbl...> Is there a limit of length of the re...Antivirus on CRM
We are using Symantec Antivirus Corporate Edition on our network. Do we need
to set any scanning exclusions on the CRM server so it does not impact
That is a great proactive question. You dont want to scan SQL databases and
If I recall certain INetpub folders. Check Symantec knowledge base for exact
files/folders to exclude.
> We are using Symantec Antivirus Corporate Edition on our network. Do we need
> to set any scanning exclusions on the CRM server so it does not impact
...Am I supposed to see the OUTPUT parameter's value in SQL Mgmt Stud
I have a stored procedure with an OUTPUT parameter. When I execute the
procedure in SQL Server Mgmt Studio, am I supposed to see the OUTPUT
I'm troubleshooting an issue and at this point I'm not sure if it's the
application code or the stored procedure. When I execute the stored
procedure, it does what it's supposed to do i.e. insert a new record, but I
do not see the value of the output param -- unlike when I return values
through a SELECT statement. Is this normal or am I supposed to see the value
returned by the output param?
-...Number Records by group in Report
I would like to number or rank records in a report by grouping. The
ranking or numbering would be based on the lowest time. I have a field
of [HandleTime] in "nn:ss". The groups would be based off a
Any Ideas. I have looked out numbering them in a query, but that does
not help for the groupings.
Add a text box to the Detail section, and give it these properties:
Control Source =1
Running Sum Over Group
This assumes the Sorting And Grouping box is sorting by the times within the
group, and you don't have to show 2 identical times as...CRM Customization 12-17-03
I have just started evaluating Microsoft CRM for our business, but one
critical need is probably going to require some customization to
interact with our existing home grown CRM database that handles
ecommerce and tracks customer software downloads. We are .NET
developers ourselves, so that shouldn't be a problem. However before
I dig too deep, I'd like to know if the following is possible in MS
1) Can data be synchronized with with another SQL database? For
example could we integrate the sales data in our eccommerce database
with MSCRM? It would be nice if we could sched...SQL 2008, problem setting Identity Specification
I'm trying to set an IdentityColumn on a table. But I get the following
error when I try that
"Saving changes is not permitted. The changes you have made require the
following tables to be created and re-created. You have either made changes
to a table that can't be re-created or enabled the option Prevent saving
changes that require table to be re-created."
I have never seen this kind of error in pervious version of SQL. I am the
db_owner on this database.
What am I doing wrong?
Such operation requires re-creation of the table and the ...Permission Error in CRM Web based Application
hello. When I click tabs in Navigation Bar on the bottom of Microsoft CRM Web
User Interface (v 1.2), usually I get the following error.
Error: Permission Denied
This is not stopping me from working on CRM instead i can use menu bar GoTo
--> Home (or other), meybe you can help me to solve this problem, wating for
I found another post about this problem and the answer :)
"Osvaldas T" wrote:
> hello. When I click tabs in Navigat...slow money report
Am running win xp and money 2007. My monthly reports has crashed. When I
click on the report, it searches for changes in the monthly data, etc, but
then "hangs". I think this is what is slowing my computer; my computer's
processor is running something in the background causing everything to be
slow: my browser, money, etc.
How can I correct this problem in money? Have tried to reinstall money
without success and reset my computer to an earlier date again without
Have you tried any of the File | Repair methods?
"Curtis Glenn" <CurtisG...CRM 1.2
Is it possible in CRM 1.2 to do one of the following when an account is
1. create a new case
2. run a process created under Cases ?
...Error when tracking in CRM
When tracking (in CRM) an email in outlook the folowing error occurs:
An error occured promoting this item to Microsoft CRM. The Microsoft CRM
could not be contacted or the user has insufficient permission to
perform this action. Do you want to send this e-mail? If you click Yes, the
e-mail will be sent out, but no corresponding activity will be created in
Thanks in advance,
...'My' CRM Views
Is there a way to create a public view similar to the 'My' views that in
addition to displaying records owned by the current user, will also include
any records that have been shared with the user?
Thanks for posting in. This is Ken in Online Partner Support.
Unfortunately, I couldn't find the way to include "sharing information" as
Microsoft Online Partner Support
PLEASE NOTE: Th...Weird lines showing up on query, report & table printouts
I'm using Access 2007 and everything was working fine. Then all of a sudden
it started printing very small grid lines in the upper left corner of every
page of any query, report, or table printout. Everything looks fine in print
preview but the lines keep showing up on the printouts. I found one website
where another person described the same problem (it was posted in 2006 so was
probably for an earlier version of Access) but there were no suggestions
given as to what might have caused the problem or how to fix it. I've tried
rebooting the computer, using earlier backup v...Display Report Options in Alphabetical Order/Rename Report Options
Display Report Options in Alphabetical Order in the Report Options Window
For example, when the Trial Balance Report Options window is open, the drop
down list of report options appear to be in the order in which the reports
were created, making it difficult to navigate to find the desired report
option, especially when many options have been created.
Would also like the ability to rename a report option.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
A...MFC AND Visual C++ 2005 Express Edition ?
Can I use MFC with Visual C++ 2005 Express Edition ?
If yes, How ?
Thank you beforehand for your answers,
The Express edition does not include ATL or MFC :o(
"Dominique MOREAU" <firstname.lastname@example.org> wrote in message
> Hi everybody,
> Can I use MFC with Visual C++ 2005 Express Edition ?
> If yes, How ?
> Thank you beforehand for your answers,
...Report crashes when there are no records
I have a command button that uses DoCmd.OpenReport... etc... to print a
report in preview mode. The report's record source is called qryData. On
occassion, this query has no records, though I don't know this when I click
the command button. In this case (no records in qryData) the program hangs.
How can I prevent an attempt to print when there are no records in the
You could try code like:
If DCount("*","qryData") > 0 Then
Otherwise most of us would place some code...excel formula to convert server time in seconds
I extracted data from my server. It keeps a log of time like this
1069255091 (this morning)
I converted the data into excel but now I need this cell value to b
the actual date and time.
Any one have the easy answer
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
format result as
"frogman1001" <email@example.com> wrote in message
news:frogman1001.x5hub...Standby Backup of a CRM 4 / SQL 2005 server
I have 2 server machines of identical specs. Each one has SQL
server 2005, and CRM 4.0 installed. SVR1 is our production server and
is the Principal server for SQL mirroring, while SVR2 is our standby
backup server and is the SQL mirror. During the installation of CRM
Server on SVR2, we pointed it to an existing CRM installation (on
SVR1). We are NOT using load balancing, or clustering, etc.
Note1: In CRM deployment Manager, both servers are enabled, both have
the role of CRM server, but only SVR1 has the role of SQL Server. I
believe that since CRM SVR2 was pointed to SVR1, th...How best to handle non-CRM user email address for campaigns, track
We running 4.0, and are interested in taking advantage of some of the new
email campaign features. We'd like to send out these emails from an email
address that is not necessarily the CRM user's primary email address, or goes
to a different inbox. How can we do this?
We are finding this need quite a bit. For instance, our customer support
team would like to track emails to and from firstname.lastname@example.org
instead of their own primary addresses, but can't figure out how to do that.
we are running CRM 4.0 with the CRM email router service running on our
exchange serv...CRM 3.0 laptop client
The error below appears in the CRM 3.0 laptop client regardless of what CRM
item is selected (i.e., Sales, Marketing, New Record...)
The problem only exists for a single user (right now we're only testing it
on two machines) using the laptop client. For this user, on this machine,
they are able to use MS CRM successfully using both the web client and the
How exactly does the laptop client work? Why is it trying to compile on the
user's laptop? We noticed that the "nostdlib" switch does not have the "/"
preceeding it which seems to be the r...Outlook Changes Incoming Server to "localhost"
For some reason, Outlook 2000, on three different machines
here, randomly decides to automatically reconfigure
account information to "Incoming Mail: localhost",
and "User Name: your.name/mail.ispname.com".
I had thought it was because I use a Spam front-end filter
called POPFile, but now it's happened to two co-workers.
Anyone know what gives?
In article <email@example.com>,
> For some reason, Outlook 2000, on three different machines
> here, randomly decides to automatically reconf...Outlook Express 6
For some unknown reason, my OE6 'forgets' to Leave Messages On Server
about once a month or so.
I have not scientifically analyzed just when it happens, but the check
box under Tools/Advanced somehow unchecks itself (!) periodically.
Is this a known fault, or is there a workaround to keep it from
happening, if anyone knows?
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.publi...Outlook 2003 causes my Exchange server 5.5 to hang
I'm running exchange server 5.5 on a windows 2000 server
sp3. My clients are running outlook 2003 on WinXP pro
See the Outlook 2003 Rules May Halt Exchange 5.5 topic on the home
page of http://www.slipstick.com/
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
"Scott W" <firstname.lastname@example.org> wrote in message
> I'm running exchange server 5....CRM toolbar visible but not responding
We recently switched to Microsoft CRM 3.0 from Goldmine and since then,
I have been able to see the CRM toolbar in Outlook but the menu and
icons do not respond when I click on them.
I tried uninstalling and re-installing the client which worked until I
Any other ideas?
If you could verify that the IE client works on the same box as your Outlook
installation, that would at least let us know if the issue is on the server
or a possible client install issue.
If you can access the server using your current credentials and navigate
around the web application, then you might try t...SBS 2008 Second Server and Updates KB972493
I have a SBS 2008 with a second Server 2008R2 on the network.
Recently I noticed that the second server was coming up with Warning under
the Update Status, it seems that the WSUS wants to install KB972493 on the
server, but I don't have WSUS installed on the second server.
It's more annoying thing, but it would be nice to either figure out a way to
install it or remove it.
On Jul 6, 6:27=A0pm, Kev <K...@discussions.microsoft.com> wrote:
> I have a SBS 2008 with a second Server 2008R2 on the network. =A0
> Recently I noticed that t...