So we are using CRS2008 and trying to achieve row level security along with the values that show up in the parameter list and facing a chicken and egg situation.
So created a blank report and made formula for CurrentCEUserName and then made subreport which has a proc which takes in value to filter data for the person logged in and till now just to get the data filtered is simple.
The complexity arises when there are parameters on the subreport based on the dataset so when i run the report the parameter kicks in first and asks for the user and then based on that the parameter values are filtered and even though there is data securtiy the person has to enter his id again and this is not as planned.
Is there a way around so that the parameters asks the question after the formula is processed or any other way so that the parameter values are poupulated based on the person logged in without him having to enter the id again.
Thanks.
So created a blank report and made formula for CurrentCEUserName and then made subreport which has a proc which takes in value to filter data for the person logged in and till now just to get the data filtered is simple.
The complexity arises when there are parameters on the subreport based on the dataset so when i run the report the parameter kicks in first and asks for the user and then based on that the parameter values are filtered and even though there is data securtiy the person has to enter his id again and this is not as planned.
Is there a way around so that the parameters asks the question after the formula is processed or any other way so that the parameter values are poupulated based on the person logged in without him having to enter the id again.
Thanks.