Search results for query: *

I am doing work for a client who uses SQL Server 2000. I told them I need to log into the server as the Windows user the SQL Service is running as so that I can set up some drive mappings and such that they need the server to have. However, they informed me they lost the password and have no...

I have a table called "CLAIMS". It contains these fields among others: MemberID ClaimID PaidAmt ProviderID ServiceDt PaidDt A ClaimID can be adjusted and contain multiple lines (for example, a claim is paid at $59, then a second line may take back the amount ($-59) and a third line may repay...

I am attempting to link some Word Docs in my Crystal Report (8.5) using OLE. I am linking them, not importing them. But the Headers and Footers in the Word Doc are not part of the "link". Is this a setting? Is there a way to have the entire document show up? I'm guessing no but I just need...

CR 8.5 I am printing a check. It's portrait 8.5" x 11" and is perforated 1/3 of the way down and 2/3 of the way down (check on top and then two duplicate stubs - one we keep, one we send with the check). The stub contains detailed info about what customers used a service, etc. Sometimes the...

Crystal 8.5 IE 6.0 SQL 2000 We have a checkwriting app that we built in-house on our intranet that links to our claims payment system so we can easily cut checks. It has been working great for almost a year. Recently a request was made to add more info to the check itself. The info that was...

Crystal Reports 8.5 We have a Check Writing intranet app written in Cold Fusion with a SQL 2000 backend. The checks are printed through a Crystal Report accessed from the browser. The user simply clicks the Lightening Bolt and then clicks Print. The issue is if the user prints one batch...

We have a server named LSSQL02. It's getting old and out-dated so we ordered a new server. The new server has come in and the Network Admin installed Windows 2K and all that fun stuff. He named the server LSSQL04. I installed SQL2K and Analysis Server. Now the powers that be want me to move...

SQL 2000 standard No Service Packs (we had taken them off recently to test something) Our Network Engineer is also our de facto VB.Net developer for small projects. Since he is the Network Admin, by default he is a member of the BUILTIN\Administrators group. This group does have full access...

We have a report that's a letter that we used to run one at a time that we are now running in batch. Because of this, I need to move the report footer "stuff" into the detail so it gets printed with each letter. Is there an easy way to do this? Thanks! Craig

I am trying to delete a parameter I don't need anymore and it keeps telling me I can't delete it because it is being used in the report. I have checked all formulas and all sections to make sure the parameter isn't involved in a suppression decision. Is there a way in Crystal I can search the...

I'm sure this has been asked before but the Keyword Search is temporarily down so I can't search for old posts... I need to re-order the values in the Legend of a chart. They are currently coming up in alpha order and I need them in the same order they are in the paper report that this report...

New page when group header changes I know this is probably simple but I can't seem to figure it out... Any ideas? Thanks!

For some reason, one of my replication jobs got stuck at running this SP today. Now all other replication jobs trying to write to this table are waiting as my spid has placed a table lock on sysjobhistory. Needless to say, replication is not happening. The message in the Replication monitor...

I have a provider directory on the web that returns results in alphabetical order by provider office name when you enter a zip code and a mileage radius. However, we are finding that the locations that show up on the top of the search (a, b, c, etc) are getting a lot more referrals than those...

I have an Access DB that if I simply double-click on to open it gives me this message: You don't have the necessary permissions to use the 'S:\EAP\EAPExpert\EAP.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you...

Ever since I upgrade to SQL2000 I cannot access my MS Access linked servers through Microsoft.Jet.OLEDB.4.0. The message I get is: Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' reported an error. That's it. Any ideas? Do I need to change any settings? This worked fine in 7.0...

Hi- I don't know if this thread will get any responses but I was wondering if there is anyone else out there in healthcare that will be dealing with sending HIPAA compliant X12 EDI transaction sets using data that currently resides in SQL Server. If so, are you planning on using a 3rd party...

SQL2000 on Windows 2000 server... Can anyone tell me why when I use the xp_sendmail XSP, SQL Mail works fine... But when I want a job to send a mail to say it has completed (either way - success or failure), it never does? The history of the job just says: "Note: failed to notify DBA via...

I have developed a small application in Access that allows some of my CSR's to do quick form letters and print them out. The problem is, when I click the print button I put on the form(s), the forms go to a specific printer that is neither their default printer nor mine. The...

This may be a little obscure, but I'm hoping some else has run across this... I download files from an external FTP site that are encrpyted using PGP. So after I download them I need to run the command line PGP utility to decrypt them. It works fine. Here's the problem... I am trying to...