binmaker

Hi, everyone. Let me show you a example for your understanding. A report what I like to make has a page header, a detail, a page footer. I'm gonna place a title and student information, such as a name, an address, an age and so on, on a page header. I'll also place lecture list that the student is taking on a detail band. Finally I'll place school information on a page footer band. For this report, I've got to use three queries. The first one is for student information and second query is for lecture list and the last is for school information. The first problem is I have to use two database servers, It means I have to use two connection information. I aleady tried to use a sub report for school information. From what I know, I've got to pass connection information from a master report to a sub report if a sub report doesn't use same connection with a master report. But I couldn't solve connection expression problem, because I don't know how to set a connection expression of a sub report. The last thing what I want to know is related with a sub dataset. In this sample, I used a sub dataset for student information. Before I know about a sub dataset, I used a sub report. But after knowing about that, I wanted to use a sub dataset. But when I used that, the report gave me some errors. The errors said there wasn't speicified fields. And I also have another question about a sub dataset, that is how I can make a relation between a parameter of master report and a parameter of sub dataset. If you might know the answer to above questions, let me know, please. Thanks in advance. P.S. iReport 3.7

Hi, friends. Now I have to make a roll book with the iReport 3.7 As you may know, there are date list horizontally and student name list vertically. To make this, I placed a text field element in a detail band, of course it is for student names. And I made a subreport for date list and placed it in a page header band.of a master report. This subreport has only one detail band and heights of other bands are 0, and this subreport has 17 columns. Actually, I'm not sure it is right or not, because I don't know how to put data horizontally. Fortunately, It did work well when this subreport worked as a master report. But I placed this in master report as a subreport, it throw an exception. Error message is below.. Error filling print... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new java.lang.Integer(1) net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new java.lang.Integer(1) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:659) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:327) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:402) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:361) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:422) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:385) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:246) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:59) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:858) 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.fill.JRExpressionEvalException: Error evaluating expression : Source text : new java.lang.Integer(1) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:253) at net.sf.jasperreports.engine.fill.JRCalculator.evaluateEstimated(JRCalculator.java:561) at net.sf.jasperreports.engine.fill.JRCalculator.estimateVariables(JRCalculator.java:165) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:784) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1448) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:108) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:557) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.RuntimeException: No Context associated with current Thread at org.mozilla.javascript.Context.getContext(Context.java:2206) at org.mozilla.javascript.SecurityController.createLoader(SecurityController.java:136) at org.mozilla.javascript.optimizer.Codegen.defineClass(Codegen.java:143) at org.mozilla.javascript.optimizer.Codegen.createScriptObject(Codegen.java:102) at org.mozilla.javascript.Context.compileImpl(Context.java:2293) at org.mozilla.javascript.Context.compileString(Context.java:1240) at org.mozilla.javascript.Context.compileString(Context.java:1229) at net.sf.jasperreports.compilers.JavaScriptEvaluator.getCompiledExpression(JavaScriptEvaluator.java:315) at net.sf.jasperreports.compilers.JavaScriptEvaluator.evaluateExpression(JavaScriptEvaluator.java:294) at net.sf.jasperreports.compilers.JavaScriptEvaluator.evaluateEstimated(JavaScriptEvaluator.java:276) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:242) ... 11 more Print not filled. Try to use an EmptyDataSource... This is one of my questions. Another question is filling a detail band with blank box when there is not enough data. Blank box means text field element with out any data What I mean is......This roll book can contain 20 students names but somethimes, there are 15 students or 7 students and so on. In this case, there is totally white area between 15th student name and page footer band. It is not what I want. There are two image files attached. If you see these images you can understand what I mean. rollbook1.gif is what I want. Thank you. Post Edited by binmaker at 12/22/2009 02:12 Post Edited by binmaker at 12/22/2009 02:14

Hi, jmurray. I don't know how to thank you. Thanks to you I can solve all problem. Thank you so much again.

Hi. I have two things to do and I think I've got to use scriptlet. But I don't know how to use scriptlets in iReport. One of both, I have to print a row count every row in a detail band. For this, I made a variable and placed it in a detail band. To count this variable, I think I have to use scriptlet. Is it right? Another thing I have to do is controlling a line height. I placed a line element in detail band to indicate a bottom of a row and I'd like to change a height of the line every 5 rows. Please, let me know how to use scriptlets. Thank you.