Hope this will save somebody else some time.  There is a Joe Kunk webinar and while the technique of using a SQLDataAdapter is seductive, it doesn't work as shown.

Here's my solution :

http://www.devexpress.com/Support/Center/p/Q299515.aspx

Basically, you need to set the param and call the fill in the BeforePrint(), and be sure to reset the design-time sda param before you build (or export your reptx )

This was a head-scratcher but it is working great now - recommend you give it (and DevExpress in general ) a try.

Thanks Charles, good info.

Edhy Rijo

I'm a little less excited about it today as I can't seem to get the preview to work with string based params ( you do need to set the param to string.empty to get the run-time to work at all, but setting a "default" param on the SDA doesn't seem to work as it does for integers.  I may see if I can get DevExpress to fix this, since it is their previewer that is the issue.

Yes.  Thanks Charles. 

By the way, just as an interesting aside, Infragistics announced that they will be coming out with their own report writer in early 2011.

Russ Brown (Using C#2010/SQL Server 2008)

I decided life is too short for Infragistics :-)  

I'm with you. 

I've already decided on DevExpress and XtraReports, etc., mainly because it was what people, especially including yourself, seemed to be using with Strataframe so I figured I'd make my life easier and just pick one and go with it.  It also helps that it is inexpensive.

Russ Brown (Using C#2010/SQL Server 2008)

Hi Charles, Russell,