Hello,
I have produced a Cognos 8.4 RS report showing Issues assigned to users.
I wish to deploy the report on our homepage as a 'live' report but the report should only show issues for the relevant user (based upon their login).
For example,
If user 'Cognos1' logs onto the homepage then the report should show issues assigned to user Cognos1.
How do I go about doing this?
Is this something in FM or can be done in RS?
Your help would be appreciated.
Ta!
It can be done both in FM and RS. In this case, you can do it in RS without doing it in FM.
Since you report shows issues assigned to users, you already have user-name/user-id there. You can use that in a filter by comparing it to the session parameter of FM for User-id/user-name.
Ex: [tablename].[user-id] = #sq($account.defaultname)#
There are different session parameters in FM for different values of user-id/user-name/initials etc. You will have to check which one corresponds to the value in your report and use that in the filter.