| Parameters in Web Report Viewer are handled differently to those in the Report Designer. [message #110400] |
Tue, 17 January 2006 11:11 |
Eclipse User |
|
|
|
Originally posted by: andy.lawton.nospam.com
I have a report with parameters in it. One of those has a default value of %
.. It's used in a MySQL query as a wildcard. It's defined as a string,
default value "%" - note, with quotes.
Example: "select * from table where myitem=%". MyItem is a string.
In the report designer, when you run the report and press the Show Report
Parameters button, the value for this parameter is shown as %. There are no
quotes around this value.
In fact, there are no quotes at around any string parameters. The report
works as expected.
If you run the report in the web viewer, without putting any parameters on
the URL so the report takes the defaults, the report does not work as
expected. If you open the parameters window through the browser, you will
see that there are quotes around any string variable. If you remove these
quotes and then run the report, the report works as expected.
If you then run the report in the web viewer with all string parameters
provided, then the report works - there are no quotes around any of the
string parameters.
So it looks like if you provide the parameters for strings for the web
viewer, it does not add the quotes. If, however, you do not provide a
parameter and let the report take the defaults, then quotes will be added to
the parameters.
Is this the expected behaviour? I would expect the web viewer to behave like
the report designer?
If it isn't then anyone know how to pass % as a report parameter to the web
viewer? I'm using PHP
BTW, Tomcat5, BIRT 2.0RC1.
Andy
|
|
|
Powered by
FUDForum. Page generated in 0.02529 seconds
Home