Welcome to the Jazz Community Forum
One question about custom report in dashboard viewlet

I am using BIRT to generate one report displaying all the team blockers, there are 2 parameters one is Filed Against (Category Name), another one is Iteration Name. The report works in RTC client. Also works when I create a report in RTC web site.
But when I put it to dashboard, the problem occurs, if no parameter selected, the report display fine, display all data by default. But if I edit settings (edit Query), select one parameter, from preview I can see there is data (that is correct). But when I save the settings all data disappear. Show me "No Results were found."
Do you know where I made a mistake?
But when I put it to dashboard, the problem occurs, if no parameter selected, the report display fine, display all data by default. But if I edit settings (edit Query), select one parameter, from preview I can see there is data (that is correct). But when I save the settings all data disappear. Show me "No Results were found."
Do you know where I made a mistake?
6 answers

Hi Xudong,
A few follow-up questions to clarify the issue.
(1) When you see the BIRT report works in the RTC web site, do you mean that you deployed the report template to the project area and it shows up in the Reports Web UI and can be configured to display results as expected?
(2) How did you contribute the new trend report to the Dashboard?
Did you contribute the new report via the development-time extension point contribution mechanism by declaring a new viewlet? Or did you contribute the new report via the run-time process contribution mechanism using the project area editor?
(3) Did you create a new "micro" trend report BIRT template for Dashboard use? (that corresponds to the normal trend report BIRT template)
(4) Just to confirm you say you are seeing results when previewing the report parameter selections in the Reports parameter chooser used by the viewlet?
(5) When you save the viewlet preferences or do a viewlet refresh with the preferences already saved. Are you seeing any errors in the Firefox Firebug console or the RTC client Java Console view?
(6 a) If you click on the trend report viewlet title hyperlink after configuring the trend report viewlet with the selected parameters that show no results, does it show results in the Reports Web UI after navigation occurs?
(6 b) If you open the reports parameter section in the drill-in report result do you see the same report parameter selections you made in the viewlet?
A few follow-up questions to clarify the issue.
(1) When you see the BIRT report works in the RTC web site, do you mean that you deployed the report template to the project area and it shows up in the Reports Web UI and can be configured to display results as expected?
(2) How did you contribute the new trend report to the Dashboard?
Did you contribute the new report via the development-time extension point contribution mechanism by declaring a new viewlet? Or did you contribute the new report via the run-time process contribution mechanism using the project area editor?
(3) Did you create a new "micro" trend report BIRT template for Dashboard use? (that corresponds to the normal trend report BIRT template)
(4) Just to confirm you say you are seeing results when previewing the report parameter selections in the Reports parameter chooser used by the viewlet?
(5) When you save the viewlet preferences or do a viewlet refresh with the preferences already saved. Are you seeing any errors in the Firefox Firebug console or the RTC client Java Console view?
(6 a) If you click on the trend report viewlet title hyperlink after configuring the trend report viewlet with the selected parameters that show no results, does it show results in the Reports Web UI after navigation occurs?
(6 b) If you open the reports parameter section in the drill-in report result do you see the same report parameter selections you made in the viewlet?

Hi Xudong,
A few follow-up questions to clarify the issue.
(1) When you see the BIRT report works in the RTC web site, do you mean that you deployed the report template to the project area and it shows up in the Reports Web UI and can be configured to display results as expected?
<b>Yes</b>
(2) How did you contribute the new trend report to the Dashboard?
Did you contribute the new report via the development-time extension point contribution mechanism by declaring a new viewlet? Or did you contribute the new report via the run-time process contribution mechanism using the project area editor?
<b>the step is: Open project area -> Process Configuration -> Configuration Data -> Dashboards -> Viewlet chooser entries -> add viewlet-entry, then New a trend report put the report template Identifier as report ID. Save the project area, got to IE Browser, open the RTC web, open dashboard, new a viewlet select the entry I just added</b>
(3) Did you create a new "micro" trend report BIRT template for Dashboard use? (that corresponds to the normal trend report BIRT template)
<b>Please refer to #2 </b>
(4) Just to confirm you say you are seeing results when previewing the report parameter selections in the Reports parameter chooser used by the viewlet?
<b>Yes, when I added the new viewlet to dashboards, the report without any parameters, the report could display all data correctly. But When I edit settings to select one parameter, before save, I could use preview to see the data, that is correct. But after I saved the settings, no results found</b>
(5) When you save the viewlet preferences or do a viewlet refresh with the preferences already saved. Are you seeing any errors in the Firefox Firebug console or the RTC client Java Console view?
<b>Just Now, tried in firefox with firebug open, no error found</b>
(6 a) If you click on the trend report viewlet title hyperlink after configuring the trend report viewlet with the selected parameters that show no results, does it show results in the Reports Web UI after navigation occurs?
<b> after I added the report viewlet to dashboards, and select some parameter, save, no results found. but If I click on the viewlet title hyperlink, the report will open and display the correct data</b>
(6 b) If you open the reports parameter section in the drill-in report result do you see the same report parameter selections you made in the viewlet?
<b>Yes, they are the same</b>
Hi mpawlow, thanks for your response, I have put my update in bold.

