Luke Hayler - SQL Server developer

I have encountered this issue on two separate occasions now. The first was during a report deployment to a new Report Server Virtual Directory and the second was trying to access the report manager via the URL: http://localhost/Reports. Each time I was presented with the same "Authentication Required" "Enter username and password for "" at [...]

It’s almost time for another SQLBits, and in my [humble] opinion, it’s not soon enough. These free conferences are fantastic and if you do have the opportunity to attend I suggest you do so. Whilst I have only a small idea as to what goes into organising a conference, I am pretty sure that it [...]

This is a quick look at how to create and use subtotals in your Matrix objects.
Subtotals 101
SQL Server Reporting Services makes it relatively easy to add totals to your columns and rows in a matrix object. In short, it’s as easy as right-click>Subtotal. Seriously, that’s it. Well, unless you want to format them, but that’s [...]

A while back I wrote a post about how to toggle the visibility of rows/columns in tables/matrices for SSRS 2005. In the comments of that article someone asked how this was done in SSRS 2008. The short answer was that the method is the same. However, setting all the properties can be confusing as their [...]

If you ever happen to be in a situation were you do not have access to or have ‘misplaced’ the SSRS report files (.rdl) and you need to edit one (or more) of the reports on your server, there is an easy way to download the .rdl files.
Follow these easy steps:

Open SQL Server Management [...]

This is the second part in my recap of SQLBits V. You can read Part 1 here.
Sessions
I was assigned as a room monitor on the Saturday, and as 3 of the sessions I was planning on attending were in the BI track, this is where I ended up. The day for Room 1 went as [...]

Using the DatePart() Function in SSRS can be tricky, even at the best of times. I have pulled my hair out too often trying to remember what syntax should be used, so have resorted to writing down all my findings. This is so that you don’t have to go through the same agony & frustration [...]

SQLBits is almost upon us. In less than 10 days, around 400 people will be descending on the Celtic Manor in Newport, Wales for the 5th instalment of what I am led to believe is a first rate conference. Great speakers, great sessions, awesome venue, _____________ attendees. That space is intentional. I plan to fill [...]

Let’s just assume that…
You’ve created your data driven subscription (File share) for your reporting services report, and everything is as it should be. The subscribers table has been created, populated and correctly mapped to the required fields in the subscription (FileName, Path, Format, Parameters, etc), the schedule is set. And then you test your subscription.
 
The [...]

Sometimes

Sometimes, just having the right information in a report doesn’t completely fill the requirement. You can enrich the content by formatting items in your report using some simple formatting codes. Follow these steps:

- Right-click the field(s) you want to format
- Choose Properties & navigate to the Format tab. **
- Click on the ellipsis (…) [...]