My reporting services data set SQL Query is not prompting me for the input parameter

I have a reporting services report. Associated with that report is a data set, and associated with the data set is the SQL query below. Now if I go into the Reporting Services Business Development Studio and open up my project there are three tabs displayed "Data","Layout","Preview". If I select the "Data Tab" I can view my query below. The problem is that when I run the query it does not prompt me for the value that I want to be passed into the report? In my case "inputID"

Why am I not being prompted to enter in this input parameter? Is something wrong with the way I declared "@inputID" in my query below, or do  I need to do some other step, like open the "Data Set" dialog box by pressin "..." on the toolbar and then setting or creating something?

Please help.

-- Text SQL Statement associated with my data set. This data returned from this query is displayed on the report.
DECLARE @inputID VARCHAR(10) -- This will be passed in from aspx/c#

DECLARE @EmployeeCount int -- Number of Customers we are reporting on

SELECT  @EmployeeCount= COUNT(DISTINCT(intUserID)) from tblNoticeResponse as theTotal where NoticeID IS NOT NULL AND (NoticeID=CAST(@inputID AS INT))
PRINT @EmployeeCount
SELECT
      convert(varchar(30), DATEADD(hh, DATEPART(hh, [ResponseDateTime]),
              CAST(FLOOR(CAST([ResponseDateTime] AS FLOAT)) AS DATETIME)),100) dates,
      ceiling((CAST(COUNT(intUserID) AS FLOAT)/@EmployeeCount) * 100 ) theCount
 FROM
       tblNoticeResponse where ResponseDateTime IS NOT NULL
 GROUP BY
      convert(varchar(30), DATEADD(hh, DATEPART(hh, [ResponseDateTime]),
              CAST(FLOOR(CAST([ResponseDateTime] AS FLOAT)) AS DATETIME)),100)
LVL 2
brgdotnetcontractorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

reb73Commented:
Remove the Declare statements and use report parameters to indicate/configure the parameter variables..

See link below -

http://www.sql-server-performance.com/articles/reporting/report_parameters_p1.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chris LuttrellSenior Database ArchitectCommented:
as reb said, do not declare the input variables in the text of the sql.   Go to Report in the Menu and Report Parameters.  Add a parameter there and define it.  Leave off the @ so your @inputID would just be inputID, etc.
HTH
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.