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

Thanks for the info.

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

Thanks Brian that worked wonderfully. On to my next task,I must also peform similar calcuations finding a date with a weight that is 60/90/180 days prior to the current weight. I tried accessing these values by. Datevar array datearray; Numbervar datecounter; Numbervar array wtarray...

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

When I declare the variable in the second formula, does it retain the value assigned from the first formula?

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

The report is grouped on Patient ID, I want the last 6 for each group. A person may not have 6 previous weights, this could occur if they are newly added patient. I am report off of a SQL enterprise database. I am using Crystal reports version 8.5.

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

The Novell Connection shows up in My Network Places. Client for Microsoft Networks,Remote Managment,File and Print Sharing , NWLink NetBIOS, NWlink IPX/SPX and Internet Protocol are all checked. I enabled Netbios over TCP/IP and rebooted. Still unable to see the entire network. (Thanks)

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 am using crystal as a way to print forms that are normally handwritten. I inserted the form in the details sections. ( I do want it to print for every selected record). The database fields Name etc are in the page header. When I run the report, the first person always appears twice (For...

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?

Thank you, both suggestions have been very helpful.

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

Thanks for the help,their was a problem the dsn on the other pc