Search results for query: *

Please forgive me if this question is really simple, but I am a relative novice and haven't had to do much coding in years! I am calling a Crystal Report (8.5) from VB6, and then trying to export in a PDF format. I think I have the correct code, but I am having problems making the connection...

The following fomula keeps generating an error in CR7 (forced to use 7 on a legacy system): if isnull({eeCompensate.PayRate}) then 0 else if {eeCompensate.PayRate} <> 0 then Sum ({RegData.RegValue}, {eeEmployee.eeLink}) / {eeCompensate.PayRate} else 0 The...

We are upgrading one of our apps, and part of that process is a conversion of the database (on SQL 2000 SP3). The vendor provided us with a tool to do the conversion that reads from the old database and writes into a new database. Both databases are on the same physical SQL Server box, and...

We had a stored procedure that was taking 42 secs to run on our production SQL Server, and only 10 secs to run on a development server using a copy of the production database. The production server has a lot more memory and processors (it is actually a cluster of 2 SQL Servers--one as a...

We have two developers who both at times need to make changes to a handful of Views for some of their own internal reports. However, to my knowledge the only way to allow someone to make a change to a View is to either be the View's owner or the database's owner. If there ay other way to set a...

The SQL account NT Authority\System was deleted by mistake. I re-created it, but I do not know the original password it was set-up with. Under Current Activity I can see that there are still two processes running dated before the account was accidentally deleted--SQL Agent Alerter and SQL...

I had some backup jobs set up, but then the database was changed from a Full recovery model to a Simply recovery model. My understanding is that in a Simple recovery model, the entries in the log is cleared when a transaction is completed. However, I am now getting backup errors for the...

I have only used Crystal Reports for very basic reporting, and so I am not familiar with a lot of the more advanced techniques. My experience is more with writing SQL scripts, but this report has to be done in Crystal (8.5). I have a series of tables where all the records have CreatedDate and...

I have created a simple report in Crystal Reports 8.5 that joins 2 tables, returning 1315 records. When I add a third table as an outer join, Crystal then only returns 58 records. I thought it might be a problem of not finding matching records in that 3rd table, but when I copy the SQL from...

We are being audited. One of the requests was a some sort of evidence that specific users have only certain levels of access to several databases. Short of taking about 50 screenshots per user in Enterprise Manager, is there any way I can get a list or report to indicate: 1. Server Roles...

We are installing Reporting Services onto 2 SQL Servers. On the first server, we installed using a Windows Domain account name that was granted System Admin rights in SQL for the install process, and then we took away those rights. This was how the account was set up in SQL...

Hello Everyone, On one of our SQL Servers, I want to allow a user to be able to add or modify things like Views and Stored Procedures, including granting permission to them if possible. However, I do not want him to be able to add or modify any other kind of user security. Is there a fixed...

Hi Everyone, Simple question: when exporting data from a SQL Server 2000 database into a CSV file, I want to avoid exporting the column names (Row 1). Under "Transform Data Task Properties" and "Options" I set the "First Row" to a higher number, but it still keeps exporting that header row...

Hi Everyone, I have a table where several different records are related to each other. This table is then LEFT OUTER JOINed to another table to add a FirstName and LastName field. For example: Emp_No, Trans_Type, Value_Type, Value, FirstName, LastName 1234, "New Hire", "First_Name", "Joe", ...

Hi Everyone, I was asked to do some support work on a legacy app originally developed in VB with Visual Studio 6 SP4 on a NT 4.0 workstation. At the time, there was no problem creating an installation package through the package and deployment wizard. Now I have Visual Studio 6 with SP6 on...

Hi Everyone, I am trying to do a LEFT OUTER JOIN between two tables. Table 1 is an Employee table, and Table 2 has zero or more special custom records for each employee in Table 1. I want to return a row for each Employee in table 1, and also return a value from Table 2 when the idType = 5...

Hi Everyone, One of our programmers cannot see the objects that she owns when she uses Enterprise Manager. I have set her up with a SQL account and she does have permission to create Views. She also has Datareader and Datawriter roles on the database. However, on the list of Views in...

Hi everyone, I have a couple of servers registered in my Enterprise Manager. These were recently moved to new IP addresses, so I want to remove or alter these old registries. However, whenever I try to do this in Enterprise Manager by right-clicking on the node, it keeps returning an error...

Hi Everyone, I am working on an Expense Statement. On the statement there is a line for each expense entry: Item GL Number Amount Entertainment 10000 $75 Parking--Airport 10001 $50 Sundries 10002 $20 Parking--Downtown 10001 $100 At...

Hello Everyone! I am trying to connect to an Access 7.0 Database using VB 6 and ADO. I am really bad/rusty with this stuff! Anyway, when I run it from my development computer either from within VB or as the installed application, it is fine. When I install it elsewhere, I get the following...