Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2010

Manage Reporting Services using SSMS

Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if you want to manage Jobs (subscriptions), Security or Shared Schedules. To connect to your reporting services instance, fire up SSMS and then choose Reporting Services as the Server type as… Read more

0 comments, 1,149 reads

Posted in BrianKMcDonald on 29 June 2010

Strange but True: Reporting Off of Cubes with Parameters Creates Hidden Datasets

I know, it is strange, but it is true...When you create Reporting Services reports that run off of an Analysis Services data source with parameters, Reporting Services automatically creates datasets for each parameter value being passed in. Yes, that's right! One dataset for EACH parameter! Furthermore, to make things a… Read more

0 comments, 498 reads

Posted in BrianKMcDonald on 17 June 2010

Report Render Duration

Every once in a while I come across a scenario where I really want to know how long it took a report to render. This is often the case if the report is taking abnormally long, but some environments may want this kind of information included in its report footer…

Read more

0 comments, 161 reads

Posted in BrianKMcDonald on 15 June 2010

Adding Parameter Values to a Drop Down List Box

In a recent article (Reporting Services Parameters Not Updating), I showed how report parameters are not automatically updated upon adding parameters to a stored procedure. In this quick blog, I am going to show you how to make selecting the StateProvinceID a little easier (and a little more… Read more

0 comments, 815 reads

Posted in BrianKMcDonald on 12 June 2010

Filter Jobs using SQL Server Job Activity Monitor

Using SQL Server Management Studio (SSMS), we have the capability of quickly looking at job related information to verify things such as whether or not it is enabled, the last execution or the date and time it is scheduled to run next. As you can see by the below instance… Read more

0 comments, 195 reads

Posted in BrianKMcDonald on 9 June 2010

Get Index Details

We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One way to see some details of indexes for a table is by querying the sys.dm_db_partition_stats and the sys.indexes table. As you can see by the below, I have used the… Read more

0 comments, 293 reads

Posted in BrianKMcDonald on 7 June 2010

Tech Ed Conference 2010 – New Orleans

SUNDAY 6/6/2010

While sitting in the conference center for Tech Ed 2010, I thought, why not blog about my trip. Even though, I’m not really attending the conference itself, the company that I work for and my wife are part of it. So, what follows is a little bit of… Read more

0 comments, 201 reads

Posted in BrianKMcDonald on 7 June 2010

Interactive Sort Order using Reporting Services 2008

Sorting results in a tabular style report is a common request from business users. Sometimes, they want to see the line item with the maximum amount of value. And sometimes, they want to sort it by the description or item number of the items of a sales invoice. Giving the… Read more

0 comments, 476 reads

Posted in BrianKMcDonald on 7 June 2010

Alternating Group Colors and Alternating Row Colors

Alternating Group Colors and Alternating Row Colors

After posting my recent blog about Alternating Group Colors, I’ve been asked several times about how one could also alternate the colors within the group. As such, I fired up Business Development Studio and made a copy of my Alternating Group Color… Read more

1 comments, 526 reads

Posted in BrianKMcDonald on 4 June 2010

Alternating Group Colors

Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my reports. I start off with a blank canvas (report), get my materials to paint with (data for my report) and then I get to paint my masterpiece (report). Or at… Read more

0 comments, 178 reads

Posted in BrianKMcDonald on 2 June 2010