Search results for query: *

I have a simple spread sheet that lists reqirement number (D:D) and a testing status (C:C) (No Run, Passed, Completed). I need a fomula that returns the Requirement Number with the status of the lowest status. I created the string below to assign a numeric value to the status. =IF(C119="No...

Project 2010 Created custom Start Date 1 and Finish Date 1 -- how do I calculate the duration in whole days? It seems that for Duration : if I subtract Finish Date 1 from Start Date , I get a decimal number. I'm sure it's simple and I'm way over thinking it. Thanks Laurie

Is there a way to auto create a version # in a workbook. Then insert to display in a cell? Thanks- Laurie

Is there anyway to add risk to a project in '07 without project server. I have several xls files, but I have several projects and it would be easier to have risk in the same place as the WBS. Thanks!! Laurie

I'm not sure I've ever had this problem. I'm using Word 2003 sp3 - when I hyperlink a phrase to a document on anther server, I end up having a temp link. For instance I'm linking to this path: \\IS_Project_Folders\1-SOW\BR01_Ded OOP Footnote\Ded OOP footnote.xls and end up with this...

Hi, I though maybe someone could answer my question... typically I use Crystal 9, but have a SQL question... the field claimant_name on claim table has last-name*first (example: COOPER*LAV). Do you know how to get the last name only out of that cell (the part to the left of the *)? Thanks...

I though maybe someone could answer my question... typically I use Crystal 9, but have a SQL question... the field claimant_name on claim table has last-name*first (example: COOPER*LAV). Do you know how to get the last name only out of that cell (the part to the left of the *)? Thanks for...

Hi All, I've got Crystl 9 and SQL. I've got a report created to summarize sevral invoices. Problem I have is the freight is at the header level and when I place the field {inv_hdr.freight} in the group (group by invoice number) then I get the correct $ amount; however when I sum the field it...

I've got this formula, and I can't seem to find the error. Any ideas? I'm sure it's right in front of my face. Thanks! Laurie =IF(iserror(VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE)>=VLOOKUP($C262,'[LowesTemplates -...

Hi there, I'm running Crystal 9.0 / SQL I've run into an oddity, when exporting a report into excel, the date is returning ()10/6/2006 for a few lines. When I select the cell in excel, it looks normal as well. It looks just fine in Crystal and I’ve not had this happen before that I am aware...

Crystal 9 /SQL I've got a report that pulls from both an excel file (provided by client) and our SQL DB. I'd like a select statement to only select items that have a product code of 'FG' from our DB, but include any locations from the excel file that do not have an order associated with it...

I have a column in Exel that will not auto fill down. Any tips you might have? I didn't know if it was due to the alpha numeric. Thanks- Laurie Sample Data 9979F 9980F 9981F 9982F 9983F

Hi - easy question... I'm using Crystal IX and SQL Is there a formula to select records with a due date of the current month? Thanks- Laurie

Hi - I've got a question. I've got Crystal 9/SQL Current record select formula: {matltran.trans_type} in ["F"] and {matltran.trans_date} = Today()-1 and {item.product_code} = "FG" or ({matltran.trans_type} in ["M"] and {matltran.loc} in ["HDC"]) and {matltran.trans_date} = Today()-1 and...

I've got a pivot table pulling from multiple ranges on several pages of a workbook. I added a page to the wb as well as adding it to the pivot table. Funny thing, the items show up in the column but the quantities in the data portion only show the previous pages... is there a limit to how many...

Crystal 9 and SQL Ok, I've created a report with a sub report, linked ledger fields, grouped by like fields and did the formula thing to sum the two totals together - I must say I'm proud of myself... I didn't even have to ask :) On to the stupid question... I have another weekly report -I...

Good Morning. I'm running Crystal 9 on SQL. I've created a basic report detailing item and last ship date. I've got a formula to pull the maximum ship date and need to create a formula to group based on the following criteria. >180 days 121-180 91-120 61-90 0-60 When I try to group on the...

Not sure if this can be done, but I have a crosstab report that spans several pages. I only need the 1st page to print and discard any addtional columns, is there a way to supress colums after the 1st page? The dates are dynamic, so I can not specify a cut-off date. I'm working with Crystal 9...

hello, Crystal 10 / SQL I've got a simple crosstab. I'd like to filter with the top ten results in the row totals. The object to to list the top ten customer with the higest rate of late shipments. Any ideas? Current crosstab looks like this: Customer # shipped Late Acco 2 Amerock...

Hello, I'm using Crystal 9 with SQL. I have a list of items {item.item} that I would like to group by only the 1st 8 didgts. Expected output is: C1550316 (group) C1550316-CT1 (detail) C1550316-CT2 C1550316-CT3 Thanks- Laurie