Search results for query: *

Thanks! I had done some searching and had looked through a lot of posts, but somehow I must have missed this one (I blame fatigue and noobishness). Thank-you again...it seems to have worked.

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

Thanks. I did end up using ToNumber(), but I am just not sure why I would have to in the first place. Does CR not consider a Money field to be a number?

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

It is an application, and so I cannot see what is actually being done. We are building another server to try reading from one and then writing to another. Hopefully it works!

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

Thanks everyone. Can I limit the ddl statement access to only certain objects though? It's their Views--they can do whatever they want with them--but I don't wan them to touch anything else.

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

Hi lbass, I finally got to implement your suggestions, and it is fantastic! I had to make a minor change to add a check for a NULL on the EndDate field, and I also had to add a lot more running total fields to add some sub-totals/grand-totals. I have learned a lot from this exercise, and I...

Hmm...I inherited these databases and they all had a NT Authority\System login in place for running the Agents/Services. Is that not a standard Windows security login to do this? Should I only be using the BUILTIN/Administrator login to do this? I was curious as to why there were both setup...

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

Thank-you very much for the prompt reply. I suspected as much, but I wanted to make sure.

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

Hi lbass, We are only going to count people who are employed on the first day of each month, otherwise we could end up overcounting the number of actual employees (say we hire a receptionist, fire them, and then hire a second one in the same month--we would only want to count that as 1 employee...

My manager wants a rolling 12-month headcount (it's a Human Resources report), and has arbitralily decided on the first day of each month. For the sake of simplicity, I am going to assume that the user will always enter a first day of the month as a parameter. Say that the user enters June...

Ah...thanks to both of you. I seem to be making some progress. Now my problem seems to be that I do not want to count by the date that a record was entered, but by the dates that the record was "current". Each record has a CreatedDate and EndDate. For example, say it was "created" January...

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

Thanks lbass. That simple bit of info not only solved my problem, but will save me a lot of time in the future!

Thanks for your help everyone. The third table (miscPosition) does have a matching record for every idPosition value in eeEmployee. The problem seems to be Crystal being fussy about nulls in the Record Selection Formula. If the miscPosition record had a null in the EndDate field, the join...