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 IamaSherpa 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: elf1
  • Order by date
  1. elf1

    Crystal 10 Shared Variables

    Thanks for your help LB. I am clicking on formulas and then creating a new formula called 'sharedtest'. This bring up the formula as "formula = " I've tried placing the shared numbervar after this and clearing this out and putting the shared numbervar in. both times I am getting the same...
  2. elf1

    Crystal 10 Shared Variables

    hmm...... I created a formula in Crystal 10 and made it: Shared NumberVar myTotal When I try to save it gives me the following error "the remaining text does not appear to be part of the formula" and highlight myTotal
  3. elf1

    Crystal 10 Shared Variables

    I am having an issue created shared variables in Crystal Reports 10. I am used to using the following in Crystal 8.5: Shared NumberVar VARIABLENAME I know this has changed in Crystal 10 but am unsure of what the proper way to do this in Crystal 10 is. Thanks! Rick
  4. elf1

    Html Mail issue

    Greetings, I am having issues with the mail() function when sending an html formatted e-mail. The code sending the message is: " $subject = "New Equipment Posting on XXXXXX.org Website"; $message = '<html><body>Hello, <p>A new item has been added for Sale on the XXXXXXXX.org website. You can...
    • elf1
    • Thread
    • Replies: 2
    • Forum: PHP
  5. elf1

    Selection Formula Error

    Turkbear, Thanks for the tip. I added more parens and comments to make sure I had everything correct, and I am still not receiving the data from the second portion of the OR. Here is my current statement: ( //start selection ( //start OR statement {EarningCode} in ["01", "11", "12", "13"] or...
  6. elf1

    Selection Formula Error

    Greetings, I am making a modification to an existing report, and having an issue with the following selection formula: ({DeductionCode} in ["K", "KA", "KM"] or {EarningCode} in ["13", "12", "11", "01"]) and {CheckDate} = {?Check Date} When I generate data is only returning the deduction...
  7. elf1

    SubReport Assistance

    Hey! How do I configure a subreport to print after the main report and always print at the top of the next page? I've created a Purchase Order Report and would like to have an Appendix print after each Purchase Order. Can you point me in the right direction? Very much appreciated! Lisa
  8. elf1

    Report Linking

    Hey Tek-Tips! I am working with Crystal 11. I would like to "link" 2 Crystal reports together. Is this possible? Yep, you folks are the best! Lisa
  9. elf1

    String to Number / Having some Issues

    Thanks ro I just figured out the Syntax problem. Excuse me for not providing enough information for you. Thank you for your time, Lisa
  10. elf1

    String to Number / Having some Issues

    Hey! I am having problems with the ToNumber Syntax I have a text field item.weight that I would like to include in a formula Item.Weight * Quantity.Shipped Can you help with the syntax. Currently I have ToNumber ({item weight}) * {quantity.shipped}
  11. elf1

    Rounding Formula

    the formula -int... worked perfectly. Thanks a ton
  12. elf1

    Rounding Formula

    I am wanting a field to round up to the next hundredth(.00) if the next thousandth(.000) is .001 on greater. I am not sure how to write the proper rounding_type formula for this to happen. Any help on this would be much appreciated.
  13. elf1

    Exporting

    Thanks for your help so far, this is what I have now as my formula and it is giving me an error: shared numbervar Hours := Sum of PR_22PerpetChkHistoryHeader.TotalEarningsHours;
  14. elf1

    Exporting

    We are using Crystal 8.5, and it has the most current service pack (3).
  15. elf1

    Exporting

    I am exporting a report to an excel file, and two of the values within the report are accessed via a subreport. Only one of the subreport values is exported to excel. Anyone have an idea on how to resolve this issue?
  16. elf1

    Linking by Formula

    I have done what you suggested and setup Account and Account_1 tables and the fields in my other table linking each to one. On the report I print both fields on top of eachother because one should be blank. However I'm unable to see any data because when I refresh the report crystal hangs and...
  17. elf1

    Linking by Formula

    A table I have includes two possible fields that have the Account Number (key). If the line type is "1" then the Account Number comes from field1 if the line type is "2" then the Account Number comes from field2. I've created a simple "if then else" formula to determine the account number...
  18. elf1

    Linux Wine and Crystal Reports

    Has anyone successfully been able to run Crystal Reports on Linux using Wine, CrossoverOffice, or any other tool? I'm trying to setup a Fedora Core 4 box with Wine Mas90/Mas200 and CrystalReports. Mas90 is installed and functions, but I havn't been able to get Crystal 8.5 to work. I've tried...
  19. elf1

    Subtracting a Negative Integer

    Katy44, Thank You, this is exactly what I was looking for! You are awesome! Lisa
  20. elf1

    Subtracting a Negative Integer

    Hi, Thanks for helping me. This formula is supposed to determine Gross Profit Percentage. I can get this to come out on a calculator, but not in the formula I am trying to create. The calc is Cost of Goods / Sales Minus (-1) Times 100 If I take 1288.20 and divide by 1788.87, I get 0.7201...

Part and Inventory Search

Back
Top