[Ireport extra vertical white space]

Thank you for help. This is a detail band with height 15, 2 text items with height 15.

Font is SansSerif. I'd like to have a fontsize the same as the text item height, in this case 15 (event 14 will do).

Only when I set the font size to 11, I can see my data, when it is larger than 11, there is nothing shown. 

I did not set any padding on my text items and still there is too much of white space between the lines.  

I'd like to put a negative line spacing in the detail band to remove this white space.

I solved this problem today by finding a few other fonts where this 2 numbers can be the same: text box height and the font size.

But I still would like to be more flexible with what and where I put on my report, to have it 'pixel perfect'.

In the second file I put 2 sets of text items in summary band overlapped and there is much less of vertical white space in the second example.

[Ireport extra vertical white space]

When I need to decrease vertical white space between 2 text fields, I put one on the top of the second one partually and it works perfectly ok, when 2 fields are in the same band.

How do I remove extra white space in Detail band? I tried to play with line spacing and it does not do it. It seems I can not go less than one pixel .

I'd like to have what is called 'Negative leading'.

Where to look for examples of custom text measurer?

How to make the text field size the same as the font size?

 

[How to calculate a length of text field in scriptlet]

I am looking for a scriptlet example to know overflow of a text field.

I'd like to pass a font, font size and a string from a text field and find out if the string does not fit to the length of the textfield.

If yes, I am going to show a box with a smaller font size, if no, a box with a default font size.

Ideally, it should be something like 'fit to the box', providing a size of the box and textfield.

In this solution, the font size is not changing, just horizontal character spacing is changing

[ireport - subreport is working with one report, runtime error in another]

 The same subreport is in a few reports in Title band to get a description of the parameter from db.

Works perfectly ok in 2 reports, in the third is giving run time error.

The only difference withe the others - the third one has another component - list in the summary band  with dataset (the same database and different table)

One of the working one has a few different subreports working with no problem

Any idea why it can be? Track is subreport name.

Can it be data connection in subreport and list component somehow a problem?

Thanks.

Filling report...  Locale: English (United States)  Time zone: Default Error filling print... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Track
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Track 
    at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:786) 
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331) 
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:379) 
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:353) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:346) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:280) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Track 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:655) 
    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) 
    at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 
    at java.lang.Thread.run(Unknown Source) 
Caused by: java.sql.SQLException: No MST is currently in progress, cannot declare another cursor. 
    at com.ingres.gcf.util.SqlExType.getSqlEx(SqlExType.java:112) 
    at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:96) 
    at com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:852) 
    at com.ingres.gcf.jdbc.JdbcStmt.readError(JdbcStmt.java:2814) 
    at com.ingres.gcf.jdbc.DrvObj.readResults(DrvObj.java:636) 
    at com.ingres.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2711) 
    at com.ingres.gcf.jdbc.JdbcStmt.readResults(JdbcStmt.java:2662) 
    at com.ingres.gcf.jdbc.JdbcPrep.exec(JdbcPrep.java:1227) 
    at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(JdbcPrep.java:584) 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) 
    ... 11 more 
Print not filled. Try to use an EmptyDataSource...