[Conditional Styles in the line 1, the second field]

What reason do you have for that cell being red? is the value wrong or is it always going to be that square which is red?

[Dinamically colored cells in a table using Jasper]

You either want "conditional styles" or use a "Print when" expression. Neither of which I've used but both are mentioned with a fair frequency on this forum.

[Pie Chart sorting not working in 3.5.2?]

One last comment. If the bug is not present in jasper 3.1.4 but does occur in 3.5.x then it's unlikely to be a jfree chart bug. it may be worth reporting it in the jasperreports section of the tracker.

[How to get an Input parameter in UK date format?]

Click on Tracker link above then on Report Issue

[Pie Chart sorting not working in 3.5.2?]

I realise you don't use 3.5.3 for other issues but Oval pie charts work fine for me in iReport 3.5.3

I put a bug in jasperreport as I assumed it was the compiler not reading the values right, not the jfreechart element

Link to (closed) bug http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4118

Post Edited by baggypants at 08/14/2009 09:09

[2x2]

In the report properties (i.e. in the the report inspector, click on the top element and look in the properties windows) you can set the number of columns. Then you could make the detail band (or whatever band your using) half  the height of the page (less the height of any other elemets) .

Post Edited by baggypants at 08/14/2009 08:57

[How to get an Input parameter in UK date format?]

I think your absolutly right!

It's never been a big issue for me though as my users access the report through jasperserver which takes the date input format from windows.  Pop a feature request in the tracker though and it'll get my vote.

[iReport 3.5.2 band issue]

Probably by using the crosstab component.

Post Edited by baggypants at 08/10/2009 13:54

[Q/Q - What happened to Jasper Intelligence (repo)?]

if you just want scheduled reports then it's in Jasperserver.

Startig from your screenshot, tick the box next to the report. The button with the paper and the little clock will become available. Click on that and follow the prompts.

[iReport 3.5.3 released!]

glees

[Adding JRXML file name to report]

I don't know about the jrxml file name, but I use the Report name by creating a variable with the variable expression

$P{JASPER_REPORT}.getName()

This only works with JasperReports 3.5.0 and above

[Customising Meter Chart Meter Intervals Text]

Thanks Giuilo

 

I've avoided using chart customizers so far. I've not looked into them. I'm not using a theme with them so it's still an option. but customizers seem a bit hardcore Java to me. I'll chuck it in the iReport tracker as a feature request.

[Customising Meter Chart Meter Intervals Text]

I recognise that as the eye.candy.sixties theme when the meter is set to Dial. I'm aware of the theme selector. It's not quite what I'm looking for. The example you've posted has no "meter intervals" set either.

Thank you for taking the time to reply though. I appreciate every effort,

To Clarify. In the attached file I have a series of meters with two meter intervals. One at 157.42 to 163.25 and another at 174.91 to 174.91. I can change the size of the numbers with Tick Lable Font but I cant' change the colour. Or specify their complete removal.

[JRXML file works in ireport but not server]

Saving as eariler versions in 3.5.2 does seem to remove group footers.

See here

http://jasperforge.org/projects/ireport/tracker/view.php?id=4021

Multiple detail bands only came in with 3.5.2 so saving as eariler versions will strip them out.

What I do is use iReport 3.5.0 to do reports for Server 3.5.0. As I've got a few servers to look after and I don't do minor point upgrades if I can help it.

 

Otherwise you have to install the jasper 3.5.2 jar files into jasperserver

 

in apache-tomcat\webapps\jasperserver\WEB-INF\lib

 

put in jasperreports-3.5.2.jar, jasperreports-cahrt-themes-3.5.2.jar

 

you may need to copy across jasperreports-ofc-component and jfreechart if they are later versions.

I've not tried it so it may explode and kill your family, but it's worked before with earlier versions.

Post Edited by baggypants at 07/17/2009 12:35

[How to bold an Image]

You mean like putting a border round it?

[Setting Max and Min Values for Meter Chart.]

Change the Tick Inteval Propery to the inteval you want

[Setting Max and Min Values for Meter Chart.]

Set the Data Range Low and High Expression in the Meter Chart Properties. to something like

new BigDecimal(<yournumberhere>)

[Variable Expression and MATH ( NEED HELP PLEASE)]

What is AREADOC type initially, Change the new BigDecimal() to match that.

 

e.g. if AREADOC is an integer you can get away with new Integer(1000)

 

($F{PROBCID}.equals("3") ? $F{AREADOC}.divide(new Integer(1000)) : "" )

[Variable Expression and MATH ( NEED HELP PLEASE)]

Either a) chnage your report to use Groovey or

 

b)

 

($F{PROBCID}.equals("3") ? $F{AREADOC}.divide(new BigDecimal(1000)) : "" )

[Customising Meter Chart Meter Intervals Text]

Anyone know how to change the font colour, size and style of the meter intervals on the meter chart? I've tried changing properties in the chart properties and also setting up a theme but I can't see how to do it. I end up with Black Ariel 10pt and thats it.

If not I'll add it as a feature request to the tracker.

[int to BigDecimal]

Try

 

($F{Period} != new BigDecimal(0))?value1:value2

 

I'm new at this Java thing so it may not work

[Dynamic Input control]

It's definately been discussed

 

Here

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=56899

They mention a custom jsp and how it may be difficult to pass a result to a query.

 

This thread tells you where to put a custom jsp

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=17600

There's not a lot of info on creating a custom jsp that I can find apart from this little nugget

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=35031

which mentions the provision of parameters passed to the jsp

 

[Line Not Displaying in HTML]

HTML rendering only shows the topmost element if you've got elements on top of each other. Check if something is overlapping

[how to compare current month data with last month]

I did this in SQL if your database supports OVER it.

In Oracle

SELECT
   month, SUM(amount) AS month_amount,
   SUM(SUM(amount)) OVER

  (ORDER BY month ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
    AS cumulative_amount

[ireport data source driver problem]

You were very nearly there!

 

If you add the sybase java driver to the classpath in the options screen then the Sybase option should then appear in black on the database connectors list you were looking at in step 1