Andy, you made a lot of good points.

I'm personally annoyed that they didn't make it easier to write embedded code in a report (you can size the dialog window but...

>>And a renderer for XAML so reports can be rendered directly into the UI of a WPF/Silverlight application without a lardass third party report viewer control.

You sort of have...

While this is most excellently true, the real problem is that you have to allow for different renderers to have the ability to handle your color shades different ways.

This used...

>> adding parameter through the UI missing

It is?

Not sure... you're talking about when using the Report Designer in Visual Studio, right?

1. View menu -> show the Report Data window

2....

Are you trying to print it on the server or, using ReportViewer, on the client side in a web form?

There is a solution for this, I'm pretty sure, but...

The scheduled delivery capability is only a very small part of what one would want to do, sure. But it's a feature of Report Manager, not SSRS. Report...

>>Noone's found a good solution for it - it should just work!

Um... I wouldn't say this is necessarily a *good* solution... but I think maybe I did find a...

I recently added a view to a 3rd party application and thought it would be sensible to make it an Indexed View for performance reasons, so I created the view...

Thanks Flo. That's what I thought. It is not a serious restriction, because your method is sound. I'm just pointing out that the any length limitation -- whether 64k...

RH says:

Hmm, no, I wish. Not for columns of XML type holding XML documents.

IAC I'm not able to figure out a way...

There are a couple of different ways to handle this but the quick and dirty way is to have a special token, 'ALL', and disallow nulls.

You can do this with...

>>

SELECT INTO on a temp table with an identity column is so very fast that it's nearly as fast as SQL Server 2005's ROW_NUMBER() over

<<

That's extremely cool, Jeff -- not...

>>

Before you use any of those that have a self join or correlated subquery that use the ">=" or "<=" or any other inequality method to generate row numbers,...

There are a number of ways to "fake" the rownumber function in sql 2000 -- here is one I particularly like:

http://support.microsoft.com/kb/q186133/

nope, not your only solution.  Table vars don't work in SELECT statements... but table-valued functions do <g>.  Even in nested SELECTs and all kinds of other screwy syntax.

>L<