How to give parameters in SSRS in the Report

Question

How to give Parameters in the SSRS Report. Based on the given Parameters, I want to view the Report ?

Thanks
Deepthi
                                                         

Answer 1

I'm afraid that you'll need to explain your problem or question in greater detail. 
How have you designed the report and what have you done so far?  What version of Reporting Services are you using?

---

Paul Turley [Hitachi Consulting] SQLServerBIBlog.com

Answer 2

Hello Deepthi,

I suppose you are new to SSRS.

Regarding Parameters in a report refer below links for more information
http://msdn.microsoft.com/en-us/library/aa337432(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/aa337460(SQL.90).aspx

It would be better if you clearly state you issue.

Hope helpful...

---

Pavan http://www.ggktech.com

Answer 3

Hi Deepthi,

I think you want to the parameter from other program to report, right?

Reporting Services use URL to pass the parameter. So it depends on how you write the URL.

For your reference: http://msdn.microsoft.com/en-us/library/ms153586.aspx

Hopefully this helps.

---

Yao Jie Tang -Microsoft Online Community

Answer 4

Based on your information, i think you need to set up the filter within the dataset in which you make an expression based on the parameter you made.

steps:
1. make the parameter (report data explorer, [parameter])
2. in the report explorer, right click on the dataset
3. in the menu go to properties
4. in the screen "dataset properties" go to [parameter]
5. add the parameter (from step 1)
6. in the screen "dataset properties" go to [filters]
7. fill the expression for instance based on the field where the parameter has to be related to
8. at the operator choose the one you need
9. at the value, fill in an expression with the parameter or just the parameter.

This was quite basic of course, but because your question wasn't specific i thought maybe you needed also a basic answer