Viewing 15 posts - 121 through 135 (of 201 total)
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...
November 28, 2006 at 11:47 am
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...
November 27, 2006 at 10:31 am
>>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...
November 26, 2006 at 6:15 pm
>>
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...
November 25, 2006 at 12:42 pm
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...
November 25, 2006 at 10:33 am
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,...
November 25, 2006 at 10:13 am
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<
November 25, 2006 at 9:58 am
>>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...
November 25, 2006 at 9:55 am
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...
November 25, 2006 at 9:33 am
You might also want to try here:
... if you have a choice between different ODBC drivers available for redbrick, do some serious testing, especially if it's not just a...
November 22, 2006 at 9:21 am
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...
November 21, 2006 at 2:55 pm
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,...
November 21, 2006 at 2:20 pm
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...
November 21, 2006 at 9:56 am
>>
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,...
November 21, 2006 at 9:36 am
>>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...
November 21, 2006 at 9:23 am
Viewing 15 posts - 121 through 135 (of 201 total)