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!

  • Congratulations Mike Lewis 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: *

  • Users: Prognewb
  • Order by date
  1. Prognewb

    Pulling latest dated record from table

    Crystal XI on SQL 2008 I have a table that records customer transactions, and there are multiple transactions in the table per customer, so there could be 30 transactions listed in the table for one customer. There is a date field on each transaction (no more than one per day in the table), and...
  2. Prognewb

    Knuckle cracking..flipflops..etc...

    Usually if someone walks by my desk with loud flip flops, I'll mimick their steps, saying "flip flop flip flop flip flop" as they go by. Doesn't really accomplish anything, but it's good for a laugh. Noway2, we used to have the same problem at my plant with "private" phone calls, until we ended...
  3. Prognewb

    Typically British versus typically American given names

    Thanks, I didn't know that either. I thought the short for Henry was just Hank.
  4. Prognewb

    Typically British versus typically American given names

    I was almost named Vernon, but my mother put a stop to it. I wouldn't have minded it as a middle name, since it's my grandfather's first name. They finally settled on James, but my mom called me Jamie because she really wanted a girl. It stuck, and I don't mind. It's better than Jimmy. To me...
  5. Prognewb

    Penmanship in the Digital Age

    The people that still have checkbooks, I usually get stuck behind in the grocery line. ;) I think banks are trying to force people out of using them though, the cost of a box of checks at my bank went from $15 to $75 in the span of a couple years. I have to take a lot of notes throughout a...
  6. Prognewb

    Crystal and printing shipping labels - label size not saving

    It already is, doesn't seem to make a difference. When I go in and manually select the correct label size, Crystal actually scales the design/preview area to the size of the label so I can edit it for the allotted space. Crystal doesn't appear to have that label format in its architecture...
  7. Prognewb

    Crystal and printing shipping labels - label size not saving

    It reverts to the default label size, which is half the size of the one I need to use. I'm not familiar with setting up a label using the section expert... I originally assembled the report in the usual manner, as the label expert was taking too much tweaking to get the proper label size and...
  8. Prognewb

    Crystal and printing shipping labels - label size not saving

    I should have mentioned it, but I do save the report at every step. The label size is a standard DYMO shipping label that I've set up in both the printer options and page setup. It resizes the design/preview screens to the size of the shipping label so I can arrange the fields within the given...
  9. Prognewb

    Crystal and printing shipping labels - label size not saving

    To add: I've attempted this on both XP and Vista Business workstations, same result.
  10. Prognewb

    Crystal and printing shipping labels - label size not saving

    I've written a report (XI) that selects a customer shipping address, and prints it to a shipping label (on a Dymo LabelWriter 330 Turbo). In Crystal, I select the correct printer and label size, save the report, run it, and it prints correctly. However, if I close the report then reopen it, the...
  11. Prognewb

    eSynergy - attaching PDF to workflow

    I've binged this and searched on this site, but haven't found an answer... I am trying to find out if it is possible to attach a file such as a PDF directly to a workflow item in eSynergy. It can be done in a "document", but I have some workflow items that I'd like to be able to directly attach...
  12. Prognewb

    Using login script to check for a file

    I have a file that needs to be on all workstations in my Windows Server 2003 network, if it's not, an enterprise-wide program we use doesn't function properly for anyone. It's in a folder in that particular app's program file on the C drive of each workstation, placed there manually. We use a...
  13. Prognewb

    Invoiced/Posted order stuck in Open status

    While billing an order, the computer it was being done on lost power and shut down. Upon restarting, the order was successfully billed and invoiced (it has an invoice number), and shows up in the general ledger, but it remains in open order status (the row is still showing up in the oeordhdr_sql...
  14. Prognewb

    Defaulting comment on production work orders

    Thanks, I hadn't thought of that, so I checked, but it isn't showing up there... it doesn't seem to be linked to any of the individual items, just showing up on the production work order no matter what items are on it.
  15. Prognewb

    Defaulting comment on production work orders

    We're having an issue with a comment defaulting onto our production work orders. When printing a new production work order, the comment section defaults to the same comment for each order, and I can't find where to shut it off/change it. When we enter a new production work order, the comment is...
  16. Prognewb

    Repointing domain name IP's - not seeing from inside network

    I have two websites, an old one and a new one, each with a unique IP. I had to switch the domain name from the old to the new, as the old one is being phased out. I'm using a subdomain of our main network domain name (e.g., store.mycompany.com as opposed to www.mycompany.com), and have pointed...
  17. Prognewb

    SQL Query - pulling a value from a subset

    Thank you, I hadn't thought of using an inner join, that did the trick. I appreciate the help!
  18. Prognewb

    SQL Query - pulling a value from a subset

    I don't use SQL much these days, so my query writing skills have deteriorated... I've googled and looked around the net but haven't found a specific answer for my issue. I have two tables, one that holds header information for sales orders, and the other that holds line information for those...
  19. Prognewb

    Macola Upgrade - Function gone (G/L Account Search)

    I haven't reported it to Exact yet, we don't have unlimited support from them so I was reluctant to go to them about it. Now that I know the issue, I'm going to report it. We upgraded from an earlier version of ES, which was originally an upgrade from Progression. I haven't noticed anything...
  20. Prognewb

    Macola Upgrade - Function gone (G/L Account Search)

    Figured it out... the instructions on what keys to press for the search are gone, but you can still hit F7 or F8 and get the search.

Part and Inventory Search

Back
Top