Hi Xudong,
A few follow-up questions to clarify the issue.
(1) When you see the BIRT report works in the RTC web site, do you mean that you deployed the report template to the project area and it shows up in the Reports Web UI and can be configured to display results as expected?
<b>Yes</b>
(2) How did you contribute the new trend report to the Dashboard?
Did you contribute the new report via the development-time extension point contribution mechanism by declaring a new viewlet? Or did you contribute the new report via the run-time process contribution mechanism using the project area editor?
<b>the step is: Open project area -> Process Configuration -> Configuration Data -> Dashboards -> Viewlet chooser entries -> add viewlet-entry, then New a trend report put the report template Identifier as report ID. Save the project area, got to IE Browser, open the RTC web, open dashboard, new a viewlet select the entry I just added</b>
(3) Did you create a new "micro" trend report BIRT template for Dashboard use? (that corresponds to the normal trend report BIRT template)
<b>Please refer to #2 </b>
(4) Just to confirm you say you are seeing results when previewing the report parameter selections in the Reports parameter chooser used by the viewlet?
<b>Yes, when I added the new viewlet to dashboards, the report without any parameters, the report could display all data correctly. But When I edit settings to select one parameter, before save, I could use preview to see the data, that is correct. But after I saved the settings, no results found</b>
(5) When you save the viewlet preferences or do a viewlet refresh with the preferences already saved. Are you seeing any errors in the Firefox Firebug console or the RTC client Java Console view?
<b>Just Now, tried in firefox with firebug open, no error found</b>
(6 a) If you click on the trend report viewlet title hyperlink after configuring the trend report viewlet with the selected parameters that show no results, does it show results in the Reports Web UI after navigation occurs?
<b> after I added the report viewlet to dashboards, and select some parameter, save, no results found. but If I click on the viewlet title hyperlink, the report will open and display the correct data</b>
(6 b) If you open the reports parameter section in the drill-in report result do you see the same report parameter selections you made in the viewlet?
<b>Yes, they are the same</b>
Hi mpawlow, thanks for your response, I have put my update in bold.
Hi Xudong! Any updates on that issue?! I have the same problem to visualize my reports in a dashboard viewlet. I get the same "No results were found".
Thanks!

Hi Xudong, Victor,
I just authored the following related Wiki documents relevant to this forum post:
* How To Add New Dashboard Trend Reports
https://jazz.net/wiki/bin/view/Main/HowToAddNewDashboardTrendReports
=> Run-time process contribution mechanism
=> Development-time extension point contribution mechanism
* How To Add, Deploy & Update BIRT Report Templates
https://jazz.net/wiki/bin/view/Main/HowToDeployBIRTReportTemplates
* How To Provision Bundles to a CLM Server Running Tomcat:
https://jazz.net/wiki/bin/view/Main/HowToProvisionBundlesJazzServer
=> Server Reset Method
Can you review the documents and verify that you followed all of the steps correctly?
From your response, it sounds like there is something wrong with the micro BIRT report template you authored (unless there is a similar issue with any of the other out-of-the-box micro BIRT report templates).
Perhaps, you could send me the micro BIRT report template by email.
OR paste the XML source of the BIRT report template in this forum (if you are legally allowed to do so).
Sorry for the late response.
I just authored the following related Wiki documents relevant to this forum post:
* How To Add New Dashboard Trend Reports
https://jazz.net/wiki/bin/view/Main/HowToAddNewDashboardTrendReports
=> Run-time process contribution mechanism
=> Development-time extension point contribution mechanism
* How To Add, Deploy & Update BIRT Report Templates
https://jazz.net/wiki/bin/view/Main/HowToDeployBIRTReportTemplates
* How To Provision Bundles to a CLM Server Running Tomcat:
https://jazz.net/wiki/bin/view/Main/HowToProvisionBundlesJazzServer
=> Server Reset Method
Can you review the documents and verify that you followed all of the steps correctly?
From your response, it sounds like there is something wrong with the micro BIRT report template you authored (unless there is a similar issue with any of the other out-of-the-box micro BIRT report templates).
Perhaps, you could send me the micro BIRT report template by email.
OR paste the XML source of the BIRT report template in this forum (if you are legally allowed to do so).
Sorry for the late response.

There is a similar thread here where I have posted a question if someone knows how to solve it, please:
After we set this widget up in the dashboard and click on Settings, we can select Project, Report and Query.Project is ok, but the Report we built does not show up in the Report drop down and, therefore, we cannot set the parameters for our widget.
The instruction to test the widget in the page Vladimir posted seems to jump this step:
- Open the viewlet settings area
- Select the project area that you added the viewlet entry to (should be selected by default).
- ?
- Configure the report
Query (How do I?)