Search results for query: *

I have a report with from 2 databases with just a few tables added. I am getting the data I need the but… I only want one set of data from each database. I am comparing orders written by physicians to the associated charges stored in the finance system. . From the orders table I am getting one...

I removed the domain settings from my Windows2000 PC by adding a workgroup. After the reboot,I am unable to log into the pc even with domain/userid & password. Is there a way around this if I don't know the admin password other than a re-image? I tried booting up in safe mode was unsucessful, I...

CR v8.5 SQL DB I am writing a report to calculate weight variances for 30 60 and 180 days. The formula is 100- (current weight / previous weight). I thought I should put the weights and the dates in arrays and make comparisions. I ended up putting the weights in an array that resets the...

I am working with CR8.5 and reporting off of a SQL 2000 DB. I created this array to store weights. I am unable to access the contents of the array from another formula. Numbervar array wtarray; global Numbervar counter; counter := counter + 1; if counter <=1000 then (redim preserve...

I am writing a crystal report in which I will need to hold 6 previous weight values & the dates associated with the weights so that I can peform calculations. The weights are not always present. Can someone give an idea how to do this. For example 1/1/2002- 120.1 1/7/2002- 121.4...

I am new to PDA's, I thought this would be the best place to ask. I would like to have ebooks read to me via a pda. What type of device would you recommend for this purpose?

I am currently using a BEFW11S4 Router. I have shared a directory on one of the pc's running XP home. File sharing and Printing for Microsoft Networks is enabled on both PC's (the second is a Windows 2000 machine. I the directory to be shared by right clicking on it a checking the properties on...

I have an XP Pro machine with a novell client loaded on it. I am unable to browse the entire network as in 2000. I found a fix on microsoft.com but I am not sure it applies to this problem. Maybe it wasn't configured properly on install. How can I correct this problem?

Is their and option in XP to select password never expires like windows 2000? or does the password automatically never expire. MP

We recently moved our database and upgraded to sql enterprise as well. Initially none of the crystal reports worked. I reconfigured the file data sources on the citrix servers where the reports are run from. I run my repors locally but also have an install of SQL Server. On a PC with a...

I created a report with an excel spreadsheet in the details sections. The Page Header contains database fields. The first record appears 2 times and the details for the last record is missing. How can I correct this problem?

I am writing a report that generates a form with client information. Rather that recreate the form in Crystal. I would like to drop the file (Excel) into the document as if it where an image. Is that possible or is there a better way. Also is it possible to print double sided? or should that...

I created a report from a SQL Server database. I am able to run the report but others receive the error unable to locate pdssql.dll, the dll p2ssql.dll is present on the workstation in c:/winnt/crystal directory. I tried changing the driver to pdsodbc but the report does not work. I was not...

Does anyone's IS shop allow users access to Enterprise Manager to query against the database? If so will the role dbreader be enough so that they cannot create objects on the database?

I am exporting a report to text, the report is a copy of one I've used on 3 other occasions. Only this time when I export the data, there is 1 space before each detail line. I checked the data, it does not have a space preceeding it. I also added trim to the line I am outputting. (all the...

I have been assigned as the primary MIS contact for a new project. The project is a small one for our department. It requires set up an configuration of a server, installing client workstations and some other things. The vendor for this project has been selected. I have not been responsible...

I am not a Network Engineer but if I am not looking for a solution, I am part of the problem. We are having issues with printing via Citrix. Please forgive my specs I will list the as I know them (Please let me know if I should include something more specific, I can look them up); Windows 2000...

I graduated a year ago and started work as a Systems Analyst the day after I graduated. I really did not have any guidance in this positions since it was newly created. So I just did what ever anyone needed done. I work in a small shop, there is only 6 of us for 450 users. Because of all that...

I am attempting to round up to the nearest quarter on 1005680VW_SC_PASSPORT.DIRECT_DURATION} the Duration is given in minutes. I divided these minutes by 60 to get total hours. I need to round up to the nearest quarter. I have a value of (95/60) = 1.58, the business side wants it rounded to...

I am writing a report to export billing data for Passport services. I need to set a contract year based on the date of service. I am trying to write please excuse the psuedo code: IF service provided is between 7/1/02 - 6/30/03 then contract year = -7. I am going to need to do several years...