GSquared (2/25/2009)

---

Try changing that part to this, see if it gets you what you need:

inner join

(select -- get max Supervisor...

GSquared (2/25/2009)

---

I see a fair number of bookmark lookups in the execution plan. You might want to look into what you have for indexes on this query. Covering...

attach is the result from statistics profile

how do you save the execution plan? its graphical

that worked! thanks!

ahhhhh, it works now. Thanks!

Is there any way around this or is it just a limitation of SRS 2005?

anyone????

help please??? i really need to get this report out to management asap.

My cross is set at blank. When I set it to zero, it carries the x-axis labels inside. see new attachment

ok, so i removed the y-axis scale from zero to blank and it now displays the bars for the values less than one, however, it's showing as if its a...

Thanks Andrew. Your script is exactly what I needed. The data is already in a sql table and I am using SRS to create the report.

mucho gracias!

thanks bill. that should work for now

i have 2005