Friday, September 21, 2012

Changing regional settings (1000 seperator)

When creating Sql Server Reporting Services Reports you can sometimes end-up with data in US format instead of the local regional settings of the user.

For Example:

Here we have a report showing the Sales LCY and Profit LCY by Salesperson and Country in a matrix control. The data is coming from the Dynamics-NAV Sql database, but the formatting of the amounts is in US format, even when the report is running on a system that has Belgium regional settings.

How can we correct this?

Well there's a simple solution for this common problem. In the Report Designer in Visual Studio, the report has a LANGUAGE property:

Monday, September 17, 2012

Sorting a matrix by aggregate

  • right click on the top right corner of the matrix and go to matrix properties.
  • select the groups tab.
  • select the group1 row, click edit.
  • click the sorting tab.
  • enter your totalling expression, and decide if you want it to sort in ascending or descending totals order.