How to display the User Name, who run the report
Displaying Dynamic UserName Steps:
Step1: Login into your Cognos Portal.
Step2: Open the Report Studio.
Step3: Select any package.
Step4: Open a blank report.
Step5: Drag one query in Query Explorer.
Step6: Drag one data item.
Step7: Copy and paste this syntax: #sq($account.personalInfo.userName)#
Step8: Convert the whole page into query 1 & drag the data item into that page.
Step9: Run and Save the Report.
Step1: Login into your Cognos Portal.
Step2: Open the Report Studio.
Step3: Select any package.
Step4: Open a blank report.
Step5: Drag one query in Query Explorer.
Step6: Drag one data item.
Step7: Copy and paste this syntax: #sq($account.personalInfo.userName)#
Step8: Convert the whole page into query 1 & drag the data item into that page.
Step9: Run and Save the Report.
very nice info.. thnx.. ur blog is very good..
ReplyDeleteThanx Akshu. let me know if you have interest in any other topics/tips.
ReplyDelete