Search results for query: *

In Reality, all I am trying to find out is where I put in the criteria for IF statements in my fetch command. Going back to the original question here is what I need. I have a temp table populated with all of these headers and data. The headers are as follows: ItemRcvdKey, TranID, TranDate...

When I run that query it returns an empty record set.

It will eventually get fed into a crystal report which will show the total Qty on hand for an item in a particular warehouse at the Std Cost. Everything we inventory is based on a Std Cost, but there is a variance at times during the purchase price and the inventoried price. What my accounting...

I can't use a simple where statment because I need to get multiple records for one item. This is the kind of information I have which I am trying to get. ReceiptNo ReceiptDate ItemNo WhseID QtyRecvd QtyOnHand 0001 01/01/08 456 050 10 20 0002 01/05/08...

Hi, I am hoping someone can help me with using the cursor and fetch functions. I have not used these features in the past and I am now stuck when trying to use IF statements with the fetch function. The first temp table that I am getting data from contains the following fields. ItemRcvdKey...

Hello, I am trying to find out if there is a way to disallow the use of certain passwords in a group policy in A/D on Server 2003. I am aware of the complexity requirements but would like to be able to create a custom list of passwords I will not allow. Any help would be appreciated. Thank...

Thanks K, I appreciate it, worked like a charm :0)

Hello, I'm trying to find out if there is a function which can be used to select data that is not in a certain array. I currently have the following statement which is working correctly. if {CustomerKey} in [7298, 7300, 7318, 758,759,760,761] then {QtyShipped} What I now need is the opposite...

Thank you lilliabeth, that did the job. The one thing I'm confused about though is the "2" before the false statement. What does the "2" designate?

Hello, I'll start with a brief synopsis of what I am trying to accomplish. I have a spread sheet of products which contains information such as the item number, description, colors, quantity position, and a picture as an example for the customer. The qty position field needs to be populated...

Hello, To clear up the version off the bat, I am using Crystal Reports 10. I am writing a report which looks at sales based on certain accounts in my ERP system. I have set my selection criteria to only pull the items in a certain customer number range, and set the customer number as a group...

Hello, I am experiencing an issue with certain users when trying to receive emails from a particular domain. As a quick background the two users experiencing the problem have always been able to receive messages from the senders. The users on my side are using Outlook 2003, Windows XP SP2, and...

Hello, I am running Symantec Antivirus 10, Enterprise Edition on a local server. I am going to be assisting in the opening of my companies European office in the next couple of weeks. As the Euro office will not have a server on site, I am trying to find out if it is possible to remotely...

Hello, I am trying to create an ODBC connection to a .csv file which is populated with data from my companies accounting software. In turn, there will be a microsoft excel worksheet which is updated through an ODBC connection which points to this .csv file. The problem I am having is that when...

I figured out my problem, please do not repost to this thread. Thank you

Hello, I am trying to configure a powervault 220s to run with a poweredge 2850 in a Raid 10 configuration. Installed in the 2850 are two Perc4e/DC Dual Channel SCSI controllers. I have both connected to the powervault on channel 0. It is a split backplane by the way. I have 6 drives in the...

Hello, I need some assistance in shutting down a novell client server so I can relocate it. I've never worked with novell before and I have no idea what the command would be get the machine to shut down properly. Also, this machine servers as a file server and I wanted to make sure that there...

Thank you, I was not sure what the "next" function was doing. That helps.

Hello, I am not a crystal guru by any means and I do not understand alot of the language. I have a crystal report which was built by another party, and I am trying to figure out what this formula is saying in english. I know which tables it is looking at in my erp system, I just don't...

Awesome, that did it. Thank you very much.