You haven't really explained anything about your ASP.NET application or where it's situated on your network.  But the fact that it "uses SSL" doesn't change anything in the equation, or...

i'm not sure I can debug this from your example, because a lot would be determined on how you had installed RS on the server, I guess... but I'll give...

To do this really well, you are going to have to nest TRY/CATCH blocks in each called proc, I think...

The nested CATCH blocks in each called proc can call...

>>so I found that the joins were the issue here, and I needed to re-think the way my query was to work.

OIC, sorry, then can you use PeterHe's EXISTS suggestion and bring...

>>

Actually, PatIndex does need the wildcards as it performs a pattern search much like the keyword LIKE. Without the wildcards, the entire strings would have to be exact matches. You...

JIC... are you sure you're not looking at the build information at the end of the @@version that applies to the version of the OS, not the version of SQL...

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,...