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 dencom 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: Crewdawg
  • Content: Threads
  • Order by date
  1. Crewdawg

    Mailbox Managment Policy deleted 13GB and I need it back!

    I am a new IT Manager and I made a mistake today, a big mistake. Let me start at the beginning and excuse the long post, I want to be thorough so you can understand my plight. We run an Exchange 2003 SP2 on Windows Server 2003 SP2. We currently have around 200 Mailboxes. Our backup system is a...
  2. Crewdawg

    Use Visio Pro to map a file server directory structure?

    Is it possible for Visio Pro to automatically generate a map (diagram) of a file servers directory structure? I would like to map out how we do it now and use this to propose a new strucutre. If it not possible in Visio. Is there a program that can do this? -Sean H...
  3. Crewdawg

    ToText evaluates the same number differently.

    I am running CR 10 on SQL2000 via OBDC. I have a report which summarizes times for payroll. I use the following formula to convert the database text field which stores the time in the hh.mmm format into minutes. (truncate({TIME_DURATION})*60)+(({TIME_DURATION}-truncate({TIME_DURATION}))*100)...
  4. Crewdawg

    ToText evaluates the same number differently.

    I am running CR 10 on SQL2000 via OBDC. I have a report which summarizes times for payroll. I use the following formula to convert the database text field which stores the time in the hh.mmm format into minutes. //@ActTimeConv...
  5. Crewdawg

    Running Total based on Formula in Group Footer

    I am using CR10 on a SQL2000 Server via OBDC. I am creating a summary for a payroll report which summarizes total hours as well as how many of those hours were regular or overtime. The report is grouped by Employee Code (as in Intials, also user name in DB). I have a running total which adds...
  6. Crewdawg

    DateTime Parameter only ask Date

    I have report in which rows are selected by a DateTime Parameter. I only want the parameter to ask for the Date since the time should always be assumed to be 00:00 (Midnight) for the start date and 2359 (11:59 PM) for the end date in this report. How do I convince Crystal to only ask the date...
  7. Crewdawg

    Create a table from two other tables.

    I need to create a table based on the structure and data in two other tables. These source tables both contain the same structure. I have tried the query as follow, which results in a syntax error: DROP TABLE COMB_LABOR CREATE TABLE COMB_LABOR AS (SELECT 8 FROM "GDB_01_8"."DBO"."WOMNT_LABOR"...
  8. Crewdawg

    Improving Syntax on this formula.

    First off I want to say bear with me on this. I may leave out some key piece of information here so just post what other information you need to understand what I'm showing you. This report shows our "Planned" and "Actual" times on individual jobs on a Work Order. It has a line for each job...

Part and Inventory Search

Back
Top