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!

Register Log in
  • Congratulations derfloh 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: *

  1. cardimom

    Selecting time range from each day of the month

    Thanks this works, but I want to get a total of bytes transmitted for those times. The 10am-6pm I grouped by change of day and that works great. But how can I group the 6pm-6am and get just that time range.
  2. cardimom

    Selecting time range from each day of the month

    Now I have another problem 10 am - 6pm works great but I also need 6Pm-6AM and I changed the time to reflect that but it gives me the times I dont want like 6am-6pm too
  3. cardimom

    Selecting time range from each day of the month

    Thank you so so much!! I knew there had to be an easier way. Believe it or not. I am learning.
  4. cardimom

    Selecting time range from each day of the month

    I made progress it works like this but is there an easier way then having to add each day? {@JobEndTime} in DateTime (2007, 03, 01, 10, 00, 38) to DateTime (2007, 03, 01, 18, 09, 29) or {@JobEndTime} in DateTime (2007, 03, 02, 10, 00, 38) to DateTime (2007, 03, 02, 18, 09, 29) or...
  5. cardimom

    Selecting time range from each day of the month

    Sorry about not answering correctly. Yes, FtOperationEnd is a datetime field. 3/23/2007 7:50:41PM This how the datetime field looks. I replaced what was the command with your command and got Failed To open a rowset. Details 42000Sybase ODBC Driver Syntax error or access violation. Thanks,
  6. cardimom

    Selecting time range from each day of the month

    Thanks. Yes I want to select certain time frames. This did not work.
  7. cardimom

    Selecting time range from each day of the month

    I need a report that shows "FtOperationEnd" from various time ranges like 10am-6pm for each day of a month. I can get one day by using select but not just that time range for multiple days. I cant do a parameter because the report is based on the following command and the FtOperationEnd does...
  8. cardimom

    Updating combined querys

    I need to automatically refresh combined data from several querys from different databases on different servers. The data fields are exactly the same except for the server name which I need to compare data.I have made the same query for each server and correctly receive the data. I then return...
  9. cardimom

    Linking tables

    I have two database tables that do not have anything in common data wise. One table holds pc system numbers and the other lists the name of a server that the pcs are assosiated with but not the pc system numbers. So all the pc system numbers are related to the name of the server but when I try...
  10. cardimom

    Merging multiple database data

    They do all have the same username and password, but because of the size of the DBs they cant all be on the same server.
  11. cardimom

    Merging multiple database data

    Hi, I have asked this several times but never got a workable solution. I have seven servers that I would like to combine the data from into one report. The Data that is being pulled is from the same fields on all of them. Right now I run them separately and manually go through them and...
  12. cardimom

    combining multiple databases

    Thanks, the databases are Veritas Netbackup Professional. I use ODBC(RDO) to connect. Using UnionAll I still get table.machines_1 not found. Do I have to distinquish between the servers somehow. The report shows all the backup profiles and how many pcs are assigned to each profile. Everything...
  13. cardimom

    combining multiple databases

    I tried that but I keep getting errors. I can see all my servers in the Data expert, but all the tables are the same so when I go to add the other servers tables I get "The table "engine.machines" has already been added to this report with alias "engine.Machines", do you really want to add...
  14. cardimom

    combining multiple databases

    Hi, I have seven servers that I would like to combine the data from into one report. The Data that is being pulled is from the same fields on all of them. Right now I run them separately and manually go through them and combine the data which is quite time consuming. I can make subreports but...
  15. cardimom

    Selecting data

    My data is in the form of mm/dd/yyyy hh/mm/ss.I have numerous dates with varying times. I want to select all the data with a particular time like 12:00. The select option shows all the dates and times but how do I just get the ones that show 12:00. I either get them all or only one day. I need...
  16. cardimom

    Time conversion needed

    I need to find the time something is taking. When I subtract the end time from the start time I get this. How to I convert it to hours/minutes/seconds. 8/3/2004 12:40:23 PM - 8/3/2004 12:40:28 PM = 56,561,766.40 Thanks
  17. cardimom

    Ufl dll help needed

    The database is Veritas Netbackup Professional. A Veritas report from within the Veritas console comes up correctly and shows the time a backup started as m/d/yyyy h:m:s am or pm so 3/30/2004 8:16:24PM.When I export the report to crystal the report will not open and says that ufl is missing...
  18. cardimom

    Ufl dll help needed

    Thanks, I used regsrv32 "path to dll" I put it is system 32 and now the message says that the specified module cannot be found. It is crystal 9 and was exported from crystal 9
  19. cardimom

    Ufl dll help needed

    When opening an exported report I get "ufl that implements this function is missing." I have the .dll that it is referring to. How do I get crystal to see it? I did try to register it but I get a message that the dll was loaded but the dllregisterserver entry point was not found and the file...
  20. cardimom

    Formula needed

    Thanks for your replys. The database is Veritas Netbackup Professional. A Veritas report from within the Veritas console comes up correctly and shows the time a backup started as m/d/yyyy h:m:s am or pm so 3/30/2004 8:16:24PM.When I export the report to crystal the report will not open and...

Part and Inventory Search

Back
Top