Search results for query: *

I am trying to do a record select on a DateTime field using WeekToDateFromSun, but the data I am trying to report on starts on Monday morning, not Sunday morning... How can I add 1 day to the WeekToDateFromSun formula? Any help would be appreciated. gpk

Thanks, this is excatly what I want, sorry for the confusion. I didn't say it but I previously just subtracted from the current dateTime to get the shift. Thanks again gpk

Thanks, I still have the problem of splitting out the times to group the shifts gpk

I am trying to create a report on CE10 on a DateTime field. I would like to schedule a Crosstab report today that would capture workorders completed yesterday. I have grouped the Rows into the different Trades and the columns into shifts i.e. 12am to 8am shift A 8 am to 4 pm shift B 4 pm to...

Thanks LB What we are trying to measure is the the time it took to complete or close a workorder after it was created. The issue we have is that there may be other statuses between WSCH and COMP 259873 WSCH 10/17/2005 3:10:00 AM 259873 APPR 10/18/2005 3:10:55 AM 259873 INPRG 10/18/2005...

We are using CR 10 on Oracle 9i We are having a similar issue. We are trying to measure the date and time difference between two statuses on the same wonum. The WSCH to the COMP or CLOSE status, whichever is earlier?

Thanks K for the quick response.. the servers/services in question all run using the a Local System account. -- This seems to be ok for our other CE installation, for some reason thought it errors out even though the reports run fine thru Crystal Reports 10. ???

I can run and view a report in Crystal Reports 10, but when I publish the report to CE10 it then errors out with the following message: Status: Failed Printer: The instance is not printed. External Destination: None Data Refresh Settings: Use the server defaults. Start Time: 7/15/2005...

We are using crystal V10 running against Maximo v4.3 on an Oracle Db. We need to find out how many pieces of equipment are being maintained in our PM system. Currently we retrieve this data from two different queries that are referencing two different tables, i.e. the PM table and the Route...

Thanks.

Thanks, this helps. I am still not capturing current date though. Do I have to schedule it the day before? i.e. {table.datetime} in currentdate to currentdate + 8

I have a similar problem; I am running CE10 against an Oracle Db. I scheduled a report to run at midnight Sunday night with the selection of Current datetime to currentdatetime + 7 based on a date time field. By the time the report runs it is 12:01am, or later and I miss the data that has a time...

Thanks Bob, this is exactly what I wanted. Gerry

Hi, I have checked what you said and I am still getting a blank page before my first group. Gerry

Hi all, I have a report which has two groups. The problem I am having is I want to to start a new page on my first group. When I go to the Section Expert and select the radio button for either "New Page Before" or "New Page After", I get a blank page either before or after each group. I really...

Thanks for the help this is just what I wanted. Gerry

Hi all, I am attempting to do a summary formula that will give a count of field1 if the value in field1 is one of x, y, or z. I cannot group by the field, as I already have my groupings, I cannot do a summary as it does not select just the ones that I want included. I am using CR10. Any help...