December 21, 2015 at 9:23 am
In a new SSRS 2008 report, I want to add the following logic to a parameter called 'Inventory Date'. Right now I default the Inventory date to today's date. What happens on this ssrs report is one customer or all customers can be selected based upon a parameter called 'customer selection'. If one particular customer is selected, then I display all the applicable customers in a parameter called 'customers'. Then based upon the customer that is selected I want to display all the Inventory Dates that are applicable to that customer. If all customers are selected, then only today's date will be displayed.
Thus would you tell me how to setup this logic in an ssrs 2008 report?
December 28, 2015 at 5:48 am
HI
Try to add IIF statement on your Date parameter as a dependent parameter.
Let say the total number of all your customers is 50
IIF(Parameters!Customer.count = 50, today(), Parameters!Date.value)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply