COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: BIsrik on 29 Sep 2005 01:21:03 AM

Title: [Solved]displaying user-class in report studio
Post by: BIsrik on 29 Sep 2005 01:21:03 AM
Hi,

How should i display the user class ( Not the user name) in report studio.

Srik
Title: Re: displaying user-class in report studio
Post by: BIsrik on 04 Oct 2005 09:10:10 AM
Any help on this....

Srik
Title: Re: displaying user-class in report studio
Post by: sir_jeroen on 04 Oct 2005 12:39:46 PM
I don't know if it's possible in RS but in FM you can add a database query subject in FM in which you can use a macro function.. Take a look at that FM help look for CSVIdentityNameList... That's all
Title: Re: [Solved]displaying user-class in report studio
Post by: BIsrik on 06 Oct 2005 07:29:20 AM
solved
Title: Re: [Solved]displaying user-class in report studio
Post by: sir_jeroen on 06 Oct 2005 11:01:44 AM
Share us your solution please otherwise we have to keep on helping ppl with the same problem...
Title: Re: [Solved]displaying user-class in report studio
Post by: Sudha on 06 Oct 2005 11:53:03 AM
Can you post your Solution here, I have the same kind requirement here

T I A
Title: Re: [Solved]displaying user-class in report studio
Post by: BIsrik on 07 Oct 2005 01:20:47 AM
Hi,

I am still trying to get this in RS itself. but as of now, i used the CSVidentityname macro and created a calcution in FM for displaying the userclass.

Srik
Title: Re: [Solved]displaying user-class in report studio
Post by: sir_jeroen on 07 Oct 2005 01:33:27 AM
Ok... tnx for sharing... Keep us updated if you get it to work in RS...
Title: Re: [Solved]displaying user-class in report studio
Post by: Draoued on 07 Oct 2005 05:36:14 AM
By adding a fake field in the Tabular model, you can have it directly in the Report studio without adding it into FM.

Add a field in Tabular model containing

#sq(CSVIdentityNameList ())#


then you can place this field where you want in the report.
If the report is saying you can not add in Header or Footer.
Select Page in Properties , and associate your query with the page.
Title: Re: [Solved]displaying user-class in report studio
Post by: sir_jeroen on 07 Oct 2005 06:49:38 AM
Well... that's a very nice trick.. Tnx for sharing!!!
Title: Re: [Solved]displaying user-class in report studio
Post by: BIsrik on 07 Oct 2005 10:10:48 AM
Thanks a lot...

Srik