leniviy

Hey jasper community! "tick label expression" how?

Is there any new info on this? We're still on jasperserver 3.5.1, but if newer versions have SOAP interface for users/roles, then we could migrate. > The export APIs are there. Have a look at the unit tests to see how they can be used. I don't like this API. It requires database connection instead of http. However, another test (HttpUnitCreateRoleTest) looks promising.

Hi. I need to put a single header cell above my crosstab. The cell width must be the same as the table width. I tried to place it in main report and into first column group header, but no luck. Please see attachment. http://jasperforge.org/uploads/forum/101/91826/untitled.png Post Edited by leniviy at 09/14/2011 14:59

Do you use views on the SQL Server that refer to remote servers? Do you run ireport on the same machine as jasperserver?

Hi. I'm trying to construct a line or time series chart from a table with some statistics. I ran into several troubles. Time Axis Tick Label Mask: no way to insert '\n' between date and time to display it in 2 lines: 2010-10-06 18:30 Time Axis Tick Interval: there's no such property, the default is 1 day, I need 1 hour My table doesn't have data for each hour, and I expected this to be treated as zero value and to draw a hole in the chart, but instead the line simply connects 2 distant peaks. I'm using jasperserver 3.5.1 and can't upgrade because of the requirements

I found 2 ways to do this. If I want the chart to have only 1 bar for the current row, I create a group "rownumgroup" with expression: $V{REPORT_COUNT} . Then in chart data set "Reset Type" to "Group" and "Reset group" to "rownumgroup". To make the value axis not visible I have to use the customizer. Another way is to restrict number of lines per page To have 3 results per page add group rowsperpage with expression: new Integer( (int) ( ($V{REPORT_COUNT}.intValue()-1) / 3 ) ) and mark it to start new group on a new page. In this case the chart has to be placed in the page header band, not details band. A customizer is still needed to call the renderer setMaximumBarWidth(), or the last page will contain very thick bars.

I need to have a separate meter chart for each row. Data set has 10 rows Report has 3 columns I create group "rownumgroup" with group expression $V{REPORT_COUNT} put meter chart to Detail band. in chart data set "Reset Type" to "Group" and "Reset group" to "rownumgroup"If "print order" is "vertical", all 3 columns are filled: a e ib f jc gd h but if I change it to "Horizontal", only 2 columns are filled: a bc de fg hi j If I make the group expression empty, the elements are ordered correctly, but without the group they all have wrong value: j j jj j jj j jj

I need a horizontal bar chart having fixed width bars and multiple pages. Looks like I need to place the chart onto the detail band so its duplicated for each row, but how do I make it render only 1 bar for the current row? CATEGORY ACTIVE_NUMBER TOTAL_COUNT-------- ------------- -----------a 100 1000b 200 1000c 300 1000d 400 1000e 500 1000 This should give 5 separate charts having 1 bar http://jasperforge.org/uploads/forum/101/77386/chart.png Post Edited by leniviy at 08/03/2010 06:25 Post Edited by leniviy at 08/03/2010 11:10

I create empty report and set "When no data type" to "all sections". place a text field set the field expression: (new Object() { public String foo() { return "zzz"; } }).foo() try to rungetting error: Error filling print... java.lang.NoClassDefFoundError: report32name_1280391826111_320068 (wrong name: report32name_1280391826111_320068$3) nulljava.lang.NoClassDefFoundError: report32name_1280391826111_320068 (wrong name: report32name_1280391826111_320068$3) at java.lang.ClassLoader.defineClass1(Native Method) ... Why this happens? I entered a valid java expression.

People often advise to use 'calculated parameters' where their default value expression refers to other parameters. But in jasperserver when I open a report and change the value of initial parameter in "report options" , the calculated param isn't changed. For example: I have report parameter 'city' of type String and corresponding input control. 'city' can be null or any string value. I created another parameter 'city_sql' , default value now is just $P{city} . I planned an expression to convert string to SQL constant and then use it as filter in my query: where ( $P!{city_sql} is null or $P!{city_sql} = table1.city ) But when query runs, city_sql is alvays null. I wanted to use variables instead of parameters, but discovered that '$V{}' isn't expanded inside queries. How to workaround this?

Hi. I'm using jasperserver-pro-3.5.1 evaluation on windows. Someone created and exported a query and I imported it. After importing the related report was broken because the query turned into 1 line and ' -- ' comment was in the middle of it, hiding the rest of the query. Does anyone know whether it's a bug or feature or even fixed in later versions? Here's the file saved by js-export. Note the '--' comment and ' 's Code:<?xml version="1.0" encoding="UTF-8"?><query> <folder>/organizations/organization_1/reports/Common</folder> <name>testquery</name> <version>1</version> <label>test query</label> <description></description> <creationDate>2010-07-02T14:20:25.000+04:00</creationDate> <language>sql</language> <queryString>select max(a) as maxa, b from ( select 1 as a , 1 as b from dual union select 2 as a , 1 as b from dual ) t1 -- some comment group by b </queryString> <dataSource> <uri>/organizations/organization_1/datasources/test-ds</uri> </dataSource></query>