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 bkrike 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: Cherrel
  • Content: Threads
  • Order by date
  1. 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...
  2. 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]
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. Cherrel

    Parameters Issue

    Greetings All! I have an issue regarding PARAMETERS and the extent of it's ability. I'm writing a report (actually, updating an existing report) and I need enter a parameter that prompts a user of the report to select the method by which they want to "SORT" the report by. The best...
  10. Cherrel

    GRAND TOTAL QUESTION

    Greetings. I am currently composing a report in Crystal 7.0 that is to calculate various "GRAND TOTAL" values on inventory items that are located within my report. I have no problems "sum"ming up other columns at the end of my report (total number of inventory items that...
  11. Cherrel

    USING "UNION" STATEMENT IN SQL DESIGNER

    Hi All! You have all been terrific in helping me with Crystal Reports 7.0, I thought that I'd pose yet another question for you guru's. I have created a report using CRYSTAL SQL DESIGNER utilizing the "UNION" function. I am trying to get a report that produces *SIX* separate columns...
  12. Cherrel

    MULTIPLE SQL STATEMENTS FROM SQL DESIGNER

    Greetings and Happy New Year to All! I have a quick, 30 second question for you. Does CRYSTAL REPORTS 7.0 allow for multiple query statements from Crystal SQL Designer into it's reports? If so, how? I'm unable to import multiple queries from it. I'm going to NEW report, clicking on CUSTOM...
  13. Cherrel

    TOTAL VALUE not working

    Greetings and Salutations to All! Here is my issue. I am composing a report that gives a basic status report on Inventory currently on-hand. Besides running the report off of Model Numbers (1), the report contains five additional fields - Ready for Issue (not broken) (2), Not Ready for Issue...
  14. Cherrel

    Easy Average Date Question

    Hi All! I'm very new to Crystal Reports (v.7.0) and I'm having problems with this SIMPLE formula. I'm trying to AVERAGE a field against today's date. Field ({equipment.installdate}) and haven't been able to average with currentdate. Can anyone help? (I'll probably be saying "DUH!&quot...
  15. Cherrel

    TURN OFF SMART LINKING

    Hi All! I know there is an option box somewhere in CR 7.0 that allows one to turn off the !#$%#% Smart Linking. I'm tired of having to manually click on all links and delete them one-by-one. I have been throughout the program and have had no luck. Please help a very disgruntled (this problem...

Part and Inventory Search

Back
Top