March 29, 2016 at 4:15 pm
In an ssrs 2008 report, I would like to add logic that looks the following for determining if a row is visible are not.
The logic is the following =iif(Fields!MILESTONE_CODE.Value = "015", false, true)
However I would like to expand this logic out for a user to be able to select one or multiple milestone values based upon a parameter to be setup called pmilestone.
The milestone values will look like:
"005" for 5 days,
"010" for 10 days,
"015" for 15 days, and
"020" for 20 days.
Thus could you show me the ssrs code that will accomplish the row visibility logic I am looking for? In addition, would you show me how to setup the corresponding parameter logic so the row visibility logic will work?
March 29, 2016 at 4:44 pm
In an ssrs 2008 report, I would like to add logic that looks the following for determining if a row is visible or not.
If you want rows to now show in your report, either filter them out in your stored procedure by using a WHERE clause or use a FILTER on your dataset.
Normally, you would make *columns* visible (or not) based on some condition... rows you would filter out.
March 29, 2016 at 10:22 pm
Would you show me how to sue the filter out option on the dataset?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply