RBarryYoung (12/17/2008)

---

maddogs (12/17/2008)

---

It's 5 degrees F outside these days here in central Washington state so there's not much outdoor arrow & inanimate object flinging going on, but I've got a...

It's 5 degrees F outside these days here in central Washington state so there's not much outdoor arrow & inanimate object flinging going on, but I've got a batch of...

I have nothing related to the technical aspects of this article that haven't already been said, but I too have to take exception 😛 on the art of fletching becoming...

Use this SQL on the server your SSRS is running on:

USE ReportServer

GO

-- List users\accounts associated with SSRS reports

SELECTCASE IsNull(c.Path,'') WHEN '' THEN 'Home' ELSE c.Path END 'Path',

r.RoleName,

u.UserName

FROMdbo.Catalog...

There is no built-in SSRS 2003 or 2005 function in the group area to concatenate that I am aware of, other than the Join method in an SSRS code block...

Well I was perfectly happy with the first couple of posts (you had me at 'ASCII()' and 'Tally' :P) but regret that my unfortunate use of the word 'win' precipitated...

Well both methods proposed I think are cleaner than my original thinking - I knew up front the tally approach may have applicability but did not want to put my...

Thanks guys. I guess it's a good thing to always be in the set-based mindset, although Brian is correct in this case we're not dealing with any iterations between...

What is the service pack level of your SQL Server? If it less than SP3a, there is a known bug where port 1433 is blocked as a listener even...

This is also belated, but what fixed it for us was substituting the logical server name of the AS\400 client connection in both the DTS package and the server ODBC...

To highlight one section of a textbox, one hack you can do if you know the report is ALWAYS viewed as a web archive format and can ignore the extra...

Thanks for the reply. We are not moving to SQL2K5 anytime soon so will keep searching....

Cheers!

I realize this is an old post but we are now experiening this same issue with ALL our DTS packages that have AS\400 connections, they worked just fine a week...

Well yahoo - that works for me Barry. I had tried various forms of unions also but didn't think of using the equivalence operators like you did. ...

Thanks for the response. Yeah I tried flattening out the A&B values into another temp table with an ID, an A\B type, and single column for the values but...