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 wOOdy-Soft 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
  • Content: Threads
  • Order by date
  1. 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
  2. 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
  3. 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...
  4. 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
  5. 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
  6. 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}
  7. 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.
  8. 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?
  9. 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...
  10. 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...
  11. elf1

    Subtracting a Negative Integer

    Good Evening, I need to create a formula that will subtract a -1 from a value. How would I do this? I am uncertain of the syntax. Thank You So Much, Lisa
  12. elf1

    Format for Invoice

    Hi, Can you help me determine what change needs to be made to this formula, in order to have the "," between the City and State fields NOT print when there is nothing in any of the address, city or state fields? I can always rely on Tek-Tips for the solution to all my Crytstal Problems. Thank...
  13. elf1

    Selection Formula for Date

    Hi Tek-Tips, I need a report that will give me a list of customers who have not made any purchases (for a specified period of time) but have at least 1000.00 in Sales for the year. If a purchase has not been made I want the date of their most current invoice displayed. In the details section...
  14. elf1

    Formula to Select Most Current Date From Detail

    Good Evening Tek-Tips, How do I create a formula to capture and display the most current Invoice Date from the Details section and print that in the Group Header? Thank You So Much, Lisa
  15. elf1

    Convert Number to String

    Hi, I am having problems with the following formula: If {POR_VendorPriceLevel.DiscountMarkup1} <> 0 then {POR_VendorPriceLevel.DiscountMarkup1} Else &quot;n/a&quot;; The formula expects to find a number vs string &quot;n/a&quot;. Can you help? Thank you so much, Lisa
  16. elf1

    Distinct count for number of records selected

    Hello, I am creating a report using Crystal Decisions 8.5. I have a grouping defined called Division. The detail is capturing invoice numbers within a particular date range. This part is working fine. I have done this with a formula If Transaction Date is in date (2002, 10, 01) to date...
  17. elf1

    Pulling Data from Forefront Job Costing

    Thanks in advance for your help. Crystal Decisions Version 8.5 Pulling in Data from Forefront Job Costing Financial Systems , Btrieve Details Section In Crystal Contains a Field Called VN_Payment_History. Payment Amount This field contains Credits, Debits, and Zero Amounts, this field is keyed...
  18. elf1

    Can you store a date in a shared variable?

    Hi, I am manually converting a bunch of Crystal Reports (V8.5). The database that these reports are attached to, went through a major version upgrade. Many of the actual datafile types have changed. Evidently the file referenced below{AS_13Added_Fields_File.PermitOrdered} used to be a string...
  19. elf1

    CR8 Conditional formula for detailed records

    Hi: I have a conditional formula to add particular fields together excluding 0 amounts. The problem... all records print regardless of what the formula's are requesting it to do. Any help appreciated. James

Part and Inventory Search

Back
Top