How to add parameter in the report

Question

How to add parameter in the report

LearningDBA

SSCertifiable

Points: 6609
More actions
June 2, 2014 at 11:50 am

#292010

Just wondering if I can get some help from the community.
I am brand new to SSRS and I just created my 2nd report. I have around 10000+ records and I would like to be able to sort it out by date or assignee and I am wondering if someone can help me add a parameter and kinda guide me what to do and how to do.
This is what I did so far:
Right click on parameter--> add parameter-->Data type "Text"
I don't know what else to do with all other values
Available values?
Default Values?
Advanced?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Can you be a bit more descriptive in what you need/want?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

LearningDBA SSCertifiable Points: 6609 More actions · Answer 2

Sure, I will try to give you as much information as I can.

I have this report which I created but my manager wants to be able to sort it out by "Assignee" or by "submit date" and I have NO IDEA how to accomplish that. Someone suggested to add a parameter but again "I don't know how to add a parameter"

"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Available values is the pane where you specify which values a user can choose when the report runs.

(when a report with parameters is run, you have to choose values for the parameters in prompts)

You can either supply values through a query, or hardcode them yourself.

The default values allows you to specify a value that is supplied to the parameter when the report is ran.

When a parameter has a default value, the report will be rendered without the user being asked to supply a value.

The user is able to change the value of the parameter and run the report again though.

Tutorial: Adding Parameters to a Report (SSRS)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 4

http://msdn.microsoft.com/en-us/library/dd220464.aspx

http://www.sql-server-performance.com/2007/report-parameters/

LearningDBA SSCertifiable Points: 6609 More actions · Answer 5

I was able to create a parameter but there are some issues I am running into and wondering if I can get some help from the community? I also included 3 attachments so you guys can get good overview of what I am trying to accomplish and what I have done.

1) When I type in full name, I am able to see the report but if I enter first name only, I don't see anything.

2) When I have multiple parameters like the assignee, startdate, enddate, I don't see anything in my report weather I type in the full name or first name only?

Things I would like to accomplish.

When I type in first name, it provides me with the result.

I also would like to have multiple parameter in my report if I decide to view the report by name or startdate or Enddate.

Forgive me if I am being too demanded.

Thanks 😀

"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

brian.keay Valued Member Points: 57 More actions · Answer 6

1. You have used the "=" operator so it will only filter on exact match, you could create a list of Employees, either as a dataset or by typing it in to "Available Values" and use that to populate your list, meaning that you should always get data.

2. From your third ss you have no dates populated, make sure that the data type for the @StartDate and @EndDate are in fact dates. You can also put in default values.

For example, if you want to run the report for the last 7 days you would put the following in for @StartDate default value:

=DATEADD("D", -7, TODAY())

and the following in for @EndDate

=TODAY()