Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Parabolic33

    Help with Cursor and Fetch

    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...
  2. Parabolic33

    Help with Cursor and Fetch

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

    Help with Cursor and Fetch

    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...
  4. Parabolic33

    Help with Cursor and Fetch

    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...
  5. Parabolic33

    Help with Cursor and Fetch

    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...
  6. Parabolic33

    Disallow Certain Passwords in A/D Group Policy

    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...
  7. Parabolic33

    Need a function like "Not In Array"

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

    Need a function like "Not In Array"

    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...
  9. Parabolic33

    Excel Formula matching data

    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?
  10. Parabolic33

    Excel Formula matching data

    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...
  11. Parabolic33

    Grouping items within a group

    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...
  12. Parabolic33

    Email bounce back error 554 5.7.1

    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...
  13. Parabolic33

    Is it possible to install SAVEE 10 through VPN connection

    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...
  14. Parabolic33

    Cannot Select File name for odbc directory

    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...
  15. Parabolic33

    Dell poweredge 2850 and powervault 220s

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

    Dell poweredge 2850 and powervault 220s

    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...
  17. Parabolic33

    How do I shut down a Novell 4.91 box?

    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...
  18. Parabolic33

    Formula Breakdown

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

    Formula Breakdown

    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...
  20. Parabolic33

    Firewall IP Address

    Awesome, that did it. Thank you very much.

Part and Inventory Search

Back
Top