Search results for query: *

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

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

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

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

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

Hi Crystal reports shows a date/time value as 1.27e+017. The data is shown as 127264599743590905 in the database table. How do I convert this to a readable date/time? Thanks Di

I am pulling a field "LastCompletedBackupTime" and what I get is 1.27e+017. Can I get this to be a real time? Thanks, CorgiMom

I am attaching to a Sybase SQL Anywhere data base. I have to refresh reports every morning. Can they be automatically refreshed and then automatically sent out in email? If so where do I start and what version Crystal do I use? Thanks

Hi, I am figuring out how many backups complete per hour. I am selecting on the completed backup time by between hours, but I have to keep changing the between time for every hour. I have three servers and it is taking me forever. Is there a way to display my results without having to change...

I have a report that I grouped by department when I add the users the departments that have no users are not displayed anymore. How can I show all the departments even if they have no users yet. The only fields I am using are departments and users. Thanks

Hi, I am trying to make a chart that will show the days of the month on one axis and the hours 8am through 7am,ie: 7am,8am,9am etc back to 7am on the other axis I want the start time of a server backup and the end time of that backup to be shown on the chart. It is driving me crazy as if puts...

I have a report based on a query. I want to have a total of a field. I use the formula NumberVar s:=Sum({Query.Total Data}) I keep getting "A number field or currency amount is required here" I have used this in other reports and it worked. There also so no sum option for grand...

I have put reports on an intranet site, but when I want to refresh them I am asked for a user ID and password. I have no idea what it is. I have admin rights and set up the intranet site and have added myself everywhere. I don't think it is a IIS rights thing. When I set up the ODBC driver...

Hi, Can I add something to my report that is not in the database. I have a computer system number and a user id and I want to add the users full name. I know that I will have to type the users names in. Can I associate the users name with the users id or some other database field so that it...

The field I need to use shows the time as 6 hours later then the actual time. How do I change this to my current time which is that field - 6 hours. The field is lastbackuptime. I tried lastbackuptime- 6 but that didnt do anything Thanks Cardimom

I have the following fields in my report: Profiles Users PC System # I have Grouped by profiles I have it all the way I want it Admin rut3498 198888 Admin abc1234 345678 total Admin 2 Marketing swe1111 222333 Marketing rry1114 456333 Marketing...

I get my report the way I want it and when I refresh it the sorting gets all mixed up. How do I fix this? Thanks Cardimom