Search results for query: *

I need a formula that will look in column E, find 'CO', and copy over the data that is in column L. If the data in column E does not equal 'CO', then I want to leave it alone. For example. Column E Column L 84 2.0 CO 1.0 55 3.0 CO...

I need a formula that will look for a certain word, and if that word is found, then delete the row. For Example: Column F Read (test) Write Talk (test) Run Walk (test) So, what I need is a formula that if (test) is found, then delete the entire row. If any additional information is needed...

I need a formula that will look for a certain word, and if that word is found, then delete the row. For Example: Column F Read (test) Write Talk (test) Run Walk (test) So, what I need is a formula that if (test) is found, then delete the entire row. If any additional information is needed...

I am using Crystal 10 with Access I am going to do my best to explain what I want to do with a crystal report. I have a field named Product in crystal report, and I want to display the prices from different fields horizontally (side-to-side). For Example: Product Field...

Does anyone know how to create a macro or some other way to change the appearance of text in a cell? For example: Original: 12HGT-T Changed To: 12hGT-T

I need a crystal formula to calculate the next invoice number. As of right now, I have the following formula: PageNumber + {?Invoice Number} -1 What I need if a Sample ID (1234) continues for three pages with an Invoice Number 2560, I need the next Sample ID to have a Invoice Number 2561...

Is there away to setup crystal reports so that when you print a report, you can automatically print the same report with a watermark added? As of right, the original reports are being printed and then the I am having to go into the crystal report print properties to select the watermark, and...

Is there a formula that changes the length or style of comments on a crystal report? For Example: Comment: IIIIIIIIIIIIIIJJJJJJJJJJJJJJJJJJJJJKKKKKKKKKKKKKKKKK Comment: IIIIIIIIIII JJJJJJJJJJJ KKKKKKKKKKK

I am creating a webpage in MS Publisher 2003. I have a order form that I would like to automatically calculate the total. Will MS Publisher allow me to do this?

Is there a formula that can ne performed if the group header is carried over to a new page then the paged header is suppressed?

When I try to export my Crystal Reports I get the following error message "Failed to Export the Report". When I click the 'Export Report" button, I select the following from the drop down boxes: Format: Acrobat Format (PDF) Destination MAPI I am using Crystal 10

Is there away to use a formula to bold a crystal report field? Lets say that I have crystal report fields named 'Field1', 'Field2' and 'Field3' that contains the following information: Field1 Field2 Field3 Car 2 blue Trucks...

I need to know how to make data that displays on the report be suppressed if it is duplicated. For example, Jack B, Sue L, Chris P, Ted V, Jack B, Sue M, Ted V, Chris R, Chris P, Mike N, Mike N I need the information to display on the form like this, Jack B, Sue L, Chris P, Ted V, Sue M...

Has anyone ever heard of a ghost header in crystal?

Does anyone know how I can sort by one group and then by another alphabetcally?

I am trying to come up with some formulas to perform the following: If I have results that are incomplete, how do I create a formula to count the incomplete resuts. I want to be able to count the incomplete results that are >14, >7, and within 7 days. Can anyone help with this?

Right now when the data/text is displayed on the crystal report is displaying like this: Hey There Man But, I would like for the data/text to display like this: Hey, There, Man, etc.... Does anyone know a way to get the data/text to do what i want?

I am trying to create formula to produce three significant figures. The formula I have come up with thus far is as follow: ROUND(val({FLATDATA.ACOM}),2-(1+INT(ABS(val({FLATDATA.ACOM}))))) However, when I try to view the report, I get the error message "The number of decimal places is too large...

I am trying to get an old application to work with Windows XP Pro. Each time I try to install the application, I get the error message "this application requires 386 enhanced windows". Has anyone ever ran into this problem? If so, did you finad any solution? Can 386 enhanced work with XP?