Yes, you can access the report through a URL (I'm attempting to answer your second question) programmatically.  The actual URL that your application uses can contain all necessary parameter values,...

Followup thought: I think in your situation you don't need the '%' wildcards in the PATINDEX expression, just the embracing commas.

Sorry if that was confusion/red herring.

>L<

>>Can anyone think of a better way of ...

>>dbo.IsInCommaList(@subject_list, sub.id) = 1

>>works fine, but I cant use it because of the issue with the joins.

Not sure if this is...

Mark, as you know from previous conversations, I don't have RS2000 available to check this.. JIC you don't hear from somebody who does, here is how I would try to...

You might also want to try here:

http://publib.boulder.ibm.com/infocenter/rbhelp/v6r3/index.jsp?topic=/com.ibm.redbrick.doc6.3/ciacg/ciacg26.htm

... if you have a choice between different ODBC drivers available for redbrick, do some serious testing, especially if it's not just a...

OK IC. It makes sense that RS 2000 extrudes a limited version of VS 2003 out as a suggested IDE during setup...

Sorry, Mark, I can't check Visual Studio 2003 at...

It is SQL Server 2005, but the filtering options (Technology and Type) are a function of Visual Studio Help, not SQL Server.

This is Visual Studio 2005.  If you are using that,...

I don't know why your report is forcing page breaks on group.  I could look at your RDL if you wanted, and let you know if I see anything.

But, in...

>>

 However when you use the index or search functions how do you limit the results to Reporting Services Books Online? It is not one of the filters available. For example,...

>>I've looked on google, live.com, and msdn, and none have any results for this error.

I found this:

http://weblogs.asp.net/taganov/archive/2004/03/04/83858.aspx

... lots of problems with SQL versus Windows auth being used for credentials...

Looks about right, except for the "smileys" that the forum software appears to be adding into our :'d expressions occasionally...

I don't have anything in front of me to check.  But...

>>Have you worked in the SSIS designer in VS05?

Unfortunately somebody else will have to give you advice there, not my area at all.  I'm kind of interested and would...

I just wrote you a *long* reply with examples and this (*&&!!!#@*(& forum lost it... not the first time <sigh>. I'm overseas in a hotel on a borrowed connection, so...

I'm not sure what you mean by "all the tools" and where you're coming from on this. (I imagine other people are in the same boat, reading your message.)  IAC...

I'm not sure exactly what you're doing wrong, but I can tell you that it *is* possible to do what you want to do <s>.

Post your full URL.  It looks...