[List Component]

@ 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!!!

[Unable to locate the subreport with expression]

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

[Connection Error:]

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.

 

[No field values in JasperViewer]

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.

[How to add a dotted line in a text field]

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.

[Connection Error:]

syntax looks fine.

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

[Unable to locate the subreport with expression]

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.

[setting query for subreport at runtime]

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

 

[Could you correct me for this condition.]

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}) : " " )

[Palette window in iReport 3.5.2]

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

[japanese char not displaying in jasper report pdf]

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

[very common question about data acquisition]

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.

[Error generating a report of a BD hosted on a serv]

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.

[Subreport not working]

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

[Page Break Pixel Paging Problem]

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

[crosstab subdataset not returning data]

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.

[crosstab subdataset not returning data]

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.