URL Access still works if you’ve put your SSRS instance into MOSS integration mode, it just takes a bit of extra work. Here’s an example using the following assumptions: · SSRS itself is installed on a machine called ssrsBox · MOSS is installed...

I saw an interesting thread on this topic earlier last night, and I thought I’d pass along the salient points, especially now that SP2 is out and we officially support running this configuration: · SQL Server Express Advanced Edition installs the 32...

(Thanks to Carolyn Chau) If necessary, you can use the old SSRS web parts we provide in Reporting Services 2005 with SPS/MOSS 2007. However, they won’t work automatically – you'll have to get them registered in the GAC with stsadmin.exe. Example: ...

Get ready to download, because SP 2 was declared "ready to ship" last night. The SQL team is hoping to have it ready for public download Monday-morning-ish (PST).

I published a report to SPS, using a custom data source which simply pointed to the database in question and used Integrated Security. When I ran the report, the following error was thrown: An error has occurred during report processing (rsProcessingAborted...

Don’t be surprised if reports exported to CSV or XML are missing several columns of data you otherwise see when viewing the report as HTML, PDF, etc. PDF, HTML, and Excel export leverage “layout renderers” – a generally more expensive export process...

Brian Welcker does it again! In this post he describes a situation that's been causing me a great deal of angst. Essentially, after getting MOSS/SSRS integration working, you get prompted to login when publishing from BIDS - and entering credentials doesn...

After installing the SPS/MOSS & SSRS integration add-in, I surfed to the Application Management page of SPS…and no “Reporting Services” list was apparent. So, I used some information at Brian Welcker’s blog and took a look through all of the rs_sp_...

Just making note of two very worthwhile blog entries I've seen over the last few days. In this post , Lukasz Pawlowski provides us with a nice top-to bottom SSRS troubleshooting approach with links to additional information on most troubleshooting...