Recent content by ProgEval

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.

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.

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

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...

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...

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

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

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

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...

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...

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...

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

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.

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.

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