Faculty research day
On 16th of April, there will be Faculty of Engineering Research Day at NUI Galway. Researchers will be given possibility to present themselves and what they are making research on. Those who apply shall prepare an abstact and a poster. I will present my research ideas, regarding my Master’s Thesis and what I working on…
adminC#, decimal.toString(), and how to get rid of trailing zeros
Today I spend A LOT OF time on trying to display a percentage – string representation of a decimal but without trailing zeros, e.g. 15.1% instead of 15.10%. In the application I already had NumberFormatInfo for displaying monetary values and percentages. An object of that type was defined as follows: NumberFormatInfo nfi = new NumberFormatInfo();…
How to dynamically add new columns to report created with Reporting Services?
Imagine you have a report that displays some data and the number of columns cannot be defined at the design stage, i.e. the number of columns depends on user input. That seems to cause some problems when you want to render this report with Reporting Services… Solution: Note: The described solution applies to the case…
TSQL – How to select multiple rows into a single row
I spend too long on finding the solution for this problem… Basically I had a table which looked like this What I wanted was to select all as one row as a set of items separated with a comma, where an item was ‘id: name’. The items had to be sorted by the id. So…
Microsoft JScript runtime error: Object doesn't support this property or method.
Yesterday I spent two hours analyzing this issue, which of course I had only with Internet Explorer… As the background: I wrote a library that would make a table sortable and paginable. I decided to use prototype.js and script.aculo.us. I tried to test the result not only in Firefox which I use by default, but…
Reporting Services – problem with passing parameters directly in the URL
In one of the projects I had to create reports (using Reporting Services) that then should be accessible from the application I’ve been developing. As the first thing I created the reports themselves (RDL files), deployed them using the Report Manager (more often http://localhost/Reports or http://localhost/Reports$SQLExpress), and configured so I could access them. However, each…
Terminal server has exceeded maximum number of allowed connection – how to kill open sessions?
When you RDC (connecting remotely using Remote Desktop Connection) to a server and get “Terminal server has exceeded maximum number of allowed connection” message there’s still light at the end of the tunnel. Solution (tested on Windows 2003) RDC to another server in the same workgroup as the one you cannot access and go to…
Reporting Services – deploying RDL files
In this post I’ll describe how to deploy RDL files using Report Manager (more often http://localhost/Reports or http://localhost/Reports$SQLExpress). Note: This description applies to the situation where Microsoft SQL Server is used. Go to Report Manager Too keep all clean, you can create a folder in which you will keep all your reports Create the data…