Archive

Archive for September, 2008

Management changes in Reporting Services 2008

September 23, 2008 Leave a comment

I got asked the other day by a client – " Why can’t I create and manage RS folders in Management Studio anymore ? ". Well, in 2008 , the configuration and management of Reporting Services has changed a bit. There are certain things that cannot be done from Management studio.I have listed below what’s possible with each tool in Reporting Services 2008.
 

Tasks Supported by Tools

Tasks

Report Server Configuration

Management Studio

Report Manager

Command line utilities

Reserve URLs

X

X

Set the service account and password

X

X

Create the report server database or change connection information

X

X

Configure report server scale-out

X

X

Back up, restore, change keys or delete encrypted data

X

X

Configure unattended execution account

X

X

Configure report server e-mail

X

Enable My Reports

X

Enable logging on report execution

X

Enable client-side printing

X

Set server defaults for report history

X

Create or modify role definitions

X

View status of a running report or model process and stop it if it is taking too long

X

Grant permissions to report server items and operations by creating role assignments at the item and system level

X

Define and manage the report server folder hierarchy

X

View reports, report models, shared data sources, resources, and folders

X

Upload report definition (.rdl), report model (.smdl), and resource files

X

Create and manage shared schedules

X

X

Create and manage linked reports

X

Create and manage report history

X

Create and manage shared data sources, and any data source properties defined in an individual report

X

Schedule when data processing occurs for a report or configure a report to run as a report execution snapshot

X

Subscribe to report deliveries and create and manage data-driven subscriptions

X

Create data-driven subscriptions

X

Use Report Builder to create, modify, and save reports

X

Generate models, associate clickthrough reports to entities in a model, and set model item security

X

 

 

Advertisements
Categories: Reporting Services

Alternating row colours in the Tablix cotrol

September 18, 2008 1 comment

In Reporting Services 2000 and 2005 , we used a nifty trick to get alternating background colours per row within a table control. Yes, I’ve spelt colour with a "u", and yes, I’ve used "spelt" and not "spelled", for our friends across the Atlantic. But getting back to Reporting Services , here is the old code :

 
=iif(RowNumber(Nothing) Mod 2, "Gainsboro", "White")

This never worked properly for the Matrix control, however. The big question now, though, is – Will this work with the Tablix control ? Well , I’ll put you out of your agony – it doesn’t. Which means we need a new piece of code. This is what I’ve found :

 

 
=iif(RunningValue(Fields!Region.Value,CountDistinct,Nothing) MOD 2,"Gainsboro","White")

You have to reference a column in your tablix for the running value, so it’s not proper "cut and paste" code, but it has worked for me in reports that I’ve tried so far. Give it a go and let me know …….

UPDATED 16/01/2009 :

Ok, I’ve actually found that the above doesn’t work that well when you have a tablix that’s started out as a table. That’s fine though , you simply revert back to the old code ( the one at the top ) and you’ll get your alternating row colours.

Categories: Reporting Services