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 gkittelson 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. BigDogAZ

    Narrow SUM of formula to one part number at a time

    THANKS TO BOTH MADAWC AND LBASS! You both offered a similar solution that solved my problem. I have been using Crystal for two decades (on and off), but since I haven't used it for two years, some features I forgot about. I was making it way too hard in creating formulas for my part number...
  2. BigDogAZ

    Narrow SUM of formula to one part number at a time

    The BASIC code below selects ISSUE and PICK transaction quantities that occur in 2010 and displays the actual qtys if true, or 0: FORMULA NAME: YR2010-issues dim YR2010issue as number if ({ITEMH.TYPES}= "ISSUE" or {ITEMH.TYPES}= "PICK") AND Year({ITEMH.DAT_})= 2010 then formula = {ITEMH.QTY}...
  3. BigDogAZ

    Where to find help on CR "JOINS," differences, etc.

    I write reports with CR10 often using 10 tables, lots of links, and occasional "joins" in order to get what I want out of our ERP system. Where can I find more about joins, when/how to use them, why they work, the difference between a left and right outer join, etc. I've looked here, under FAQs...
  4. BigDogAZ

    Problem Accepting Assigned Tasks in Outlook 2003

    We use Office 2003 here and can send/accept/deny Calendar appointments just fine when attendees are invited (they update both users). However, when we try to Accept or Deny assigned tasks (sent just fine thru POP3 email), we can see the assigned task buttons in the preview pane window, but the...
  5. BigDogAZ

    CR10: Session timeout, database logoff default setting

    Synapsevampire, thanks for the response. But when I'm in our ERP application, hooked into the Interbase DB, it never logs me off during hours of idle time with that program. Just CR logsoff the DB. I don't have a DBA to ask, so gimme your best shot as to where I might look to change it when...
  6. BigDogAZ

    CR10: Session timeout, database logoff default setting

    I'm new to this forum. When creating reports in Crystal Reports 10, I have to LOGON to Interbase (our database for Quantum ERP) in order to fetch the data. When I am idle for X minutes or walk away for a while, it automatically logs me off (10 minutes???). This is really annoying and I would...

Part and Inventory Search

Back
Top