aniri.g

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.

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?

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

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...