I'm trying to export data from a table to a text file using the TransferText
macro command. I've set all my number field types to double with a standard
format and no decimal places.
However when the table exports and produces a text file all numeric fields
have decimal places. The text file will be loaded into another oracle based
application and it doesn't like the decimal places.
How can I remove them ?
Do you really need to use the Double data type?
Could you use Long (Integer) instead?
"butlerd" <email@example.com> wrote in mess...Sending messages #3
When I send messages, there are often more messages being sent than what I
created. For example, I may send 2 e-mail messages, but my antivirus says it
is scanning three or more. But, when I check my outboc, there are only the
messages I have sent.
I am concerned that I either have a virus (although I have a current and
updated version of Norton Antivirus) or a problem with my Outlook settings.
Can anyone provide me with some guidance?
When you send, you also automatically receive. I'd guess that NAV is scanning
incoming mail, too, and adding to the total.
"L...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...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...Select data from a list with different colors
Ive been racking my brains out on this problem, but cant' find a solution..
I have a list of 16 items (row a50 to a66), each line is a different text
value, next to that list, is another list in b50 to b66, those are formatted
in different colors.
what I need is when a user selects a value from the drop down list, the
color of the selection corresponds to what is selected..
and so on..
the drop down list cell is in a1, when the user selects a item in the list
in cell a1, the color specified should be changed in that cell, if they
select 2 then the c...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...Contact List #3
I am having a problem with my wife's contact list. She
is using Outlook 2002 running on Windows XP Home
Edition. When we type click on the Contact Icon, it
shows all of our contacts that we have entered, however,
when we creating a new email message, when we click on
the "to" button, none of the contacts are there. Can you
tell me how to solve this problem?
Go to Tools | E-mail accounts, select "View or change existing directories
or address books", and click OK. If you don't see the OAB in the
Directories and Address Books list, cl...Outlook 2000 Question #3
I've got a simple question that there might be a simple answer to that I
just can't quite see right in front of me. I have a client that's running
Outlook 2000 (with service release 3 installed...all updates done to MS
Office) and it can't seem to Accept/Decline/Cancel meeting requests. The
emails show up indicating time and date but the buttons do not appear to
Accept or Decline the meeting. Does anyone know what I can do to fix this?
Thanks in advance,
Are they using Corp or Internet mode? Do they receive the meeting request
form or a plain text message wi...Data Validation Syntax Question
I'd like to restrict a user (me) from entering more than two digits after
the decimal point in a cell. I have a checkbook spreadsheet and recently
discovered (by accident) that I made a withdrawal entry of 117.122 a couple
of years ago, but I can't figure out how to be sure to keep from doing it
again. Am I missing something simple?
Thanks for any help.
multiply by 100 and see if it's a whole number
If A1 is the activecell.
multiply by 100 and divide by 1. Check the remainder to see if it's 0.
Jim &...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 ...Excel XP
I have a pivot table using data from Microsoft Analysis Services. I need to
reference the table using the GETPIVOTDATA() worksheet function. The pivot
table contains one data field and two dimensions. In order to retrieve the
data field I need to reference both of the dimensions. One of the dimensions
I will reference with the member name, but the other one needs to be
referenced by one of the member properties of the member rather than the
member name. Is this possible?
...missing data after upgrade
I am using Windows XP. I upgraded from Office 2000 to
Office 2003 and my e-mails in Outlook have gone missing.
I searched my hard disk for *.pst files (including hidden
files) but only one showed up which seems to be the new
How do I get back my old e-mails?
What size is the pst?
"KOC" <firstname.lastname@example.org> wrote in message
> I am using Windows XP. I upgraded from Office 2000 to
> Office 2003 and my e-mails in Outlook have gone missing.
> I searched my hard disk for *.pst files (i...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...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?
...Pivot table field list
How can I prevent the Pivot Table field list from popping up every time I
open a pivot table or change the range, etc.?
In Excel 2000, the PivotTable toolbar moves out of place any time you
use the PivotTable wizard, but seems to stay put if you use other
commands or buttons.
There's no way to permanently dock it, AFAIK. However, if you
double-click the toolbar's title bar, it re-docks in its previous position.
> How can I prevent the Pivot Table field list from popping up every time I
> open a pivot table or change the range, etc.?
Excel...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 ...Revert data from 2005 to 2002 UK version?
I 'upgraded' to the UK 2005 version about 2 years ago, but it is now
failing to connect to my online banks. I seem to remember some in-
built obsolescence in the online features so I presume this is the
Is it possible to revert the data file back to the 2002 version? IIRC,
there was a warning about upgradings not being backwards compatible
when I loaded the 2005 version.
If that is so, what is the best way to revert the data back to the
In microsoft.public.money, dg wrote:
>I 'upgraded' to the UK 2005 version about 2 years ago, but it is...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?
...Excel data to Access
I have file with data being modyfied by users from time to time.
In Excel it looks like:
name month (other collumns)
1 2 3 4 5 6
Student Michael 234 34 2 67 65 34....
I need ths data into acces like
student Michael 1 234
student Michael 2 34
I cant use Transponation as I need data from every second line in
Is teher any good and efficient solution for making such a forms ?
If I understand correctly, you have names in column A. Test scores in columns
You want the name copied to...Excel
I am trying to get my head around the following scenario � bu
struggling. Please can someone help:
I have setup 2 data validation lists:
�Consequence� List 1 : Serious, Significant, Minor
�Likelihood� List 2 : Probable, Possible, Remote, Nil
How do I setup 2 further lists which act on that initial preference
I.e. so if Serious & Probable were chosen, 2 further set lists woul
appear. (The lists would change depending on the initial preference)
(Hope you follow)
I then need to equate the data into a numerical form.
I have studied the contexture site in some detail but still stuck!
T...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...