When creating a mock of a Database Table, it is helpful to have some pre-existing data rather than creating it all from scratch. This can be accomplished by outputting the current content of a table to XML, then using this XML as the data source to test against. To get hold of the data, in […]
The problem I have an application that is using Entity Framework to connect to the underlying SQL database. A number of these tables allow items to be updated, but not all of them. Each of the tables that can be updated have the following properties dbo.Delivery Columns Id (PK, int, not null) Project_Id (FK, int, […]
After playing around this evening by following this Channel 9 tutorial – I got the following up and running. If you’re interested, you should say hello, or ask about the weather in a place, or ask about “jonnus” I intend to progress this further following information at this link
Here is an example of how or Scrum Board looks. It’s not the real one as they’re not a fan of taking pictures at work, bit it gives you the idea. While the focus on Scrum Board is always on moving post-its from “To Do” to “Completed”, there’s more to it than that if you […]
As anyone with experience of Agile Scrum knows, there’s no one size fits all solution to applying it to your project. As a Scrum master with nearing a year’s worth of practical experience, here I aim to describe how we are using Agile SCRUM to develop applications within our business.
You’ve set up your report and it looks exactly as required, but due to your pre-defined parameters your report returns every record in the table when it first runs (just in case), and your users will probably want to filter the options. This means there is an unnecessary wait for the report to first render, […]
You may be faced with a problem similar to this, where the user wants to display a particular currency symbol that is different for each locality. It could be possible to alter the underlying dataset to return this information as well as the actual value, but it is entirely possible from within SSRS, as follows
For a variety of reasons (such as this one, where the alteration of the underlying dataset is not allowed) it is sometimes not possible to just calculate the row number for a table using Row_Number. In these instances you can instead use a combination of CountDistinct and RunningValue, as I mentioned in my original answer.
Can’t using SSRS be limiting at times? There you are trying to draw a simple rectangle in a table and the cell just keeps setting the rectangle to be the size of the cell – but you want it another size! As originally posted. The trick here is to remember there is nothing stopping you […]