SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


get report parameters to work


get report parameters to work

Author
Message
wendy elizabeth
wendy elizabeth
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1636 Visits: 789
I want to add report parameters to a sql server report service 2008 that has been generated by the report wizard and have the parameters work.
I can get the report parametes to look like they work by doing the following:
1. select view then report data then right click parameters in the report data window.
2. I then select add parameters then enter a 'name' then enter a prompt name and then select data type.
3. I then right click on the dataset and then click dataset properties and then click on parameteres in the dataset properties window and add

the parameters I want.

The above looks ok, but the parameters do not work.

What do I need to do get the report parameters to work either after a new report has been setup using the report wizard and/or adding the

report parameters to work at a later time.
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1975 Visits: 1944
Creating parameters in SSRS is step one...done

have you referenced those variables in your underlying dataset SQL query

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1975 Visits: 1944
Creating parameters in SSRS is step one...done

have you referenced those variables in your underlying dataset SQL query

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Ivan Donev
Ivan Donev
SSChasing Mays
SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)SSChasing Mays (629 reputation)

Group: General Forum Members
Points: 629 Visits: 414
There are two approaches in order to actually get report parameters to work.

Approach one: when you create your underlying dataset, you explicitly define the parameters in a where clause of the statement by putting a @ symbol in front of the identifier (name) of the parameter. For example:
select employee_name from Employees where employee_id = @emp_id



Here @emp_id states it is a parameter and when you create such dataset SSRS actually performs two actions - first it creates a parameter (you can find in Parameters Tab in BIDS) and second - it binds the newly created parameter with the parameter defined on a dataset level (when you define a dataset, there is a Parameter tab, where such definitions are created

Approach two - you first create a parameter and then reference it in the dataset - if you did this, you must open your dataset properties, go to Parameters and explicitly define binding between parameters in the report and the parameters in the dataset (again, parameters in the dataset must be starting with @symbol)

My reccomendation is to use always approach one as at most of the times it does most of the work for you and all you need to do is customize the automaticalyy created parameters.

/ivan
Raunak Jhawar
Raunak Jhawar
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1975 Visits: 1944
Thought you required answer...turned the other way round...cheerz!!! :-D

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search