Thanks for the info.

Is it the same performance than using inline code? I ask because in MS Access, that can really hurt you (not always)... same thing with a functino in t-sql.

What happened to those threads??? I can only find 2 refferences to them and there's no navigation to see the rest of the posts...

has it been rounded down to reduce...

208 posts on this one??? is that getting close to a new record or something?

I know... untill you start using sps that do DML, then you canget seriously screwed if you're not carefull... unsupported, I find another way!

Or another one :

SELECT Sex, COUNT(*) as Total FROM (SELECT Id, Sex FROM dbo.Table GROUP BY Id, Sex) dtName GROUP By Sex

--ORDER BY Total DESC

I just had the same problem... SSRS doesn't short-curcuit the IIF... meaning it evaluate everything regardless if the results (even that is inconsistant!!).

So you need the put the IIF again...

I'm just guessing here... but aren't #temp table transaction NOT logged?

One way to use your idea would be to create a db just to hold those results and put the...

WayneS (12/9/2008)

---

DiverKas (12/9/2008)

---

A better solution would be to use Crystal, ActiveReports or any other tool that does not require Excel, to export and format the data in an Excel format....

Just to put some oil on the fire... I just started working with SSRS and it beats the crap out of manually making excel files. Since it does not...

Thanks, and I also found later that under the group option in the general tab, there's a checkbox at the bottom that roughly says (translating from french) : Group Headers...

Thanks, sounds like a plan, let me test that on a backup copy of the rdl ;).

Still no info on the 2008/2005 test, I haven't had time to perform it...

... and you can open fire on the server run with a shotgun and call your service rep for a free replace of the servers too.

I wouldn't try...

I still don't see anything in the matrix options to add a new DATA column (not another grouping).

Again here's what I see in case I'm just missing something obvious :...

Exactly... that's because the servers needs to assume that the state of the DB and data will not change by calling the function (again, by design because the server would...