Problems Installing SharePoint 2010 on Windows 2008R2 Server (Configuration Failed- error)

This Knol is a bit of a departure for me in that I'm not suggesting a solution to a particular problem more I'm just sharing with the world my total exasperation when trying to get SharePoint 2010 setup and running on an internal test server (so I can test SQL Server Reporting Services Integrated Mode - I'm not even trying to test SharePoint!).This Knol runs through the process of installing SharePoint 2010 until a "Configuration failed" error occurs...

Read More

SSRS: Accessing Report Builder 3

This blog post covers accessing and installing the "Report Builder" tool that comes with Microsoft SQL Server Reporting Services (SSRS) 2008R2.All access to Report Builder is obtained via Internet Explorer. In order to get access to the system you will require specific permission – without it the instructions below will not work (the “Report Builder” button will not be visible).To start Open “Internet Explorer” and go to the following URL:https:///Reports/Where...

Read More

SSRS: Adding Parameters in Query Designer (When Using a DataModel as a Data Source)

This blog post gives an example of how to add a parameter to a report using Microsoft SQL Server 2008R2 and the Report Builder 3 tool.After running Report Builder and opening your report you will see something like this;Expand the "Datasets" node in the treeview on the left;If you right-click the active Dataset (DataSet1 - highlighted above) and then select "Dataset Properties";This screen is showing you a lot of technical details about the Query...

Read More

SSRS: Formatting a Parameter as Date/Time

This Knol covers how to convert an existing text-based parameter in Microsoft SQL Server Reporting Services to a Date/Time providing the users with a Date/Time picker to select a value rather than forcing them to enter text (i.e. 10-JAN-2010) without making a typo.Assuming you have your report already open in Report Designer and you've just run it. The report we're going to deal with has a single parameter "INVOICE_DATE". Click "Design" at the top...

Read More

SSRS: Specifying a Default Value for a Date/Time Parameter

This blog post covers how to specify a default parameter value for a Date/Time Parameter in a report written using Microsoft SQL Server Reporting Services (SSRS). You can easily modify this to specify default values for other types of parameter.Assuming you have your report already open in Report Designer and you've just run it. The report we're going to deal with has a single parameter "INVOICE_DATE". Click "Design" at the top left:Expand the Parameters...

Read More

Noetix: Identifying Un-used Columns For Removal

This blog post covers a description of an application (source code provided) that identifies columns which are not required (i.e. all values of the column in the view are the same) and generates a script that somone who has completed the NoetixViews Customization Certification course can include in the Generation Scripts.The first thing to note is how this works; it opens every view doing a MIN/MAX on every column. It has been tested on a 16GB database...

Read More