SSRS second parameter doesnot refresh after input first parameter

Question

My SSRS report (2008 version) has two parameters. The first is a textbox receiving input for Supervisor' userid. The second is a drop-down list which depends on the first parameter to show the all the staff name working under the supervisor. After I input a supervisor userid for the first parameter, the second one does not refresh automatically. Then I press enter for the first parameter, an error message shows I have to select a value for the second parameter. My questions is how the second parameter can refresh automatically after I input the first parameter in the textbox.

Thank you very much for your help!

SELECT distinct a.[Last_Name]+', '+a.[First_Name] AS Staff_Name ,a.[Network_ID] AS Staff_ID ,a2.Network_ID as [Manager_ID] ,s.STF_NBR as Staff_Nbr FROM Client_All c INNER JOIN DimStaff d ON c.STF_NBR = D.ECMS_Wrkr_ID INNER JOIN STAFF s ON s.STF_NBR=D.ECMS_Wrkr_ID LEFT OUTER JOIN ADPFile a ON s.FILE_NBR=cast(a.FILE_NBR as nvarchar) LEFT OUTER JOIN ADPFile a2 ON a2.Position_NBR=a.Supervisor_Position_NBR WHERE a2.Network_ID =@User_ID ORDER BY Staff_Name — Ice
@User_id is Int Data type? Also check the independent parameter properties advanced tab if it is set to never refresh. I am suspecting the issue is related to data types. — alejandro zuleta

Hannover Fist Hannover Fist · Accepted Answer · 2015-10-19T16:29:41

Are both your parameters as well as the Network_ID all INTEGERS?

It might work better if your first parameter was also based on a drop-down based on another dataset.

SELECT DISTINCT a2.Last_Name + ', ' + a2.First_Name AS Manager_Name, a2.Network_ID as Manager_ID 
FROM Client_All c 
INNER JOIN DimStaff d ON c.STF_NBR = D.ECMS_Wrkr_ID 
INNER JOIN STAFF s ON s.STF_NBR = D.ECMS_Wrkr_ID 
INNER JOIN ADPFile a ON s.FILE_NBR = CAST(a.FILE_NBR AS nvarchar) 
INNER JOIN ADPFile a2 ON a2.Position_NBR = a.Supervisor_Position_NBR

SSRS second parameter doesnot refresh after input first parameter

1 Answers