Welcome to MSDN Blogs Sign in | Join | Help

February 2007 - Posts

Saturday, February 24, 2007 5:20 PM

How to use URL Access in Reporting Services SharePoint integration mode

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 on mossBox
Posted by russch | 9 Comments
Thursday, February 22, 2007 8:06 AM

Installing SSRS (via SQL Server Express Advanced Edition) on Vista 64-bit

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-bit
Posted by russch | 1 Comments
Tuesday, February 20, 2007 7:07 AM

Using the “old” Reporting Services web parts in MOSS 2007

(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: Stsadm.exe
Posted by russch | 1 Comments
Friday, February 16, 2007 9:35 AM

SQL 2005 SP2 most likely available this Monday, 2/19

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).
Posted by russch | 6 Comments
Friday, February 09, 2007 3:26 PM

rsWindowsIntegratedSecurityDisabled error when running Reporting Services report in SharePoint integrated mode

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)
Posted by russch | 7 Comments
Wednesday, February 07, 2007 9:38 AM

Reporting Services: Why aren’t all my report columns exporting to CSV and/or XML?

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 which
Posted by russch | 13 Comments
Wednesday, February 07, 2007 7:29 AM

Reporting Services Login dialog appears when deploying to MOSS/WSS

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't
Posted by russch | 3 Comments
Saturday, February 03, 2007 1:42 PM

Can’t see “Reporting Services” on the SPS Application Management page after installing SPS/SSRS add-in

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_?.log
Posted by russch | 0 Comments
Thursday, February 01, 2007 7:35 AM

Mixed Bag: Troubleshooting Reports and Viewing MDX in Excel 2007

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 topics
Posted by russch | 0 Comments
 
Page view tracker