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...
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}...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.