COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: katerina00 on 11 Aug 2005 01:40:52 PM

Title: User ID on footer and default prompt based on System Year
Post by: katerina00 on 11 Aug 2005 01:40:52 PM
Hello,

I have two ReportNet questions that are keeping me from completing my first report.Ã, 
1)Ã,  Does anyone know how to add the ID of the User running a report to the footer of the report?
2)Ã,  Does anyone know how I can default the current year on a prompt.Ã,  As far as I can see I have to put a specific value as a prompt default.Ã, 

Your input will be appreciated.

Thank You,
Katerina
Title: Re: User ID on footer and default prompt based on System Year
Post by: CoginAustin on 11 Aug 2005 02:18:23 PM
Add a calculation field with this macro:

#sq($account.personalInfo.userName)#

If you want to place it anywhere on your page I believe you will have to associate the Page with a QUERY or some sort.

Title: Re: User ID on footer and default prompt based on System Year
Post by: Darek on 11 Aug 2005 09:29:14 PM
1. You could once a year set a prompt value.
2. You could do the same with a piece of SDK code running at 00:00:01 on 01/01
3. You could write a small JavaScript and insert it as HTMLItem into the prompt page.