The other day, someone requested that a report in SSRS be sorted differently by default. While that might make sense if everyone wants it that way, more than likely you might have people that want a report sorted differently by default. How to do it? There are probably a few ways, but this is what…
Continue Reading »
One thing I usually run into when creating SQL Server Reporting Services (SSRS) Reports is this: You have a smallish size dataset back, maybe somewhere between 50 and 150 rows, but if it hits that row limit on the page break, you get 3 records on the next page. Annoying. What I usually do for…
Continue Reading »
The third meeting for the Madison Area SQL Server Users Group (MADPASS) is tonight. The talk is about SQL Server Clustering for High Availability. Meetings are always FREE and food is provided. Details about the next meeting can be found below. In an ongoing attempt to make the content presented useful to our members we…
Continue Reading »
In the previous 2 parts (see Part 1 and Part 2) of this series I showed you how to get your data ready, and how to get your report started and your Datasets and parameters where you need them. In this part, we will get the graph functional, and in the next part, we will…
Continue Reading »
In the previous post in this series, Agile: Creating an SSRS Burndown Chart Part 1, I explained what data you would need to prepare to create an SSRS Burndown Chart (Sprint_Dates, Stories, Story_History). In this part of the series I will explain how to get a basic burndown report in SSRS. First, fire up Report…
Continue Reading »
The burndown chart. A must have for any ScrumMaster and Agile team. What it should show you is the rate at which you are “burning” down story points. As you can see from the chart above, 3 lines. Red is your “points scheduled”, Green is the “goal” and blue is “points left”. While it is…
Continue Reading »
I have been managing two different groups @ Trek - (Business Intelligence and .NET Software Development) for a while now, and we have some openings we are trying to file, so that is why I am putting this out here. First role, looking to hire a Microsoft .NET Windows Forms developer, or someone with web…
Continue Reading »
You can whip out reports in SSRS (SQL Server Reporting Services) very quickly with the report builders (2.0 and 3.0 are money). But what should you remember to do each time, or information to get? Where does the data come from (GL, Sales, etc) – we could use a cube or datawarehouse, or staging, or…
Continue Reading »
So, I previously blogged about using PivotViewer in your Web Applications, but you can also just consume Pivot collections using the “Pivot” tool from Microsoft Live Labs You can download it here What does this tool offer? Well first it has a library/homepage of collections you can browse You can do some slicing and dicing…
Continue Reading »
Figured out today that in SSRS, if you add a filter to your dataset, and you want to use “Like”, that the operand for everything is * instead of % like you might be used to in SQL, sometimes it is just the little things :)
Continue Reading »