Some IE9 Grief!

Today I really hated IE9 even more!

 

I had this ajax:

    

    $.ajax({

        type: "GET",

        url: "Reportviewer.aspx/GetSomeData",

        contentType: "application/json; charset=utf-8",

        data: "{}",

        dataType: "json",

        success: AjaxSucceeded

    });

    function AjaxSucceeded(result) {

        console.log(result)

        $(result.d).each(function () {

            ...

        });

    }

 

In IE9 the ajax just don’t want to call the success function “AjaxSucceeded” but in Crome, Firefox it returns just fine.

 

After googeling like crazy I found out all instances of console.log() need to be removed from your script in order for it to work in IE9 without it being in developer mode.

 

Well now I know!

 

 

Sum(First(…)) not allowed limitation in SSRS

I have been struggling with an issue in SSRS for some time now and finally solved the issue:

The Issue

I have this data:

In the report I want the ROWS and COLUMNS to be dynamic, adding a matrix table to the report and setting the ROWGROUPS to the rows and ColumnName to the Columns and Value to the Details:

When running the report it displays correctly:

Now I want to add the AREA to show the ROWGROUPs fictional areas, I only want to show the AREA for each ROWGROUP and not the sum :

So not  but

This displays correctly:

Now I want to add a Total at the bottom, the issue here is that ssrs sums the AREAs like such:

The Solution

One way of getting the correct total of the AREA column is to add 2 new columns to our sql query:

SELECT Test.*

       ,ROW_NUMBER() OVER (ORDER BY ROWGROUP) AS 'RowNumber'

       ,RANK() OVER (ORDER BY ROWGROUP) AS 'Rank'

FROM   Test

and using an expression on the AreaTotal:

=Sum(IIf(Fields!Rank.Value = Fields!RowNumber.Value, Fields!AREA.Value, 0))

Producing the desired result: