I know this post has been up for a while with no response, but I just came across it while searching for something else...

Have you considered doing this with a...

happycat59 (4/24/2012)

---

I don't think that you should be grouping anything.

Also, I suspect that you are attempting to apply formatting etc at the row level of your report. You should...

happycat59 (4/23/2012)

---

To me, that simply means that your condition is not simply

Previous(Fields!HostName.Value) = (Fields!HostName.Value)

It is more like

IIF (Previous(Fields!HostName.Value) = (Fields!HostName.Value)) AND...

That...

Daniel Bowlin (4/20/2012)

---

A Row_Number() partitioned and ordered by machine would give you numbers that start at one with every new machine and then increment from there. For example

Server ...

How would I use that? Wouldn't it increment for blank rows as well? I want to keep blank rows white, but grey out repeats on filled rows.

There are (at the moment) over 200 different System_Name values, with the strong likelihood of more being added (and some existing ones removed) over time, so the dynamic route is...

Although I am primarily a MS SQL Server DBA, I have long been a believer (even before becoming a DBA) that alternatives to Microsoft frequently offer better software, or programs...