Reporting Services Question using SQL Server 2005

Posted on 2013-09-13
Medium Priority
Last Modified: 2013-09-20
Hi Everybody,

I have created a stored procedure that I am using to pull data into a Reporting Services report created using a database in SQL Server 2005.  I have created the Report.rdl but when I try to run the report with the parameters LocationID put into the box, I get a message that the @LocationID parameter was not supplied.  What is causing this error?  The report has been setup with the parameters correctly.  I am entering the location ID and selecting View Report, an error message appears saying the parameter @LocationID was not supplied.

What do I need to do?

Question by:jjc9809
  • 3
  • 2
LVL 49

Expert Comment

ID: 39492254
Topic Added:  SSRS SQL Reporting Svc

Topic Advisor
LVL 12

Expert Comment

ID: 39492278
Are you building the report in Report Builder or BIDS?

Author Comment

ID: 39492730
I am creating a report not using the wizard.  Report Builder is used though.

What is BIDS?

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

LVL 12

Accepted Solution

Tony303 earned 2000 total points
ID: 39493242
OK BIDS is Business Intelligence Development Studio, which is a subset of Microsoft Visual Studio. It works differently to Report Builder.

OK, so Report Builder is really a cut down version of BIDS. You'll need to edit your report in Report Builder, open it up, check the parameter LocationID, is the data type OK? Is the value of the parameter being used in the where clause of your query?

Does your query run without a where clause?
Does the query run with a hard coded value in the where clause?

Is the spelling ( case sensitive) of your @LocationID the same as the spelling in the where clause?

See what you can find, let's us know.


Author Comment

ID: 39493436

I am working in the Business Intelligence Studio inside Visual Studio 2005.
The datatype for @LocationID is string in the rdl.  I do not have a copy of my stored proc here at home.  I will look Monday and see what the datatype is that the Stored Proc has.  I did not write the complete stored proc, I copied the sp and gutted parts and added a select I needed to pull the Transfer Date.  I believe the stored proc had a parameter @LocationID set up as Integer.  If this is the case that explains trying to load a string lnto an integer type
is causing the error.  The names may not be consistent either.  I will look on Monday.

LVL 12

Expert Comment

ID: 39510261
Hi jjc, did you fix it?

What was the trick in the end? That got you going?

I am just interested,  to get my reading and interpretation of these questions better.



Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question