[Solved]displaying user-class in report studio

[BIsrik]

Hi,

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

Srik

[BIsrik]

Any help on this....

Srik

[sir_jeroen]

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

[BIsrik]

solved

[sir_jeroen]

Share us your solution please otherwise we have to keep on helping ppl with the same problem...

[Sudha]

Can you post your Solution here, I have the same kind requirement here

T I A

[BIsrik]

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

[sir_jeroen]

Ok... tnx for sharing... Keep us updated if you get it to work in RS...

[Draoued]

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

Code Select Expand


#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.

[sir_jeroen]

Well... that's a very nice trick.. Tnx for sharing!!!

[BIsrik]

Thanks a lot...

Srik