So when you are talking about a header, are you actually dealing with the header row or just a row that has the top level of your information?

What I mean...

I'm also not an expert, but like the others, I post because a) someone has helped me and b) it helps me learn and forces me to step out of...

Can you give a bit more info on how you're "hiding" the duplicates?

Perhaps you just need to take a bit better look at how you're grouping the information. Are...

Finally found my own answer...

According to this MSDN Forum, it's not available in SSRS 2005.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/861a8996-4880-4c07-8d91-465ca266020f/

-Luke.

You could do this not so much with a button, but with a new report parameter...

You could create a string type parameter that allows the user to chose the format...

ok so you've got your matrix all set up and you just want to add one more column right for the goal correct?

can you add the column and specify it's...

This is a know issue using subreports exported to excel in SSRS 2000/2005. This issue has been corrected is SSRS 2008. Additionally, you may try to rewrite your...

1st if you give us the exact error message it would go a long way towards helping us to help you. Also the version you are using woudl be...

I guess it depends on your organization...

If you're the DBA and you're in charge of code that is executed against your database, I'd assume you would have the ability to...

You've got a comma after your Case Statement in your Group BY before your HAving Clause.

Get rid of that and you should be all set.

-Luke.

no, but liquid nails works adequately well for these types of applications.

My point exactly. Gets even worse when reading code from someone who doesn't believe in uppercase key words.

-Luke.

I agree with tnolan. There will very a very slight performance increase with <>, however I prefer that one for the reason that was added at the end...

If I'm...

As Gus beat me to the punch, I'd just like to add to be cognizant of any FK relationships you have defined on other tables... want to make sure you...

I would also recommend Profiler and reading up on how to use it. It's an invaluable tool to have in your arsenal.

Beyond that you may want to check out...