I believe you need to set the value to be an expression like this:

="A"

So am I. The nice thing is I'm not expecting to be selected so I feel no...

I didn't even know that GOTO existed in T-SQL until I had been programming in it for 2 years. I can see the possibility for its use as Gail...

stevet (4/10/2009)

---

This from the same guy that made the windows login password scheme so complex that users are putting their passwords on post-it notes on their monitors so that they...

I did some studying for the exams for SQL Server 2000 at one point, but so much seemed to be EE, clustering, etc..., all stuff I didn't use that I...

I am against encrypting procedures. I understand people being concerned IP rights, but if you are that concerned, put that logic in the application, not the database. The...

Have you posted the entire set of SQL Statements you are trying to run? I don't see any reference to the column "num" in anything you posted other than...

You can specify a scope to the SUM function so you could try this in the footer:

=Sum(Fields!Column.Value, "DateGroupName")

Here's one where the OP solved his own problem while forming his question.

Thanks Manie.

You can use the default trace to check for login failures, here's an idea on how:

SELECT

I.*

FROM

sys.traces T CROSS Apply

...

How about adding a Group Footer for date and doing the SUM there. IF that works you can remove the table footer.

Are you running McAfee anti-virus? If you are then the "Prevent mass mailing worms from sending mail" Access Protection rule is probably blocking Database Mail. You need to...

Okay, I think I understand your issue. Based on all you have shared, you are correct in assuming that you are summing the repeating value in each row. ...

Have you posted all the code you are running? When I run this (I have to create the table first since I don't have it):

IF OBJECT_ID('temp') IS NOT NULL

...

Are you using an Application Role? If you are you may be able to do something to get the Windows user name based on the BOL entry for sp_setapprole.