Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: saltcoats
  • Content: Threads
  • Order by date
  1. saltcoats

    Add a day to WeekToDateFromSun

    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
  2. saltcoats

    splitting yesterday DateTime field into shifts

    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...
  3. saltcoats

    Unable to connect: incorrect log on parameters. File

    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...
  4. saltcoats

    Distinctcount on two tables

    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...
  5. saltcoats

    New Page by Group

    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...
  6. saltcoats

    Summary Formula by Field Selection

    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...

Part and Inventory Search

Back
Top