JSquire

@ baggypants - thanks for the link, very helpful @ giulio - list component is great. means I dont have to do a sub-report for minor reasons anymore, brilliant!!!

application classpath - the ireport classpath is not in the jrxml and wont be in the compiled .jasper binary.

Are you using a hostname or IP address? if using a hostname check to see if you can resolve the name to an IP using nslookup or digg. otherwise try using the actual dbhost IP address. If it is a remote host you could have any number of issues like firewalls etc so check if you can connect to the db from your local machine e.g. from the command line run 'telnet [dbhostname or IP] [dbport]'. You should get something like this: Trying 127.0.0.1... Connected to localhost. Escape character is '^]' That would indicate network access is available.

is this a report you developed yourself? check the fields in the report are large enough to hold the data (height & length) - maybe set Stretch with overflow property on the field? to test try static text and see if you get the same result or try a sample report from the JasperReports project.

write a scriptlet to check the length of the data for the field then pad it with the difference to make up the length you need.

syntax looks fine. double check you have the correct ports & database defined & that the user id & password are correct.

so your file locations should then be in your classpath in which case just remove $P{BaseDir} so the expression class should be string and value="mysubreport.jasper" if you dont specify the location jasper will look in the same location as the parent report and if not found it will then search your class path.

try a CASE statement in the order by clause of your query - this is dependant on the database and version of SQL. just google 'SQL CASE statement' for examples

your statement looked correct to me so i checked with the java guru in our office .... he agrees it is correct so it's most likely that the value of $V{SUM_NET_ORDER_BY_MO_GRP7} is not actually zero. Can also try: ($V{SUM_NET_ORDER_BY_MO_GRP7}.intValue() > 0 ? ($F{NET_ORDER_N_7}/ $V{SUM_NET_ORDER_BY_MO_GRP7}) : " " )

I am also on OSX 10.5.8 and 3.5.3 palette works fine for me.

have not tried displaying Japanese myself but suggest you take a look at the PDF encoding properties

there are some samples under the jasperreports project: http://jasperforge.org/website/jasperreportswebsite/trunk/samples.html?group_id=252 re casting - an int is not the same as an Integer and you have to ensure the data types from the database matches the java data types (or Expression Class property) you set on the fields in the report. If you get an int from the database but try to insert the data into an Integer type field you will get a class cast exception.

Try running the query directly against the database (independantly of iReport) - you should be able to do this with most SQL query tools. Hopefully this way you will get a diffferent error message that will pinpoint the issue.

suggest a double check of the parameters you pass through to the subreport.

Just a thought but I dont have time to test this - try a combination of PrintWhenExpression & Remove line when blank.

sorry - been off the radar a while. Presume you have resolved this by now but just for other users ...... ensure you have defined the parameters feeding into the crosstab correctly.

Hi, iReport newbie and would appreciate any assistance. I am trying to fill a crosstab in my subreport summary band using a subdataset (query to mysql - default datasource). The subreport has parameters that I use in my subdataset query. In the crosstab properties I have: - selected "Use a dataset ....." - selected the subdataset I want from the drop down in the datasetrun. - defined the subreport parameters as input to the subdataset (with no default value) - used $P{REPORT_CONNECTION} connection expression to use the subreport data source. The report compiles and runs but the crosstab does not return any data and no errors. The query itself is fine cause I can run it as the report query (same input parms) instead of a subdataset and I get the data I want. Where am I going wrong? Do I need to define a separate datasource for the subdataset? Tried a few options but cant get the syntax right - can someone please post an example data source expression and how to configure it? Thanks in advance.