Sequence Number field on customized report
We have created a quarterly SUTA report that needs to be sent in as a .csv
file to the state. We have had no problems generating this data in Report
Writer using the Payroll Master, Payroll Transaction History, and Payroll
Check History tables. However, one requirement of the file is to have a
column with a Sequence Number that starts at 1 for the first employee and
increments by 1 for each new employee on each line.
I believe that since the Social Security number is unique on each line, that
we could somehow use this to number the rows. Does anyone know if there are
any fu...Can I use a Report expression for queries?
Is it possible to use the following expression that is used in reports on
Or some expression to get the result.
No. In your query, you can refer to text boxes on a form, but not on a
That's because of the way reports are formatted (sequentially.) Forms have a
current record, which identifies which value you want. Reports don't.
In the context of a query, there are other ways to get totals, such as
or a subquery:
Allen Browne ...Dynamic SQL Query and CRM Report parameter
Right now I am working on a CRM reporting. I am using SQL server 2005
In my Report I want to pass Field name as a parameter from Report interface.
My query is as Following:
DECLARE @SQL AS nvarchar(1000)
DECLARE @Param1 AS nvarchar(50)
SET @SQL = 'Select Field1, Field2,'+@Param1+' AS Field3 FROM Table1'
@Param was difined in 'Report Parameters' and I initialed it. I use
Field1,Field2 and Field3 in report layout.
I use @...Strange error message
I am getting a strange message when I am trying to copy a
graph that I use in a payroll document that we use. It
contains data and a graph for each employee. It worked
just fine for 80% of the document then all of a sudden I
started to get this message: "No more new fonts may be
applied in this workbook" with an OK button. I can hit
the OK button and it will eventually continue on (after
multiple clicks). But each time I copy and paste the
graph, it gives me this message.
I am using Excel 2002 on Win 2000 Pro with all the latest
updates and patches available. T...work order form and report design help
I am building an automotive shop database. I have a table that lists all of
the services and the prices. I have the main form created where all of the
customer data is entered in and I have another form that builds the work
order for the customer. How do I build the form to allow for different
services for the same customer without having to create service type 1,
service type 2, etc. I need them to be independent of each other and I then
need to create a report to print out for the customer.
On Tue, 23 Mar 2010 08:24:01 -0700, Jimmy <Jimmy@discussions.microsoft.com>
Is it at all possible to hide the Data Sheet portion of a split form at run
time in 2007?
The only solution I have found is to play with the SplitFormSize property,
but I am afraid that it does not support different display sizes.
Any suggestions ?
...Excel data disappeared after getting message about compatibility M
I tried to save changes to a spreadsheet, and received the following message:
"Compatibility Report for New Customer List.xls
Run on 4/6/2010 19:52
The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.
Minor loss of fidelity
Some cells or styles in this workbook contain formatting that is not
supported by the selected file format. These formats will be converted to the
closest format available."
I clicked OK, because fidelity is not imp...Synchronize data across 2 sheets
Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers
On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
Not sure if it would help but each record has a unique reference number.
How do i do this ?
Hope this makes sense
thanks for any help offered
If you know which colums are to be changed I would use vlookup function.
Vlookup(lookup valu...WIN98 Outlook 2000 Distributed Authentication Error
Using WIN98 2nd Edition and Office2000 Outlook.
Dial-up connects to internet fine and operates fine,
Outlook comes up fine and logs into e-mail server, however
just before e-mail is supposed to start downloading I get
the following: "An error occurred loading the Distributed
Password Authentication Components." After clicking OK,
get message box "Microsoft Server Extensions" and
message "Unable to read configuration information for
Microsoft Personal Web Server error code 1723."
Uninstalled Office2000 and totally reinstalled, only to
get the same exac...Entourage without HTML-display
I am new to the Mac and in my compay we use office:mac
Here's my problem:
I compose eMails just using text, I do not use HTML to compose Messages.
But if someone writes me a mail that is formatted in HTML Entourage shows
the formatted Mail. The only thing that I found so far is to not allow
"Complex-HTML" (whatever that means). But even when I turn off complex-HTML
Entourage shows HTML.
I was used (using Outlook Express 6) to turn off the display of HTML-Mails
Even Lotus Notes (v.5.0.9a) shows the eMails without HTML-Formatting.
And if I send an eMail f...Querying Excel data without another program
I'm an intermediate user of Excel, but I have lots of experience using
Access. If you can give me clues on how to handle the information below
using only Excel, I'd be grateful!
I have a spreadsheet in Excel 97 in which there's a Worksheet named,
"Datasource" with a column "B" containing repetitive data.
I'd like to create a new worksheet in the same Excel file which shows a
single instance of each item used in Column "B".
If I were writing the query in SQL, I'd say
"SELECT DISTINCT [Column B]
FROM [MySpreadsheet]![Datasource...Combo to show Checkbox on Report
I have a combo list in one of my queries that has a few records selected,
which makes the data appear as many times as the combo is selected when you
view the query. My report pulls information from that query and makes a
checkbox for the combo box. However, it only picks the first record and shows
only one checkbox.
How can I bring all the records together and show all the checkboxes I need
on one report? Any help is appreciated.
...Authentication Error after restoring SQL databases
Our CRM Development Team messed up our dev server and asked our SQL dba to
restore a two day old SQL backup of the MSCRM and METABASE databases. After
the restore, the CRM app. is unaccessible through the browser (
Authentication Error. Microsoft CRM could not log you on to the system. Make
sure your user record is enabled and that you have been assigned at least one
security role. For more information, contact your system administrator. )
Using the Deployment Manager only the License Manager information are visible
and neither Server Manager nor User Manager. It seems like the applicat...How do I create Vertical line down whole detail section?
As the detail section can grow and shrink I want insert my line using On
Print in the property section as per some advise given in another thread (not
started by me). The advisor suggested the code [Me.Line (2.3 * 1440, 0) -
Step(0, 20 * 1440)]
]but I have no idea how or where to insert it. Can anyone help? How do I
create or edit the [event procedure] in On Print in the properties section
Open your report in design view and double-click the gray bar above the
detail section. This should display the properties dialog. Click the Event
properties tab. Click the dropdown in the On...Error 0x80ccc0f
This is becoming a real PIA! I can be using Outlook for hours or only minutes and get this error. When I shut the program down and re-start it, it again works for hrs or minutes. Nothing I do seems to make a difference one way or another. Anyone have a suggestion?
Outlook 2000 SP-3
Yahoo Mail Plus (default)
OS Name Microsoft Windows 2000 Professional
Version 5.0.2195 Service Pack 4 Build 2195.
Submitted using http://www.outlookforums.com
Are you using a Linksys router?
Linksys routers have a history of problems with ma...Credit Card Expiration date error
We are getting an error message for credit cards with expiration dates
greater than 2010. Has anyone else seen that? We are currently on RMS 1.2
using PC-Charge. It takes expiration dates through 2009.
There is update for 1.2 to 1.3 and also in 1.3 there are patches available
kindly download from customer sources this will resolve the issue
> We are getting an error message for credit cards with expiration dates
> greater than 2010. Has anyone else seen that? We are currently on RMS 1.2
> using PC-Charge. It takes expiration dates thr...How to total cells in a range with data input
Greetings to all members
I am running Excel 97.
An office colleague presented me with an issue that might be of interest to
any Excel whiz and seasoned programmers. I would certainly appreciate any
pointers in solving it. So here goes.
The set of values includes 33 cells ranging from B4:D14. The data type is
numeric. Data is only input in a few cells.
What would be the function to enter in, say, cell A15 to indicate the total
number of cells in range B4:D14 that have received data input? Or does it
involve some behind the scene VBA programming?
B6 = 9 C9 = 4 D11 ...Insert Data From Multiple Worksheets Into One (With Criteria)
Ok, I have created a sales report list that tracks what customers we are
contacting, how we are contacting them, if they are a new or existing
customer and if we sent a quote, along with some other details. There is a
worksheet the salesmen fills out for each day of the month (its linked to a
calendar) and that all goes into a "dashboard" that shows the breakdown with
graphs. Now what i would like to do is have another worksheet list all the
customers that we sent quotes to so they can mark if the quote was won or
lost , state sales projections and give reasons why won ...Invalid sender domain
Your message did not reach some or all of the intended recipients.
Subject: RE: Boat
Sent: 4/17/2006 11:19 AM
The following recipient(s) could not be reached:
'Fahlahas@Surgv.com' on 4/17/2006 11:19 AM
554 Fahlahas@Surgv.com: Recipient address rejected: invalid sender domain
Dan Klinge <Yomama@kdkdjkfjdekfjdkfj.com> wrote:
> Your message did not reach some or all of the intended recipients.
> Subject: RE: Boat
> Sent: 4/17/2006 11:19 AM
> The following recipient(s) could not be reached:
> 'Fahlahas@Surgv.com' on 4/17/2006 11:19 ...Creating a word2000 document with access 2000 data
I have a database in access 2000 it is basically customer info.
address and dates and timesof appointments. I need to place a button
on the formpage that prints a letter using the customer details and
the date & time entered in the database. Anyone have any clues as to
the easiest way to do this.sort of done it using mailmerge but not
what I want. Actually want a word document to pop up that the staff
can just double check and press print. Any help would be appreciated
even just a point in the right direction to a good source of
to see if the following website's offer...LDAP Error in Outlook 2003
I just upgraded to Office 2003, and now when I go to Outlook to try to send
an email, I get an error that says "Can't contact LDAP server (81)". I can
eventually send the email, but I get that message several times.
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
You receive a "Can't contact LDAP Directory server (81)" error message when
you open the Address Book in Outlook:
http://support.microsoft.com/default.as...joining data points on graph
I am merging two graphs and one has 23 data points, the other has 9. The
category axis will have 23 data points but the 9 points are spread out, i.e.
they may be at points 1, 3, 7, 15 etc of the 23-point scale. At the moment
the graph will only join points that are beside each other; how do I get them
to connect to the points that have spaces between them?
minihana wrote on Fri, 10 Feb 2006 11:29:04 -0800:
m> I am merging two graphs and one has 23 data points, the
m> other has 9. The category axis will have 23 data points but
m> the 9 points are spread out, i.e. they may be...Outlook2003 error
I am getting an error message when i try to compus a new
message...''The messaging interface has returned an unknown
OS=W2K with SP4
Please help me
Thx in ADV.
...CRM 4.0 "An error has occurred"
I did an upgrade from CRM 3.0 to CRM 4.0. First I upgrade Sql2000 to Sql2005
SP2 and then upgrade CRM.
I have issue when create new case and tried to assign responsible contact.
The application show “An error has occurred”. This form did have a
customization in java to filter the contacts to show only the contacts for
the account. I removed this customization for the form, but still have the
I look for any Service Pack or Hot Fix but no found any.
Any idea will be appreciated,
Jose Valentin Rodriguez
the problem is that you used a (very...Dynamic data label placement for graphs
I've read the article KB179199 on how to create custom
data labels for charts and it's good, however doesn't meet
all my requirements.
Is there a way to have the data labels automatically move
to a desired location relative to the graph?
For instance, I'm using 50 bar graphs per work book and
would like each data label to be just above their
I looked up article 179199 and got this:
BUG: Grid Based on .QPR File Appears Blank in Visual FoxPro 5.0
which probably isn't the one you meant. By above the bar, are they
horizontal bars and you ...