Report studio and Active Directory

[eladan]

Is it possible to bring information from the Active Directory to my report?

For example:
Iv got a list of people. Correctly, their first + last name is wrote by hand. Instead, i would like to bring their first+last name from the Active directory to columns in my list.

Thanks :)

[MFGF]

Hi,
I am on my iPhone right now so This is purely from memory...

Try adding a Query Calculation into your list, and use the following syntax:

#sq($account.defaultName)#

Apologies if I got this wrong - I can't check just now.

Regards,

MF.

[eladan]

Thank you for the quick answer!

But unfortunately, it doesnt work..
When i validate, it gives me errors  :'(   

[CognosPaul]

Do you mean you want to use AD as another data source, and pull a list of users from it?

[eladan]

Hey,

Yes, AD already configured, i want to pull list of the users...

[CognosPaul]

I really don't know if this is possible.

AD stores it's database in NTDS.DIT, but I have no experience connecting to it as a data source.

My instinct is to recommend pulling your employee list from another source. AD is foremost an authentication provider. Running reports off it may over burden it. There may also be information security concerns when using AD as a data source.