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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jbhsuman

  1. jbhsuman

    Reintalling Xp Pro

    Thank you all for responding. Gargoyl, to answer your question, the utility I ran is the verification check from one of the MS patches I down loaded during a MS Update. As for the installation, I first tried to run it as an upgrade over the existing Home install but ran into errors. Subsequently...
  2. jbhsuman

    Reintalling Xp Pro

    I purchased a copy of XP Pro off of Ebay and installed in on one of my laptops without any issues. I had even run the utility to check to make sure this was a genuine copy without any problems. Recently the LT died and I purchased a new LP that came with XP Home. I installed the same copy of XP...
  3. jbhsuman

    Linking tables

    Thank you all for your input. synapsev, I am linking all talbles to the field Invoice. As far as the question from dtemp, the field lengths are all the same. I used the left join option and now the report does not return a blank report, however it still does not disply the value I m looking for...
  4. jbhsuman

    Linking tables

    CR9 This may sound like a silly question but I am getting some strange results while trying to link a table to an existing report. The tables in question are: Invoice Header Invoice Detail Invoice History Currently I have the following links established...
  5. jbhsuman

    Deploying Reports

    CR Ver9 Please excuse my lack of knowledge in this area. If I am creating a report for a client and that client does not have CR or CRE and is not interested in purchasing CR, how would you be able to give the client access to the custom reports without using CR Enterprise? Would you have to...
  6. jbhsuman

    DateDiff Function Over a year

    Hello Chelseatech, Thank you for your insight. I have, infact, changed my formula to use the "Y" to the "D" parameter and did not actually see any difference. Would you please explain what is the difference between using the "Y" rather than "D". Thanks in advance.
  7. jbhsuman

    DateDiff Function Over a year

    Madawc, That did appear to be the problem One of the values were null and this is what caused the formula to fail only on this record. Dgillz, Sorry, the database I am using is called Advantage and they provide a tool called data architech. Are you familiar with this backend? Thanks again for...
  8. jbhsuman

    DateDiff Function Over a year

    Thank you both for responding. Dgillz, yes I can look at the raw data and that appears to be what I need to do. After carefully checking all the other values, it seems only isolated to this one record. I also tried trouble shooting by forcing different values and it appears that on this...
  9. jbhsuman

    DateDiff Function Over a year

    Actually as I tested more dates it is a little more confusing. It appears that this problem only happens on one record through out the report. The dates in question are: 5/15/2003 to 5/11/2004 I have other dates that fall between similar dates in May of 2003 but this problem only exists when...
  10. jbhsuman

    DateDiff Function Over a year

    Using CR9 I am using the DateDiff function to calculate the number of days between dates as in the formula below. dateDiff("d", Date1, Date1) Everything works fine until I reach a date over 1 year. When this happens I get a null return value. Can anyone shead some light as to why this is...
  11. jbhsuman

    Conditional Formulas

    Thank you everyone for your valuable advice. Jim, thank you for your detailed explaination. Can you recommend any publications to read that would help with writing complex formula's and such?
  12. jbhsuman

    Conditional Formulas

    Thank you all for helping. I appreciate the support. dgillz - Your solition worked. Would you mind helping me understand why your changes were necessary? In GH1 - If Not InRepeatedGroupHeader then numberVar InsTot90 := 0; The "InRepeatedGroupHeader" I could not find a reference to this...
  13. jbhsuman

    Conditional Formulas

    Using CR9 I am creating a formula to calculate an amount based on an aging category within a group. Each time the group changes I want to reset the calculation variable to zero so we can start at zero again with the next group. Here is the structure GH1 Global numberVar InsTot90 := 0; Detail...
  14. jbhsuman

    Internet Connection Disabled

    Thanks for responding. I check the zero config and it is set to auto and is running. With regards to the power option, since my wireless is not imbedded, I don't think this option applies. Either way, I believe that if either of these settings were incorrect, I would not have any connectivity...
  15. jbhsuman

    Internet Connection Disabled

    Thank you for responding. Yes it's similar but not quite. I have no problems with the network connection per se, rather only with the internet connection.

Part and Inventory Search

Back
Top