Search results for query: *

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.

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

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

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.

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

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