It's all about the answers!

Ask a question

Custom report in Dashboard Widget?


Cesar Ida (1815) | asked Mar 16 '16, 2:47 p.m.
edited Mar 16 '16, 2:49 p.m.
Is it possible to create a custom report in Report Builder (6.0.1) and use it in Dashboard Widget?
I would like to query on work items from multiple projects areas and publish it in Dashboards, so I think this would be a good way to do it.
 
Thanks in advance.
Cesar

Accepted answer


permanent link
Darren Coffin (1823) | answered Mar 16 '16, 3:07 p.m.
JAZZ DEVELOPER
Hi Cesar,

Yes, you can create a custom report in Report Builder, set it to Public instead of Private, and then add it to your CLM dashboard as a widget.  All of your public Report Builder reports will be listed if you change the "Catalog" dropdown to Report Builder when you are adding a widget.
Cesar Ida selected this answer as the correct answer

2 other answers



permanent link
Cesar Ida (1815) | answered Mar 16 '16, 3:47 p.m.
 Thank you very much guys, very nice answers!

Best regards.
Cesar

permanent link
Kevin Cornell (5411) | answered Mar 16 '16, 3:08 p.m.
Yes. In order to create a report with a custom query, you either have to be a Report Builder manager or the corresponding data source option "Restrict query editing to report managers" must not be selected. To examine the data source properties, click on the data source name link in the Choose report type section of the report editor.

In Report Builder create a new report, select the data source and choose the artifact type that you want to start with. After the initial query is generated, go to the Advanced tab and click the Edit button to put the report into manual edit mode. At this point a custom SQL (DW) or SPARQL (LQE) query can be written for the report. Save the report with a corresponding name, specify a tag (for grouping in the widget catalog) and set the privacy option to Public.

In the Dashboard, choose the Report Builder application and in the left panel you should see the tags used to group public reports. Select the tag that was specified in the report and add the widget to the dashboard.



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.