SSRS Report parameters

  • Hi All

    Need to create a SSRS report with four parameters that users can filter with, I know this sounds simple but i'm not an SSRS fundi

    Attached is the structure of my table and columns I need filtering with, the current report is not as efficient as i would like it to be any help appreciated

    Thanks

    It's better to fail while trying, rather than fail without trying!!!

  • What are you struggling with? I'm not sure I understand.

    If you're stuck implementing the parameters into your code, you use the parameter in place of a value.

    E.g if we have a parameter called "pGender" to get either all males or all females (or all undefined) in our database:

    SELECT p.Name,

    p.DOB,

    p.Address,

    p.Gender

    FROM dbo.MyPersonTable p

    WHERE p.Gender = @pGender

  • I guess your question is simply to fetch the result of a query in the report based on some set of input parameters.

    I that case, first define two parameters for example @BusinessGrpId and @CostCenter and have the default values as 81 and 152800 respectively.

    create a dataset with a query

    Select Company_Code, Responsibility

    from table

    where BUSINESS_GROUP_ID = ? and

    COST_CENTER_CODE = ?

    Then in the data set parameters assign the both question mark with @BusinessGrpId and @CostCenter parameters value respectively.

    Use a table in the report design pane to display the result set.

    Hope this helps you in closing the discussion.

Viewing 3 posts - 1 through 2 (of 2 total)

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