May 16, 2016 at 10:45 pm
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!!!
May 17, 2016 at 4:43 am
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
May 30, 2016 at 3:42 am
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