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 SkipVought 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: *

  1. Cherrel

    Crystal Reports 7.0 not returning all data from Table & Field

    I edited the registry as you suggested and upped the decimal value to 5000. It is still not pulling all the data across. I know from the application that I was querying (MAXIMO) that there are over 2000+ locations in the SQL database -- Crystal Reports is only returning 12. I can not figure...
  2. Cherrel

    Crystal Reports 7.0 not returning all data from Table & Field

    Folks, Long time no write = Long time no problems! I have set up a parameter that is supposed to supply my users a "look up" of default values for my report. It is a report about equipment and their locations and it's only bringing me up a few locations as opposed to all locations...
  3. Cherrel

    Having problems installing CR v.6 in XP

    Hey All. I was wondering if anyone has had this problem.... I'm having a lot of problems trying to install CR v.6 on XP. It takes forever for the keystroke to appear in the license area, and then it just fails on the install to the computer. Any ideas? Thanks, Cherrel.[ponytails]
  4. Cherrel

    Converting alphanumeric data fields to Code39One Barcodes

    Naith, All I can say is, "YOU DA MAN!" [thumbsup] I can't believe that I didn't think of doing that. I knew that it should have been something very easy.... Thanks so much! Cherrel [ponytails]
  5. Cherrel

    Converting alphanumeric data fields to Code39One Barcodes

    Naith, Yes, I looked at that function, also. But, it only supports the _ and 0-9 characters. My clients also have letters in their equipment names. Thanks, Cherrel.[ponytails]
  6. Cherrel

    Converting alphanumeric data fields to Code39One Barcodes

    The asterisks convert to bar code font, as does the alpha-numeric field, but it's almost as if Crystal puts spaces in between the asterisk(s) and the alpha-numeric field. Thus, the scan is incorrect. Cherrel.[ponytails]
  7. Cherrel

    Converting alphanumeric data fields to Code39One Barcodes

    Guru's, I'm trying to print bar codes of equipment, inventory, and locations with Crystal Reports 7.0. I'm using the Code39One bar code font. I know from previous usage of this font that I must first put an astrick in front and after the data field in order for the bar code scanner to...
  8. Cherrel

    Discrepancy Report

    Bruce, I really do not care about performance. They are only going to run this report at the end of the day to see if any of their transaction did not process or to see if balances somehow got off (they are going to do a complete audit of their inventory and I'm going to spend the weekend...
  9. Cherrel

    Discrepancy Report

    Greetings to All! I'm creating a Discrepancy Report of Inventory in my customer's warehouse. I have created two seperate reports that query the database: The first report (EQUIPMENT) goes out to the DB and groups based on Inventory Item Number (item.itemnum). The report produces a current...
  10. Cherrel

    Parameter Name to Print on Report

    NAITH: It work like a charm!!!! Thanks! Cherrel [ponytails]
  11. Cherrel

    Parameter Name to Print on Report

    Right! You must have sent your message at the same time I was composing my answer to his. :)
  12. Cherrel

    Parameter Name to Print on Report

    USING CRYSTAL REPORTS 7.0 No no...I know that. The date criteria information is what I want to print out. It's almost like the font has been set to clear, but I have checked it and it's set to black.
  13. Cherrel

    Parameter Name to Print on Report

    Hi All! I have a report that I need to print the parameter criteria on the report. (It's a date range report, and I need the date criteria to print out to be part of the title of the report.) I'm pretty sure that I have done this in the past, but I have wasted too much time trying to figure...
  14. Cherrel

    ** Report NEEDS to show Duplicates **

    IT WORKS GREAT!!!! Thanks guys! The report shows the problems the data has and works great! Cherrel. [chicken]
  15. Cherrel

    ** Report NEEDS to show Duplicates **

    Hi All!! It's been a long time since I have been back here. (I guess that means that Crystal Reports must be getting easier for me...) I'm writing a report that displays Equipment Number (EQNUM) and Serial Numbers (SERNUM). (I need a report that displays all EQNUMS that have DUPLICATE...
  16. Cherrel

    HP LaserJet 6P and Crystal Reports 7.0

    Howdy Guru's of Greatness! I have a quick question. I have a user that is printing out a Crystal Report on a HP LaserJet 6P printer and she has to form feed the paper from the top paper feeder. Crystal Reports is the only app this happens with. Anyone else out there experienced this? She's...
  17. Cherrel

    Yet *ANOTHER* Parameters Issue (CR 7.0)

    OK, IT WORKS!! WHOO HOOO! What I had been forgetting to do was set up the "@formulas" in the SELECT EXPERT. *DUH* Also, the sort by wasn't working because I had forgotten to code in the "@sort by" into the SORT BY function. IT WORKS! THANKS TO ALL THAT HELPED!!! I'm one...
  18. Cherrel

    Yet *ANOTHER* Parameters Issue (CR 7.0)

    Good Morning All! OK, here's the deal.... I have set up parameters and formulas for both PROJECT & LOCATIONS. Taking PROJECT as an example, I created a Parameter for our projects including a condensed verison of the actual list and that appears to be working well. Gives me a...
  19. Cherrel

    Yet *ANOTHER* Parameters Issue (CR 7.0)

    John43, Thank you sir for your prompt response. OK, well, at least I know that I'm on the right track because I have already done this. In the FORMULA box I am using IF-THEN-ELSE statements. It still does not return the proper information to my report. If I select from the drop-down box for...
  20. Cherrel

    Yet *ANOTHER* Parameters Issue (CR 7.0)

    Greetings to All! I am writing a report entitled, "EQUIPMENT LIST". In this EQUIPMENT LIST, I'm including such fields as: Equipment Number, Description, Model Number, Serial Number, and Project. Yesterday, I was able to create a report based on these fields and sorting on any ONE...

Part and Inventory Search

Back
Top