What I need to send is the...

Thanks for the reply.

I have a report that has 50ish including subreports in subreports.... I have never had an issue with it. Only thing I can think of is the performance might...

Thanks for the reply...

one questions though, if a deply this for a user, does the update happen using that person rights or the rights of the admin who deployed?

OK WOW... I was way over thinking that....

Thanks, that did the trick....

Thanks for the quick response...

The problems is I need to only list the cases that have had a status of 'filed'. The query above looks at the history of...

Thanks you both... not sure why I didn't see the solution.....

here is what I am going to use:

[Settle Amount] =

CASE

WHEN (acsv.fee_atty = acsv.manager) AND (acsv.fee_percent = 100)...

Thanks Dave... Had to play a bit with it. On the report created a seperate dataset. I had trouble cause it kept using the date range and excluding all the...

My apologies for being a bonehead....

Thanks WayneS

Well that explains part of it....

I am still getting an error:

Conversion falied when converting date and/or time for character string

I assume that is the NULL being read in as...

I get syntax errors when I do blanks:

INSERT INTO VC...

Sorry for the confusion...

Where the NULL values are in the Insert, those are supposed to be blank... E.I. no closed date or cc_initials.

ahh thanks... I had left the SPACE(0) on the ELSE... I guess I need to read up on that to see why I was getting an error...

Thanks!

Hey Paul,

First thanks... I used yours to put the CASE in SELECT statement cause it fit better in the actual query I have. I do most of the calculations and...

Thanks for the reply... I will play with that today to see if that will work.

For the Fee, It would need to display both since it is for 2 different...