To get around the "Operand data type varchar is invalid for sum operator" error, cast the value to integer prior to SUM:

SUM(CINT(Fields!FieldName.Value))

Have you tried just creating the average in an expression rather than using the AVG function?:

SUM(Field!Fieldname) / COUNT(Field!Fieldname)

With AVG function usually not working the way I want I have gone...

This will get you closer. It may not be the exact format you are looking for, but give it a try for starters.

SELECT

Customer,

Status,

...

If you are using SQL Server 2008 R2 you may be able to use the LookupSet function:

http://msdn.microsoft.com/en-us/library/ms157328.aspx

The other ways I've gotten something similar to work are to create a SQL...

Usually when exporting to Excel, new tabs are created whenever you create a hard page break in the report typically in between groups. If you chose this route and...

I'm glad you finallly got it working. I didn't think what you were trying to do was that far out of the norm, but I was beginning to lose...

It's tough to replicate the issue because of the complexity of the query and they way you are displaying the budget, but depending on how the groups are set up...

Sounds correct. If the user does not have permissions to the root either through the Authenticated Users group or another group (like TestGroup), you would get the error you...

Assuming you are using the Ace driver, I think this syntax works the best. Pulling the WHERE clause out worked better with SSRS. If you are trying...

Another random possibility would to be to divide out the count for your grand total, this would effectively create the average of the duplicate records which would be the ovalue...

And it's not working if you use the same case statement for both the SubTotal and Budget?

Replace dd.Budget

With CASE WHEN RowNumber = 1 THEN dd.Budget ELSE 0 END as Budget

Chances are that you are still getting access because TestUser is getting permissions through the System Group NT Authority\Authenticated Users (this group basically includes everyone that logs on). Log...

Have you tried utilizing the ReportItems collection instead of using the fields from the dataset. Put something like the following for your Grand Total expression:

=ReportItems!textbox14.Value - ReportItems!textbox15.Value

Where you replace...

Here's two additional options that may work. For the data source, instead of using a DSN, create a SQL Server data source. The database you select isn't really...

Another thing to check, it looks like you're only performing comparisons for the start date length = 0. Could it be the end date that is throwing the #error?...