Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Pass parameters to report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello guys,

    I would like to know if there is any way to pass some parameter at run time to the report. What im trying to do is: when user select the report, the report runs with the current user id. There is some way to do this ?

    tyvm.
    Thursday, January 21, 2010 3:46 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    if you use filteredview in your report query then CRM will automatically handles this with in each view..so user will able to view only the relevant record based on user 's security role....
    Thursday, January 21, 2010 5:55 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    SELECT [dbo].[fn_FindUserGuid] ()

     

    above function will give you user id in report query..

    Thursday, January 21, 2010 4:03 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    heheh, you did not understand, the report needs to know the current crm user ;). Imagine that you go on report tab and select a report, how the report ll know which user is clicking on it ? 
    Thursday, January 21, 2010 5:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    if you use filteredview in your report query then CRM will automatically handles this with in each view..so user will able to view only the relevant record based on user 's security role....
    Thursday, January 21, 2010 5:55 PM