I did get it to work. I was grouping them like you said. Thanks for your help!!

Here is an example of the data:

TranTypeID DrAmt CrAmt

CHK 0.00 ...

Still zero amount.

Yes the vaules are INT, DEP, WHT

Oh yeah that would help. Thanks, but the expression does not return the correct value just zero. I know there there data it should be calculating. Any ideas??

Here is the solution to my problem:

http://www.developer.com/db/article.php/10920_3513996_1

I implemented this and it worked like a charm:-D

No I have not tried that. But I will give it a shot.

Thanks

Kevin

Yes SQL 2005 SP2 CU 9

I finally got it to work. I had to use the "RECONFIGURE WITH OVERRIDE" syntax.

ex:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure 'SMO and DMO XPs', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

I received the following msg:

Ad hoc update to system catalogs is not supported

Do I need to check the "cross database ownership changing box to allow this change?

I also didn't see...