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 Mike Lewis 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. ProgEval

    Excel X Axis Word Wrap

    Can you type out an example? I think I just tried your suggestion and it did not work. I want to make sure I have it right. When the text is rotated to 90 or 270 degrees the label will still not word wrap. Thanks for your help.
  2. ProgEval

    Excel X Axis Word Wrap

    I have charts in Excel 2007 and on the x axis I have text. Due to space I would like the text to word wrap to make it look cleaner, save space and keep everything legible. Any thoughts? Thanks in advance.
  3. ProgEval

    Excel 2007: Page Break Preview Issue

    Figured it out. http://support.microsoft.com/kb/214691
  4. ProgEval

    Excel 2007: Page Break Preview Issue

    I have a spreadsheet I converted from 2003 to 2007. When I am in page break preview I am not able to select the breaks to manually move them. I only get the big fat white crosshairs, not the arrows when hovering over the break. I have manually moved my page breaks without a problem in the...
  5. ProgEval

    Changing Field Types?

    I am creating a Crystal Report (10) on an Excel file. The Excel file has a particular field formatted as Text (includes both numbers or character records). Although, when Crystal links to the file it bring this field in as a number and eliminates all character records in the field. Any...
  6. ProgEval

    Crystal - Select Problem

    Yes, it is. Sorry for not making that more clear.
  7. ProgEval

    Crystal - Select Problem

    {View__cr_670.Date} in {?START DATE} to {?END DATE} and {View__cr_670.SurveyID} = 25666.00
  8. ProgEval

    Crystal - Select Problem

    In addition, when I do a "browse data" on that RecordID I only get the first couple options, when I should get many more.
  9. ProgEval

    Crystal - Select Problem

    I have a report that is showing me a report of records with a RecordID(number field). I am having an issue when I try to limit that list to one RecordID. The RecordID does exist in the original report. I create a condition that where the RecordID equal the number I want to see. When done...
  10. ProgEval

    Back Up Solution?

    Is there a software or something that will allow me to schedule a copy of files from my hard drive to a network location? Due to speed and some other issues, I would like to be able to use my files on my hard drive and then every evening have them automatically copy to a network location as a...
  11. ProgEval

    Crys10 Next Page Issue

    I am having one more problem converting a string to a number. I have a formula that is... ToNumber(numberstring). It appears, that when I come to a string that is null, an error message tells me "string is non-numeric". I tried the If statement to force the formula to 0 if its null, but...
  12. ProgEval

    Crys10 Next Page Issue

    Right. I basically do not want it to show. The supress should work. Thanks.
  13. ProgEval

    Null in formula

    I have a formula that converts a date string to a date field. If isnull(datestring) Then (I want the formula to show a null value) Else cdate(datestring) Thanks in advance.
  14. ProgEval

    Crys10 Next Page Issue

    lbass, In the above equation, how do I make the calculated field blank/null if the date field is null? You have it so its zero, but how do I make it null instead? Thanks.
  15. ProgEval

    Crys10 Next Page Issue

    I think this solves my problem! Thanks so much for the help. I appreciate it.
  16. ProgEval

    Crys10 Next Page Issue

    The formula is.... cdate({View__Annual_Renewal_Report.RenewalDate<String>})- cdate({View__Annual_Renewal_Report.RenewaLetterSentDate<String>}) The result of this calculation is okay when I test it in the formula editor and it shows correctly on page 1 when I run the report. When I go to page...
  17. ProgEval

    Crys10 Next Page Issue

    I have a Crystal Report that has dates and formulas based on dates. The formula includes string converted to dates(cdate()). When I run the report it shows perfect on the screen (Page 1). Although, when I try to see page 2, it takes me to the formula editor of one of my date formulas. I...
  18. ProgEval

    Crystal Highlighting - Every Other Record?

    Is it possible in a Crystal Report to have every other line highligted. I like to do this in my reports to help seperate each record. It seems like there should be a way but I can't figure it out. Thanks.
  19. ProgEval

    Problem Adding in Build

    I figured it out. NewField: nz(Field1) + nz(Field2) + nz(Field3) + nz(Field4)
  20. ProgEval

    Problem Adding in Build

    In a query I am adding four fields together in a new field. I am doing the calculation in build. It looks like this... NewField: Field1 + Field2 + Field3 + Field4 This works fine as long as a have a number entered into every field. Although, if one field is blank, it does not add the others...

Part and Inventory Search

Back
Top