SSRS Error Fix: Parameters Must Use the Correct Case

The Value expression for the query parameter ‘@Parameter’ referes to a non-existing report parameter ‘parameter’. Letters in the names of parameters must use the correct case.

SSRS Error Message

When editing Parameters (names or case) for a Dataset within SSRS you may encouter the previous error message when you preview the report. While on the surface it may appear that the parameter has the same case in the Parameter settings and the Dataset query – there is another place where a change is required.

  1. Open the Dataset properties for the Dataset (s) that use the Parameter in the error message.
  2. Select the Parameters property in the left list pane.
  3. Click the Expression Editor  button for the specified Parameter.DataSet Query Parameter Values
  4. Here you will notice that the Expression is underlined in red. This is where you will need to correct the case of the Parameter name.
    SSRS Expression Editor

 

SharePoint ULS Viewer

For the longest time the most commonly used ULS Viewer for SharePoint was located on the MSDN Archive Gallery. Today you can no longer find it there.

ULSViewer-MainScreen

ULSViewer-DetailScreen

It appears that Microsoft has moved the ULS Viewer to the Official Microsoft Download Center.

I’ve also stored a copy of the application to my OneDrive account – just in case Microsoft decides to move it again.  (ULSViewer.exe)

Want to learn more about the ULS Viewer? Check out Bill Baer’s post ULS Viewing Like a Boss.

Adventure Works Sample Databases

Microsoft recently released the Adventure Works 2014 Sample Databases for download on CodePlex. From time to time, I find myself looking to download and re-download not only the latest AdventureWorks databases but also for older versions of SQL Server.

 

Adventure Works Logo

For easy access, I have saved all of the AdventureWorks sample databases to my OneDrive account and provided links to the resources below.

SQL Server 2014

Adventure Works 2014 – Full Database Backup (AdventureWorks2014.bak.zip)

Adventure Works 2014 OLTP Script (Adventure Works 2014 OLTP Script.zip)

Adventure Works 2014 Warehouse Script (Adventure Works 2014 Warehouse Script.zip)

Adventure Works DW 2014 Full Database Backup (AdventureWorksDW2014.bak.zip)

Readme for Adventure Works 2014 Sample Databases (Readme for Adventure Works 2014 Sample Databases.docx)

Adventure Works DW Tabular Model SQL Server 2014 (Adventure Works DW Tabular Model SQL Server 2014.zip)

Adventure Works Internet Sales Tabular Model 2014 Backup (AW Internet Sales Tabular Model 2014.abf.zip)

Adventure Works Internet Sales Tabular Model 2014 (Adventure Works Internet Sales Tabular Model 2014.zip)

Adventure Works Multidimensional Model SQL 2014 Full Database Backup (Adventure Works Multidimensional Model SQL 2014 Full Database Backups.zip)

Adventure Works Tabular Model SQL 2014 Backup (AW Tabular Model SQL 2014.abf.zip)

AW Multidimensional Models SQL Server 2014 (AW Multidimensional Models SQL Server 2014.zip)

Readme for Adventure Works DW 2014 Multidimensional Databases (Readme for Adventure Works DW 2014 Multidimensional Databases.docx)

SQL Server 2012

Adventure Works 2012 Data File (AdventureWorks2012_Data.zip)

Adventure Works DW 2012 Data File (AdventureWorksDW2012_Data.mdf.zip)

Adventure Works Multidimensional Models SQL Server 2012 (AdventureWorks Multidimensional Models SQL Server 2012.zip)

Analysis Services Tutorial SQL Server 2012 (Analysis Services Tutorial SQL Server 2012.zip)

Adventure Works Tabular Model SQL Server 2012 (AdventureWorks DW Tabular Model SQL Server 2012.zip)

Adventure Works Internet Sales Tabular Model SQL Server 2012 (AW Internet Sales Tabular Model.zip)

Adventure Works 2012 CS OLTP Script (AdventureWorks 2012 CS OLTP Script.zip)

Adventure Works 2012 OLTP Script (AdventureWorks 2012 OLTP Script.zip)

Adventure Works 2012 CS Data File (AdventureWorks2012_CS_Data.mdf.zip)

Adventure Works LT2012 Data (AdventureWorksLT2012_Data.mdf.zip)

Adventure Works DW 2012 Images (AdventureWorksDW2012Images.zip)

Adventure Works 2012 LT Script (AdventureWorks 2012 LT Script.zip)

Adventure Works 2012 – Full Database Backup (AdventureWorks2012-Full Database Backup.bak.zip)

SQL Server 2008R2

Adventure Works 2008R2 Data File (AdventureWorks2008R2_Data.mdf.zip)

Adventure Works DW 2008R2 Data File (AdventureWorksDW2008R2_Data.mdf.zip)

Adventure Works 2008R2 OLTP Script (AdventureWorks 2008R2 OLTP.zip)

Adventure Works 2008R2 DW Script (AdventureWorks 2008R2 Data Warehouse.zip)

Adventure Works 2008R2 LT Script (AdventureWorks 2008R2 LT.zip)

Adventure Works 2008R2 – Full Database Backup (AdventureWorks2008R2-Full Database Backup.bak.zip)

Adventure Works DW 2008R2 Cube for SSAS 2008R2 (Adventure Works DW 2008R2.abf.zip)

Adventure Works 2008R2 LT Data File (AdventureWorksLT2008_Data.mdf.zip)

SQL Server 2008

Adventure Works 2008 Database (AdventureWorks2008_Database.zip)

Adventure Works LT2008 Database (AdventureWorksLT2008_Database.zip)

SQL Server 2005

SQL Server Samples (SqlServerSamples.msi)

Northwind

Northwind Database (Northwind.bak.zip)

Sources:

Frequently Used SSRS Date Expressions

This is a list of common SSRS expressions for defaulting parameters to first and last dates of year, month and previous.

Sources:

Pragmatic Works SSRS Expressions Cheat Sheet

StackOverflow

MSBI SQL Server