Search results for query: *

Hi all, I have a report that lists multiple machines. The machines contain a single value (lineal feet output). Out of the multiple machines in my report I want to capture "Lineal Feet" output of just one and save it to the bottom of the report to do calculations. I am assuming I will need...

I know I have done this many times before, but today I am getting an error. I am passing a date range parameter to a subreport. Then I create the following formula in the subreport as follows: Minimum({?Pm-?Ship Date Range}) Seems straight forward, right? But I am getting an error, "This...

Thanks much. It works. !! Excellent. Paula

This SHOULD be a no easy but it's not working. I have Excel 2003 In column A I have Text. If the value in column A = "PROJECTION" THEN ADD IT UP, OTHERWISE DON'T. Column B has the $$ values. So my Sumif formula is =SUMIF(A1:A800,"=PROJECTION",B1:B800) Am I missing something? Thanks so...

When I run all my reports, Crystal prompts me with "Please enter date with format "yyyy/mm/dd". I would like the parameter date format to be mm/dd/yyyy or mm/dd/yy. I have tried formatting the actual parameter field. I have used Report/Options and changed Date and Date Time to be in the...

Never mind...i am using this: =+B2+0.125. Work fine, including switching to the next day.

Thank you all for your help. I ended up using the following formula, which works perfect. =IF(A2="","",IF(B2="",NOW(),B2)) I have another issue. This Worksheet is run on Terminal Server, which has west coast time. It is being accessed by folks on the east coast. How do I add 3 hours to...

Excel Office 2003 I am creating a timesheet. When a person enters their name, the cell next to it has the following formula. The formula just creates a date stamp. =IF(L7>"",NOW(),"") However, it's my understanding that the formula is "volatile" meaning, as soon as the next row is entered...

I used the feature of creating a Crystal Report from Excel in Excel 2003. I installed Excel 2007 and now I get a "File Integrity Error" when I use the Crystal Add-in. Do any of you use this add-in with Excel? Crystal Version 8.5 Excel 2007 Thanks in Advance. Paula

I used the feature of creating a Crystal Report from Excel in Excel 2003. I installed Excel 2007 and now I get a "File Integrity Error" when I use the Crystal Add-in. Crystal Version 8.5 Thanks in Advance. Paula

Lbass, Thanks so much. Works perfect! Paula

Crystal 8.5 - MAS200 Providex database I am creating labels (3 across) based on an vendor invoice history file. But I only want to create one label per vendor, not one label per invoice. Therefore I created a group (VendorNumber). The problem: When I move the label information to the...