Actually "Bit" and all, this sums up my point. There are some nice tecnical articles out there for people like us, but they need to get something out there for...

Not to beat a dead horse on this subject, but I brought this topic up at a SQL User Group last night when the topic of BI came up. The...

Yeah it does seem like a real setback when it comes to implementing. We're implementing with our client base. I am doing some training with them (in my free time!...

I've searched high and low as well, and posted asking the same. This definitely seems to be an area needing improvement by Microsoft, so some industrious Tech writer.

For the...

I just dropped my assembly in my C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin folder on the Report Server and have never had a permissions issue.

I've done this, but truly I find it much easier to drop this logic into my stored procedure. You can build an Address string in there and use char(13) and...

IMO, templates were somewhat of an afterthought in SSRS; however, you can also use Custom Assemblies and Code Modules:

http://msdn.microsoft.com/en-us/library/ms155034(SQL.90).aspx

We have integrated SSRS into hosted applications and I used the above...

You can try sp_send_dbmail from the subscription job that gets created in SQL agent, but I'm nearly 100% certain you will end up with two emails as the earlier poster...

We resolved our print issue on Standard with SP3. From what I learned, a MS patch intentionally broke this control right around the time that SP2 came out hence SP2...

I'm assuming you're storing these counts? Actually, I've been thinking along the same lines and creating an SSRS report, if somebody hasn't already done something. I haven't begun to store...

This is just a shot in the dark, but are you sure you're pointing to the same server environment? I once deleted my config file for a package and my...

Actually, I was able to figure out the error thanks to help from a .NET guy (embarrassing ain't it). TEXT() should be text(). The only thing he couldn't tell...

Also, (local) doesn't seem to work as a valid server name in most instances...

Bingo! You are right. I have three instances of SQL running on this server, with Dev being...

'Set FmtOnly OFF; EXEC dbo.sp_Who'

I have used various iterations of OpenRowSet, including SET FMTONLY OFF and SET NOCOUNT ON. I have used an OLE DB connection rather than the SQL...

Sorry I keep popping in here, but I encountered this same issue (among many others when I set up the ReportServer remotely) as you have done. I believe that we...