I have a requirement to show the drill through report in a new window(using SSRS 2008) . But I have a problem while implementing the Role Based Security. I am using a Parameter @Lan_ID and passing the build in field value "User!UserID" (to capture the UserID of running the report ).
I am using the above logic to implement the Role based security.
I am creating the parameter (@Lan_ID ) as "Hidden" in both the Main and the Drill through report and Passing through the Query String URL from the Main Report to the drill through report. It doesn't work and getting error message below when i click on the drill through column in main report..
Error message : Parameter @Lan_ID is missing a value .
When i change the parameter type to "Internal" , I am getting the error message below.
Error : Report Parameter is read only and cannot be modified.
Requirement : I want to hide the Lan_ID and pass from the Main report to Drill through report . I am not sure how to exactly achieve this without any error. I will really appreiate your help if you walk me through the steps and provide me a solution.