It's all about the answers!

Ask a question

Report Studio


Pankaj Salve (622) | asked Feb 21 '14, 2:38 a.m.
retagged Feb 21 '14, 4:55 a.m. by Francesco Chiossi (5.7k11119)
Hello,

I am designing a sample report using Report Studio and want to display All RTC project and projects active Users.

how to link projects with its different users in report studio??

2 answers



permanent link
Francesco Chiossi (5.7k11119) | answered Feb 21 '14, 4:54 a.m.
Hello Pankaj

to create a report with the information on projects and related resources you can do like this:

1) Add a list to your report and drag and drop the following data items:
  • Operational Data Store > Project Area > Project > Classification Name (this tells you to which application the project belongs)
  • Operational Data Store > Project Area > Project > Name (name of the project)
  • Operational Data Store > Project Area > Project Related resources> Name (name of the user associated to the project)

2) You might want to group by project name

3) and filter on Classification Name to only display the value "RTC Project Area"

[Classification Name] = 'RTC Project Area'


Here a sample of the output:


Best Regards,


Francesco Chiossi


Comments
Pankaj Salve commented Feb 21 '14, 5:54 a.m.

Hi Francesco,

Thanks a lot.
this is really useful and exactly what i want.

can you please let me know how can i will get a country of project or user to display in report?

Regards,
pankaj
 


permanent link
Francesco Chiossi (5.7k11119) | answered Feb 21 '14, 7:16 a.m.
Hello Pankaj,

unfortunately the country information for resource or project is not available in the data warehouse for reporting.
I'm not even sure if this information is available somewhere in RTC itself.

Best Regards,

Francesco Chiossi

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.