Question on Parameters

Hi Karen,

Based on your description, did you add cascading parameter in the report? The third and fourth parameters is depend on the first and second parameters.

If I understand correctly, the issue is if there have no data return by the first and second parameters, it will have no values to be select in the third and fourth parameters. It will let us to select a value for the corresponding parameter. In this situation, please refer to the steps below to resolve the issue:

1. Double click the third parameter.


2. Select “Allow null value” option in the General dialog box.


3. Click Default Values in the left pane.


4. Click “Add” icon and fill with “Null” value.


5. Use the same method to configure the fourth parameter.

If there are any misunderstanding, please elaborate the issue for further analysis.

Regards,

Alisa Tang

---

Alisa Tang

TechNet Community Support