Yes, you can do what you are after. Looks like you have stumbled upon the "Quirky Update" scenario. Google search it, or read about it here -

http://www.sqlservercentral.com/articles/T-SQL/68467/

The COUNT() expression function used in SSRS can actually receive a second parameter that specifies the group name that defines the scope the COUNT() should be calculated in.

The syntax would...

Thats kind of a question that only someone who knew the environment would be able to answer fully.

That being said, a good way to see for yourself is to use...

If you open up the properties of the tablix in your report in Report Builder, there is an option under General>"Repeate header rows on each page". There is also an...

I agree... scale UP a box for SQL Server and move SSRS to its own server as you will likely have to scale SSRS OUT. No mention of your considerations...

actually looking at your post again, you did have it pretty close.

This should work -

=sum(Fields!ID.Value)/sum(Fields!ID.Value, "DataSet1")

If it doesn't, use the highest parent group name from your tablix.

Hope that...

What you are facing is a scope issue. Using a second dataset to solve the problem wont really work right. When the expression is evaluated, it is being evaluated within...

You should address this problem at the report definition level. I am not aware of any magic rsreportserver.config that could set the default zoom for you, and even if there...

Seems like the idea of just checking SQL Server's cpu utilization instead of the whole box's cpu utilization is a somewhat flawed concept. Heaven forbid there be other apps running...

What tool are you using to connect to SSRS and write reports? BIDS or Report Builder?

I have 2 suspicions -

1. Default report server site isn't properly configured

- in...

Can you be more specific? We will need to know more than "it doesnt work" to know where to begin to help you.:-P

Eh? No mention of the huge pitfall of indexed views?

If there is some sort of math in the view that could generate an ARITHABORT error, an indexed view has...

doug 40899 (11/16/2010)

---

I have the following query:

select name, employeenumber, summinutes, sum(summinutes/60) as hours

from (

select scratchpad2.name, scratchpad2.employeenumber, SUM(scratchpad2.minutes) + SUM(scratchpad4.totalminutes) as summinutes

from scratchpad2

inner join scratchpad4

on scratchpad2.employeenumber = scratchpad4.employeenumber

group by scratchpad2.name,...

blandry (11/16/2010)

---

"Jeff Moden often quotes, it doesn't take any more time to do it right the first time."

I was struck by this comment in today's editorial. Struck by the...

Sounds like you are trying to display data from both datasets in the same tablix, and "join" the data in the report?

Can't do that. SSRS doesn't know how to relationally...