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 derfloh 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: computerman29651
  • Content: Threads
  • Order by date
  1. computerman29651

    Copy Data from One Column to Another

    I need a formula that will look in column E, find 'CO', and copy over the data that is in column L. If the data in column E does not equal 'CO', then I want to leave it alone. For example. Column E Column L 84 2.0 CO 1.0 55 3.0 CO...
  2. computerman29651

    Delete Entire Row

    I need a formula that will look for a certain word, and if that word is found, then delete the row. For Example: Column F Read (test) Write Talk (test) Run Walk (test) So, what I need is a formula that if (test) is found, then delete the entire row. If any additional information is needed...
  3. computerman29651

    Delete Row

    I need a formula that will look for a certain word, and if that word is found, then delete the row. For Example: Column F Read (test) Write Talk (test) Run Walk (test) So, what I need is a formula that if (test) is found, then delete the entire row. If any additional information is needed...
  4. computerman29651

    How to pull data from different fields onto the same line

    I am using Crystal 10 with Access I am going to do my best to explain what I want to do with a crystal report. I have a field named Product in crystal report, and I want to display the prices from different fields horizontally (side-to-side). For Example: Product Field...
  5. computerman29651

    Macro in Excel

    Does anyone know how to create a macro or some other way to change the appearance of text in a cell? For example: Original: 12HGT-T Changed To: 12hGT-T
  6. computerman29651

    Crystal Formula

    I need a crystal formula to calculate the next invoice number. As of right now, I have the following formula: PageNumber + {?Invoice Number} -1 What I need if a Sample ID (1234) continues for three pages with an Invoice Number 2560, I need the next Sample ID to have a Invoice Number 2561...
  7. computerman29651

    Report Printing

    Is there away to setup crystal reports so that when you print a report, you can automatically print the same report with a watermark added? As of right, the original reports are being printed and then the I am having to go into the crystal report print properties to select the watermark, and...
  8. computerman29651

    Length of Comments

    Is there a formula that changes the length or style of comments on a crystal report? For Example: Comment: IIIIIIIIIIIIIIJJJJJJJJJJJJJJJJJJJJJKKKKKKKKKKKKKKKKK Comment: IIIIIIIIIII JJJJJJJJJJJ KKKKKKKKKKK
  9. computerman29651

    MS Publisher 2003

    I am creating a webpage in MS Publisher 2003. I have a order form that I would like to automatically calculate the total. Will MS Publisher allow me to do this?
  10. computerman29651

    Group Header and Page Header

    Is there a formula that can ne performed if the group header is carried over to a new page then the paged header is suppressed?
  11. computerman29651

    Error Message: "Failed to Export the Report"

    When I try to export my Crystal Reports I get the following error message "Failed to Export the Report". When I click the 'Export Report" button, I select the following from the drop down boxes: Format: Acrobat Format (PDF) Destination MAPI I am using Crystal 10
  12. computerman29651

    Bold a Crystal Report Field

    Is there away to use a formula to bold a crystal report field? Lets say that I have crystal report fields named 'Field1', 'Field2' and 'Field3' that contains the following information: Field1 Field2 Field3 Car 2 blue Trucks...
  13. computerman29651

    Suppress if Duplicated

    I need to know how to make data that displays on the report be suppressed if it is duplicated. For example, Jack B, Sue L, Chris P, Ted V, Jack B, Sue M, Ted V, Chris R, Chris P, Mike N, Mike N I need the information to display on the form like this, Jack B, Sue L, Chris P, Ted V, Sue M...
  14. computerman29651

    Ghost Header

    Has anyone ever heard of a ghost header in crystal?
  15. computerman29651

    Sorting

    Does anyone know how I can sort by one group and then by another alphabetcally?
  16. computerman29651

    Count or Sum

    I am trying to come up with some formulas to perform the following: If I have results that are incomplete, how do I create a formula to count the incomplete resuts. I want to be able to count the incomplete results that are >14, >7, and within 7 days. Can anyone help with this?
  17. computerman29651

    Display of data on Crystal Report

    Right now when the data/text is displayed on the crystal report is displaying like this: Hey There Man But, I would like for the data/text to display like this: Hey, There, Man, etc.... Does anyone know a way to get the data/text to do what i want?
  18. computerman29651

    Crystal Report Formula

    I am trying to create formula to produce three significant figures. The formula I have come up with thus far is as follow: ROUND(val({FLATDATA.ACOM}),2-(1+INT(ABS(val({FLATDATA.ACOM}))))) However, when I try to view the report, I get the error message "The number of decimal places is too large...
  19. computerman29651

    386 Enhanced Windows

    I am trying to get an old application to work with Windows XP Pro. Each time I try to install the application, I get the error message "this application requires 386 enhanced windows". Has anyone ever ran into this problem? If so, did you finad any solution? Can 386 enhanced work with XP?

Part and Inventory Search

Back
Top