Recent content by Regelos

I've recently taken over a installation of BOE 3.1 Most reports seem to run but some crystal reports refuse to run at all and timeout(Timeout. [RCIRAS0244] ) or if I schedule them they will proccess indefenatly until I reset the sever(and then it will finish proccessing almost instantly but...

that worked thats great

Select 'Created' as type, DocumentChangeRequest.RequestCreatedDate as alldates, DocumentChangeRequest.RequestID,DocumentChangeRequest.Status From DocumentChangeRequest Where DocumentChangeRequest.Status <> 'Withdrawn' and DocumentChangeRequest.RequestCreatedDate >= DateAdd(Year, 0...

I'm off a stander MS sql source.

dateserial isnt a valad SQL command I'm going to try to find what command can replace it thank you.

this is my exact selection formula {DocumentChangeRequest.Status} <> "Withdrawn" and {DocumentChangeRequest.RequestCreatedDate} in dateserial(year({?Run Date}),month({?Run Date})-17,1) to {?Run Date} or {DocumentChangeRequest.RequestClosedDate} in dateserial(year({?Run Date}),month({?Run...

and I need to chart number of requests created and requests closed for the past 18 months on 2 seperate line graphs

requests created

basically right now I'm selecting the last 18 months of requsts created and trying to chart when the complete >though I've been considering changing that selection but that works for now< the problem is I dont have a uniques field that creates the 18 months seperate no.

its crystal xi I want to go back 18 months with the months down the bottom then 3 lines (or bars doesnt matter I can change between the 2) One that shows Number opened per month (wich is one field opendate) Number closed (closeddate) and number that basically have no close date.

I am working on a chart that shows 3 values per month number opened number closed and number left open, for an 18 month period. I have tried a few things and I cant figure out how to properly format this data to accomplish what I need to do.. anyone have any ideas?

anyone have any ideas?

I have one more question this is a report I walked into and it took me long enough to figure out the report logic that was written. What it does now is take 4 week forcast from this long field converts it then figures out the current week (based off current month) steps foward that many places...

thank you you are awsome

I will try your suggestions but let me clear up what I am talking about I have multiple columns I want to key off the part # collum (wich I already have but then I have this quote column data is generally like this Part# can have multiple quote years 2006,2007,2008 etc.. All I care about is...