Recent content by ChuckGann

I have a view within a GP database that selects data from a separate data warehouse server in our environment. The select statement of the view works within Query Analyzer, but returns the following error when trying to set it up for use within Smartlist Builder: GPS Error: 58 SQL Error: 7405...

Thanks for your help, but the Group Header seems to be my issue. The application we use to handle the bursting requires the data be returned to Group Header 1, and I can't seem to get it there.

We are using Crystal XI on a SQL2000 database. The application we are using stores email addresses related to each customer number in the database, but stores each email address related to the same customer number on a different line of data. We need to combine these in the Group Header(we are...

It sounds like we are trying to get this to do something its not designed to do. The DTS package that the trigger is calling is copying a modified set of data from the original table into a staging area. It is not testing data integrity or anything like that. Is there another good way of...

Sorry, it is an After trigger.

Hi everyone, We are trying to call a DTS package upon change to a table in SQL2000. The trigger itself runs fine, but it is causing an error message within the application (Great Plains). I think I am misunderstanding when the trigger executes. What we would like is for the trigger to...

Hi Everyone, We are using SQL 2000 and DTS to populate some tables with summary data from other SQL tables. As part of this, we delete records in the destination table and then re-populate from the other tables. Our problem is that users can run reports on this summarized data at any time...

Hi Everyone, We are using SQL 2000 and DTS to populate some tables with summary data from other SQL tables. As part of this, we delete records in the destination table and then re-populate from the other tables. Our problem is that users can run reports on this summarized data at any time...

That did it. Thanks for your help!!!!!

Thanks for the reply Denis. However, I get a syntax error when trying to map unless I replace the @CutOffDate with a ?. If i do that, I can map them. My problem is that I can't seem to update the variable associated with it even within another script, The script will run fine and return the...

I am trying to execute a stored proc with DTS (SQL 2000) in a SQL task. My problem is in trying to set one of the parameters with a variable. My script from the SQL task is below. declare @CutOffDate as datetime set @CutOffDate =...

Hello all, I am using Crystal XI on SQL 2000 and having an issue with the DateAdd function. My problem is that the report is using a parameter to indentify an ending date, and this ending date is always the end of a month. One of the columns on the report shows data from taht month, and then...

I would like to be able to calculate the slope of a dataset. Bascailly, I have Dates as my x value and Dollar Amounts as the y value. You can produce this in a Crystal Chart, but I can't figure out how to do it as a formula. Has anyone run across this before? Thanks in advance.

Thanks. I'll try that as well.

We are gathering General Ledger data from Great Plains both in Summary and Detail format and storing it in a data warehouse of sorts. It is be gathered from around 800 databases, and is identified by lcoation with the field UnitID. Reporting on the data has been simple for the most part, as we...