Recent content by cardimom

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.

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

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

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

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,

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

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

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

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

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.

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

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

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

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

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