Hi,
I have created a Data Source that requires the SQL server authentication, then I would like that the user which is logged can only access to his personal data. So I have created a Report Parameter, but I cannot discover how to put SQL user in the function. (I managed to put the Windows user (=User!UserID), but it’s not the solution in this case, unfortunately)
Thank you very much for your help or ideas.
I have created a Data Source that requires the SQL server authentication, then I would like that the user which is logged can only access to his personal data. So I have created a Report Parameter, but I cannot discover how to put SQL user in the function. (I managed to put the Windows user (=User!UserID), but it’s not the solution in this case, unfortunately)
Thank you very much for your help or ideas.