BIRT Report Parameter not working once deployed?
Hello Folks,
I am having problems using Report Parameters to filter the content of my Data Set table within my report. I have a report parameter (combo box) that enables the possibility to filter my Data Set according to a simple String matching criterion (row Equals to  params). The Report Parameter has a default value, and everything works fine the first time I open my report that uses this default value. But when I change that parameter value and press run to recreate the report using a different value than the default value, no data is displayed. It all works fine within my preview tab in the report designer and in the BIRT report viewer, but when I run the report in Rational Team Concert, and then changing the report parameter will not work anymore. Does anyone know whats wrong? I use RTC 1.0.1 and installed the BIRT libraries referenced by an official article on the Jazz.net web site. Thanks |
7 answers
To allow users to select multiple values for parameters, the parameter value has the following syntax: 'val1','val2','val2'...
If the user passes a single value, the value will be something like 'val' instead of val. So in the filter javascript, you need to remove the quotes from the string and tokenize the values using ',' as a separator. |
|
I understand what you are saying, but I do not have multiple parameters in my case, there is only one filter entry for that table (row Equals to  params), and only one name can be selected at a time. Also the parameter entry element is a combo box, so the user is not supposed to manualy type in the filter string, but select one from that combo.
The strange thing is that it works fine in my report design preview window, only once deployed to my RTC project executed through the web interface it doesn't work anymore. It seems like the string used by the parameter is formatted wrong, but that's only a guess of course. If you have any other suggestions, that would be great! Thanks |
Hi Michael,
Am facing similar issue; Its working perfectly fine with BIRT report preview; once uploaded to server the report parameter selected is not taking effect at all. I was using this parameter as a filter and irrespective what I select in the combo it shows all the records available. Were you able to resolve this? Requesting you to let me know, if am missing something. Many thanks. Regards, Mohan. |
On 8/6/2009 6:23 AM, mmksri76 wrote:
Hi Michael, Hi Mohan, I've replied to your problem in the other thread. james |
Hi,
I am Geeting some problem in BIRT with report parameters
In my report, I have one parameter. During first time load, the parameters popup page shows and accepts input value, ex: 1000. Based on this input, the report renders and shows result.
I tried to change the input value by choosing 'run report' button in the report page, which pops up the same parameters page. But after changing value from 1000 to 2000 which is a valid value, the report refreshes but renders with original input value say 1000 but not with new value 2000. This behaviour exits for other data types report parameters like integer, date time etc.,
Can you please suggest me how to resolve this.
Regards
Abhinay
|
Use this code in parameter. Here the parameter is iteration and in SQL query I have T1.ITERATION_NAME LIKE ?
if(params["Iteration"].value == '%'){
params["Iteration"].value;
}
else{
var str = params["Iteration"].value;
str = str.toString();
str = str.replace(/["']/g, "");
str;
}
|
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.