Delaying date & time stamp in a long form
Operating System: Mac OS X 10.4 (Tiger)
I have a form with several pages. Each page is used for part of an interview. When I start using Page 1, a form field automatically fills with current date and on all subsequent pages, the field fills with the same current date. But I want each page to fill with the current date/time when the interview actually reaches that page and not with the date/time when the interview began. For example, I might not get to Page 4 of the interview until some 30 minutes have gone by. <br>
Does this call for a macro to ru...Hello
When logging onto Great Plains on the server itself, the following prompt
appears before getting to the logon screen:
Dictionary '\\<Servername>\GPShare$\Reports.DIC' needs to be upgraded. Use
Dynamics Utilities to update your modified forms and reports.
When you click OK, another prompt appears:
Dictionary '\\<Servername>\GPShare$\R1058.DIC needs to be upgraded. This is
not a compatible version of cashbook.
Clicking OK clears the message and you can then logon.
Question is - I have logged into GP Utilities and seen the option to 'update
modified forms...Reporting Question
Good afternoon group,
I am trying to create a competitor matrix type report using Crystal
Reports. I have added some 40 picklist schema items that I would like
to pull into a grid. I would like to report on the Yes/No/Null values
for each of our competitors. So far I have not been able to find a way
to accolmpish this with Crystal. Idea? Has anyone done something
similar and if so how was this accomplished?
with the right paper size you you could do this line by line with the
competitor name on the left then the 40 fields alongside.
you do not need a specific grid for this, simply report on...Report Writer Problem.
When I print a document to the screen and then click on the modify button I
am getting an error message.
The dictionary (Microsoft Dynamics GP) for this report or the report(852)
itself is missing. I can go in and call up a report using the traditional
method but I am wondering if I have a problem with the dictionary.
Do you have write permissions to the directory where the dictionary file is
to be created (If this is the first modified report for that product) or do
you have this permission to the dictionary itself if the dictionary already
"Tom Shoote...Report Subscriptions V3.0
I am trying to schedule CRM reports to run under SQL reporting services.
However when I try to Subscribe to the report it will not allow a
subscription because the username and password credentials are not stored on
the server. If I edit the data source to give it credentials (either
Administrator or User credentials that have access to the reports through the
CRM the report gives a login failure.
I have tried the report scheduler wizard for the CRM and it seems to fail to
save the definitions.
The end result I want is to be able to send an email containing a current
CRM V3.0 report o...Preview report from a subform
Is it possible to preview a record by clicking on it in a subform?
I have a form: NonCompliance on which I have a subform to view all
NonCompliance records. At the moment I ‘m using a button to preview using the
ID number of the record to select the record to preview.
Subform fields are ID, CompNo, Class, Date all from Table;tbl2Non-Compliance
Any help would be greatly appreciated
>Is it possible to preview a record by clicking on it in a subform?
>I have a form: NonCompliance on which I have a subform to view all
>NonCompliance records. At the moment I �m using a...Problem with a continuous form
I am developping an application in VBA with Access, and I created a
continuous form, to display data coming from a table.
In the form, each line displays data about a project, and each line
has 4 checkboxes at the right, to allow parametrization of the
My problem is that when my form is displayed, I get logically one line
per project (and that's ok), but I also get an empty line displayed at
the end of the form (all the fields are there, but no data on them).
And moreover, when I click in one of the checkboxes next to this empty
line, another empty line is created. And...Reporting Services help!!!!
Need help really bad. I'm trying to install the Reproting Services Designer
for VS 2003 on my clien that comes with CRM on the Server Disc. I'm getting
an Error when i download a report and hitthe data tab it says "error provider
cannot be initiated" can anyone help please
I'ts annoying but the data connection can be buried in the rdl file. You
need to view the rdl file (the report) as xml by choosing view code and find
the data connection information. Once you find it, add a data connection
with the same name to your report. (very weird but it ...Reporting Services has no reports
I cannot see any reports in CRM.
We're running SBS 2003 Premium R2 with CRM 3.0 running on this server.
The SQL databases and reporting services are installed on a separate
2005 SQL cluster.
I've checked that reporting services is running on the cluster.
http://<sqlcluster>/reports brings up the SQL Reporting Services and a
folder entitled "CompanyName MSCRM" which is empty. How do I determine
the physical location of this folder?
I've checked in deployment manager on the SBS and CRM Reporting
Services is pointing to "http://sqlcluster/reportserver". Is...Access 2003/2007 Form Hang
I inherited an Access 2003 application (app and DB are separate
files). In my quest to perform requested application updates (removing
all references to Social Security number, etc), the application now
hangs on one of the forms tabs. There was no reference to the now-
removed SSN information. If I somehow manage to avoid clicking in a
field in one of the other tabs, the tab can be accessed (viewed) and
then another tab selected. However, if I've clicked on a field in
another tab, or if I select the problem tab and then click on any
field (date, for example), then I can no longer exit the ...Matrix Items on hand AND sold report
Does anybody have a report that shows all my matrix items (grouped by
matrix) with their on hand quantities AND their quantities sold (during a
certain time period)?
hi Alex, I have one but not on hand but it is sales invoice report. Let me
know if you need.
> Does anybody have a report that shows all my matrix items (grouped by
> matrix) with their on hand quantities AND their quantities sold (during a
> certain time period)?
Akber, I'm basically looking for the report that's in the report library on
customer and is ca...Reported corrupt backup file
I always backup at the end of each session to an internal
100MB Zip Atapi drive. I have been doing this
successfully for several years, and on each reformat or
reinstallation of Money (Version 2001), I have had no
problems at all in rstoring the backup.
I recently had to reformat my hard drive, and on trying
to recover the backup rec'd the message " The file
I:\............Is either corrupt or not a money file.
I have tried sending other files to the disc (Excel File)
and have no problem opening it from the said disc.
Any suggestions, as the backup covers 8 - 9 Years of
I have a problem with stretching my background images in Reporting
Services reports to fill the entire background canvas. As it is,
images that are smaller than the canvas only sit in the upper right
hand corner, thus not filling the entire background. I do not wish to
repeat the images, but rather stretch them to the correct size.
Any experiences anyone?
...Loan Accounts in Reports
Bugs are in reports, the loan that I pay to my car is
divided in 2, principal and interest, but in reports I
can't show the two at same time, the reports show only the
interest that I'm paying.
The budget have the same problem with loans, it shows
values that don't exists, I start a new budget, put all the
values correctly and finalize it, when I go to budget home
there are values that I not put there.
There is some fix to those bugs?
...Crystal Reports export to Excel
Crystal Enterprise is the web-based front-end server which displays
stored/linked Crystal reports to my target audience. I use an export
function that sends the report data to a .csv file so my users can open and
manipulate it in Excel. The file I'm trying to create MUST maintain the data
types of the underlying data fields, but currently is not retaining leading
Leading zeros in various fields (ID#/SSN, Zip Codes, etc.) are not
recognized and retained by Excel because it seems the incoming field data is
seen as numerical instead of text. Using known pre-Excel formatting ...How do I add an active URL to a 2007 MS Word form text field?
How do I add an active URL to a 2007 MS Word form text field?
The short answer is that you don't. These are 'text' fields. What exactly
are you trying to achieve?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> How do I add an active URL t...Report Session Expired
When running a report in CRM and "drilling down" to another level, I receive
the following error message:
Report Session Expired
The current report session has expired. You need to reopen the report.
Has anyone else experienced this problem?
...SQL reporting issues, help!
I have at one client an issue with reporting.
SRS is installed on the CRM server and SQL server is seperate.
I can get CRM reports and the following from the CRM server but not from any
The error recieved is:
An error has occured during report processing (rsProcessing Aborted)
Cannot create a connection to data source 'CRM'. (reErrorOpeningConnection)
Login failed for user '(null)'. Reason. Not associoated with a trusted SQL
Does anyone have any ideas???
Have looked around new...Form Appears Blank
Had to delete my profile and start afresh because of corruption...
The custom form I've created for my contacts appears as a regular contacts
form even when I go and select it from my Personal Forms Library. I'm
completely at a loss and pretty desparate to get it up and running again -
or I'm in big trouble!
Any help\shedding of light on this gratefuly appreciated.
...Where is there a receipt form for services rendered?
I am looking for a receipt form that would apply (or could be modified) to my
business, which is housesitting. Any suggestions? Any office product will do.
I couldn't find anything appropriate in Word
Mary Sauer MSFT MVP
"babebmr" <email@example.com> wrote in message
>I am looking for a receipt form that would apply (or could be modifie...Reporting Service request authentication to execute a report
I'm having a problem to execute a report on Microsoft CRM 3.0.
The CRM Server and SQL Server are under the same Domain.
When I click on "Execute Report" it requerest my user name and password,
after I type those informations the report runs normally.
Any ideas of how can I solve this?
Thank you very much!
This is probably cause by your configuration in IIS. If you SQL Reporting
Service (SRS) server url is on different website as crm main url, you will
see this behavior. Your SRS server url is in the format of http://<SRS Server
machine:port1>/reports...History and Activity Reports
I am working on an activity report and a history report and I have run into
a quandary with regards to SQL Reporting and Microsoft CRM 3.0. Since
history and activity items are now stored separately in the following
....it is quite a challenge to write a basic activity report that lists in
chronological order, all the activities pending and/or history items for a
contact or an account. Does anyone know an easy way to gr...People are seeing the same reports if they run a report a the same
We are experiencing an issue with the reports. Several accounting people use
the reporting features. However, if several people try to run a report at the
same time, each person can only see the report that the first person
generated sees. For example, if Person A, Person B, and Person C each went to
generate a unique individual reports (3 different ones) and Person A actually
generated her report first, then Person B and Person C sees Person A's
report, not their own. We thought this was a permissions issue but that was
not it (only one person in our org can create his own no matte...Dlookup on form
The dlookup listed below use to work but since I changed the data type of
the "InFruitTransLog" from number to character in the table "tblIntake" it no
longers work and only displays "#Error". For the record "txtBatchNo" is a
text box on the form that the user types in a batch number and the dlookup is
suppose to lookup and return "IntakeID" from the table "tblInatke".
=DLookUp("[IntakeID]","[tblIntake]","[InFriutTransLog]= " &
Can an...lotus approach queries VS access queries.
We are migrating from approach to access.
My basic underastanding of the procedure is that the data has to be
migrated and all the other features like forms and reports have to be
Is 'Approach query' different from MS Access query? Can this be assumed
to be replaced by Access query?