Problem with Report Created with BIRT
Good Morning,
I designed a custom report with BIRT that takes two parameters as input (both are dynamic list boxes that allow multiple values which I suspect are read into two arrays at startup).
In order to filter my results based on these arrays, in the data set "Filters" tab I simply specified that the filtered data had to be "in" the parameter. Just to give it more context, a parameter I am using is called "inputOwners" and the data I want to filter is "CONTRIBUTOR_NAME" from the LIVE_WORKITEM_CNT table. My filter reads:
row In params.value
When I preview the report I can set the two parameters and the filtered information displays perfectly, and I am happy. Now comes the problem.
When I create a report template in RTC using the rptdesign file that BIRT generates and create a report based on the template, I get the following error once I have set the parameters and run the report via the web interface:
http://i.imgur.com/59cUV.png
I don't understand why the same report won't work in RTC when it works perfectly in BIRT.
Why does this happen, and how can I solve it?
Thank you in advance!
Best regards,
Andrew
I designed a custom report with BIRT that takes two parameters as input (both are dynamic list boxes that allow multiple values which I suspect are read into two arrays at startup).
In order to filter my results based on these arrays, in the data set "Filters" tab I simply specified that the filtered data had to be "in" the parameter. Just to give it more context, a parameter I am using is called "inputOwners" and the data I want to filter is "CONTRIBUTOR_NAME" from the LIVE_WORKITEM_CNT table. My filter reads:
row In params.value
When I preview the report I can set the two parameters and the filtered information displays perfectly, and I am happy. Now comes the problem.
When I create a report template in RTC using the rptdesign file that BIRT generates and create a report based on the template, I get the following error once I have set the parameters and run the report via the web interface:
I don't understand why the same report won't work in RTC when it works perfectly in BIRT.
Why does this happen, and how can I solve it?
Thank you in advance!
Best regards,
Andrew
One answer
On 6/30/2010 5:08 AM, spriteburn wrote:
We have a wiki page that documents some important differences between
the BIRT report previewer and the RTC report viewer:
https://jazz.net/wiki/bin/view/Main/ReportsViewingDifferences
In your case, look at "Parameter Values", hte last entry.
james
RTC Reports Team Lead
Good Morning,
I designed a custom report with BIRT that takes two parameters as
input (both are dynamic list boxes that allow multiple values which I
suspect are read into two arrays at startup).
In order to filter my results based on these arrays, in the data set
"Filters" tab I simply specified that the filtered data had
to be "in" the parameter. Just to give it more context, a
parameter I am using is called "inputOwners" and the data I
want to filter is "CONTRIBUTOR_NAME" from the
LIVE_WORKITEM_CNT table. My filter reads:
row In
params.value
When I preview the report I can set the two parameters and the
filtered information displays perfectly, and I am happy. Now comes
the problem.
When I create a report template in RTC using the rptdesign file that
BIRT generates and create a report based on the template, I get the
following error once I have set the parameters and run the report via
the web interface:
http://i.imgur.com/59cUV.png
I don't understand why the same report won't work in RTC when it works
perfectly in BIRT.
Why does this happen, and how can I solve it?
Thank you in advance!
Best regards,
Andrew
We have a wiki page that documents some important differences between
the BIRT report previewer and the RTC report viewer:
https://jazz.net/wiki/bin/view/Main/ReportsViewingDifferences
In your case, look at "Parameter Values", hte last entry.
james
RTC Reports Team Lead