BIRT Report Designer: Preview
After upgrading from SCTM 12 to SCTM 15, the report preview within BIRT designer does not work any more: All reports are empty.
I already added the newly introduced report parameter currWebserviceURL and currProjectID, but that did not solve the problem. Maybe I provided wrong parameter values.
Did anyone solve this problem?
Is this a report that retrieves data from a Silk Central report, probably from one of the shipped reports?
With the upgrade to 15.0, global reports have been introduced and the report IDs changed.
Are there any error messages in the report that could provide more information?
An empty report without any error would normally occur if there are no results for the Silk Central report (empty data tab) or for incorrect project/report/session IDs.
thank you very much for your reply. The report is self-made and I double checked project/report/session ID.
The report does contain no data or error message. Only the header and footer are displayed with empty data fields. Inside SCTM the report works as expected.
I am not sure what value to use for the parameter currWebserviceURL?
But even shipped reports seems not to work, since I am not able to preview the template "All requirements with History.rptdesign", too. But in this case, the report shows an error message: "Report parameter "currHandlerID" does not exist."
the value of currWebserviceURL is used to contact the Silk Central web service, in most cases it is the same as the frontend server URL, http://<server>:19120. If it is not set correctly, this could be the problem.
Some of the shipped reports don't have all the necessary report parameters defined in the template. In Silk Central they work anyway as the missing parameters are set on execution, but for previewing them in BIRT designer the parameters have to be added. For the template "All Requirements with History" those are:
currHandlerID (default value: reportData)
I am still unable to open a preview of a BIRT report. I downloaded the report "All Requirements with History" and adapted the following things:
- Configure "Data Source" to access our SCTM DB (test connection works).
- Add the following report parameter as type STRING:
- Configure Report Parameter
- currShortDateOnlyFormatter: dd.MM.yyyy (default)
- reportGeneratedAt: (default)
- currFrontendURL: http://testmanager (it's the same URL we use with web browser).
- currReportFilterID: 44173 (default; verified it's still valid)
- currSessionID (a freshly generated one)
- sourceDriver: (copied from "Data Source")
- sourceURL: (copied from "Data Source")
- sourceUser: (copied from "Data Source")
- sourcePassword: (copied from "Data Source")
- currHandlerID: reportData
- currProjectID: 478 (verified it's valid)
- currWebserviceURL: http://testmanager
Running the preview still results in an empty report. Do you have any further suggestion?
With best regards,
the parameter values look OK.
Could it be that you are still using the BIRT designer that was downloaded from Help/Tools of the 12.0 version? A Silk Central .jar file is included in the BIRT designer package, that has to be updated to connect to 15.0. Can you try again with the current package from Help/Tools if this is the case?
that is it. I thought updating BIRT designer is not necessary, since the designer's version number did not change. Furthermore, neither Release-Notes nor documentation mentions, that an update would be necessary.
After freshly installing the BIRT designer from Tools download the preview works fine. Thank you so much.
With best regards,