Welcome to MSDN Blogs Sign in | Join | Help

June 2005 - Posts

Wednesday, June 29, 2005 8:36 PM

Report name with spaces and the ReportEmbeddedResource property of the Whidbey Report Viewer control

Ran into an interesting (and I guess understandable) behavior today while playing with the Visual Studio 2005 Report Viewer control. I created a new Winform project then added a renamed version of the Company Sales.rdl report which is included in SQL
Posted by russch | 0 Comments
Tuesday, June 28, 2005 4:28 PM

Displaying text vertically in SQL Server Reporting Services 2000

File this one under RTFM...but I had no clue even though it's right there in books online. Duh! Anyway, if you want to render text vertically instead of horizontally, use the WritingMode property of a text box, subtotal, title, or legend
Posted by russch | 2 Comments
Monday, June 27, 2005 4:37 AM

Displaying Report Builder to non-admin users in SQL Server Reporting Services 2005

I finally began playing around with how to secure models and/or items within a model, so I needed a "testuser" to launch IE under in order to test my changes. Much to my chagrin, testuser didn't even get the Report Builder button displayed in the Report
Posted by russch | 1 Comments
Sunday, June 26, 2005 10:18 AM

All about SQL Server Reporting Services 2000 Logs:

There are tons of logs in C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles...what do all those files do? ReportServerService_main:_TimeDateStamp: This log records information about what happens during appdomain recycles, some info
Posted by russch | 1 Comments
Thursday, June 23, 2005 7:16 AM

Another way to deal with defaults and snapshots in SQL Reporting Services

Here's an interesting scenario one of my customers had and how we approached it. The customer filters his report by region and subregion using parameters. The @Region parameter is given a default value and then hidden: the cutomer uses this parameter
Posted by russch | 3 Comments
Wednesday, June 22, 2005 6:20 AM

How to preview a report without direct access to its data source in SQL Server Reporting Services 2000

You may have noticed that starting with SSRS SP1, when you preview a report which contains data in the designer, a ReportName.RDL.Data file appears on your file system. We store the data that was just displayed by your preview action in this file so we
Posted by russch | 7 Comments
Tuesday, June 21, 2005 6:11 AM

Reporting Services Features by SQL Server 2005 version

The by-edition feature matrix of SQL Reporting Services charges quite a bit (for the better) in 2005. Here's a nice table that explains it all: http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
Posted by russch | 0 Comments
Monday, June 20, 2005 8:05 PM

How to force multiple lines of text into a textbox in SQL Reporting Services

From time to time (generally in a header / footer), you'll want to force some linebreaking inside a textbox. For example, you may have a long column description that won't easily fit on a single horizontal place. In order to get the behavior you want,
Posted by russch | 0 Comments
Friday, June 17, 2005 3:30 PM

Accessing a report anonymously in SQL Reporting Services 2000

I've worked with several customers who use a custom authentication scheme in their enterprise, and therefore couldn't secure Reporting Services using Windows Authentication. Some of these folk also didn't want to write their own custom security extension
Posted by russch | 6 Comments
Friday, June 17, 2005 9:33 AM

Where do I deploy my custom assemblies when working with SQL Reporting Services 2005?

There is a change from 2000 here, and it's not documented in Book Online yet. To further confuse matters, in some earlier builds of Yukon\Whidbey you'll actually find multiple copies of RSReportDesigner.Config on your disk, so you can't always key on
Posted by russch | 5 Comments
Thursday, June 16, 2005 9:33 AM

#Error when using a custom assembly in SQL Reporting Services

OK, you're using SQL Server Reporting Services and you've created and deployed your custom assembly to 80\Tools\Report Designer and MSSQL\Reporting Services\ReportServer\bin just like you're supposed to. You have also edited rssrvpolicy.config and rspreviewpolicy.config
Posted by russch | 80 Comments
Wednesday, June 15, 2005 8:54 PM

Missing Leading Spaces in SQL Reporting Services Reports

Problem: In SQL 2000 Reporting Services, I need to display indented text in my report. I use leading, embedded spaces to do this work and they display correctly in PDF/TIFF/Excel, but the leading spaces in the report are stripped out in HTML. What gives?
Posted by russch | 80 Comments
 
Page view tracker