mulcamd

Hi George, Again a very helpful advice!. It works! General question: how would to design a report with 4 sub reports. Should I make for each sub report a group or put the second and the other sub reports all in the summary with page breaks in between?

Hi George and other forum members, There is a difference between what I want and what I get. Ofcourse, this happens ofter in life, but perhaps this issue can be solved. What I want: Two reports in one output behind each other, each report closing with the totals. Titel Headers_1 ------------------------- report 1 ----------------------- ------------------------ total <new page> headers_2 ------------------------- report 2 ----------------------- ------------------------ total What I did, see attachment Master report Titel Page Column FirstGroup Group Header Here I added my first sub report SecondGoup Group Header Here I added my second sub report I checked the "Start on a new page" checkbox Detail Empty and height : 0 SecondGroup Group Footer 2 With a total field SecondGroup Group Footer 2 With a total field Column Footer etc What I get is: Titel ---------------------First subreport ------------------------------------------ ---------------------------------------- ---------------------Second subreport ------------------------------------------ ---------------------------------------- Total footer 2 Total footer 1 So 2 problems: I get no page break between sub report 1 and 2 Both totals only are printed at the end of the report and I would expect different It is a very basic report. The master report I added as a attachment. It is very small. It acts only as a container. Post Edited by mulcamd at 05/09/2011 15:30 Post Edited by mulcamd at 05/09/2011 15:35

Wow it works. I was puzzled how this works. Am I correct that the trick is: Field value -> Variable_A -> Variable_B. This works variable_b has the previous value. One would think that: Field value -> Variable_A -> Variable_B is the same as Field value -> Variable_A, Field value -> Variable_B. But then Variable_A en Variable_B have the same value.

Hi, I know this topic has been asked before and I have read the answers. Yet I do not get it right. I have a master report with 2 sub reports. What I learned from the responses in the forum is that I have to create for each sub report a new group. In the group header I placed the sub report. Of the second group header properties I checked the box "Start on a new page". Question: Although I checked this box, the 2e group with the sub report is not printed on a new page. Why is this? Should I still make a new group for each sub report in iReport 4.x or are there other ways to have each sub reports printed on a new page?I'm using iReport 4.0.2.

Dear Kolaitis, Wow, this is great! Thank you very much!!!!! I'm going to try tomorrow. Let you know!

I'm printing a report. Each record has a timevalue. When the time between 2 records is greater than 5 seconds, I want to make the fields bold and red, see example. How can I accomplish this. I have read about the conditional style, but do not know how to set the condition in this case. I bought the iReport Ultimate Guide, but this specific situation is not captured. Also I read about Scriplets, but if possible, I would not use them because the difficulty. Is there a more easy way? I read Please help. Number Time 100 00:00:00 200 00:00:01 300 00:00:03 400 00:00:05 500 00:00:15 600 00:00:18 700 00:00:20 I searched the forum and found and tried the quote below, but could not get the right results: codyjasperForge Wrote: You could create a variable that contains the value of $F{f1} -previous. Have the RESET TYPE set to Group -> Group that has group expression of $F{f1} Change the evaluation time of the textfield that contains the variable, and then use the print when expression on the textfield. Variable Name: previousValue Class: (Same as $F{f1}) Reset Type: Group -> (Group Expression is $F{f1}) Calc Type: None Initial expression: $F{f1} Variable expression: $F{f1} This or something similar to it should work... Hope it helps... Post Edited by mulcamd at 05/04/2011 08:08

Hi, Answering my own question, I discoverd that my SQL query had already the wrong sorting. I could solve this by changing my SQL query to give the first value and with the "Catagory expression" adding the " - xxx". This works fine. Problem solved.

I have made a Bar3D. This functions well, except that the labels on the Catagory Axis are strings, 5-10, 10-15, 15-20 20-25 ... 100-105 etc, I have these in the right order in the SQL statement. However on the axis the values are sorted as strings to the order is changed. 100-105 then 10-15, 15-20, .. 5-10. Question: is there a way to have JasperReports not sorting the Catagory labels, but just to put them in the order of the SQL query.

Hi, I solved the problem, but I do not know what is the difference. I removed the field and run the report and then added it again. Then it was fine.

Hi, I solved the problem, but I do not know what is the difference. I removed the field and run the report and then added it again. Then it was fine.

I have made a report with iReport, first without an Input control. In my query I have Country, Region City, aantal (dutch for count) I have a group on Country, Region I used the Report Wizard on iReport and used the template Coffee. Running this report from both iReport and JasperServer is ok. No errors. Then I added an Input control for Region named "Region" with ID: RegionId and Name: Region I have made a parameter called: RegionId and type "java.lang.Integer", but added it not yet to the query. The report runs fine,both from iReport and JasperServer. No errors. Then I add the parameter to the query in the Where clause WHERE RegionId = $P{RegionId} Then the following error occurs, see below. Questions: What is wrong with $F{Aantal} . Without the Input control this field in the detail section gives no problem. How should I solve this problem?Code:1 - Error evaluating expression : Source text : $F{Aantal} java.lang.Exception: 1 - Error evaluating expression : Source text : $F{Aantal} at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

I have made a report with iReport, first without an Input control. In my query I have Country, Region City, aantal (dutch for count) I have a group on Country, Region I used the Report Wizard on iReport and used the template Coffee. Running this report from both iReport and JasperServer is ok. No errors. Then I added an Input control for Region named "Region" with ID: RegionId and Name: Region I have made a parameter called: RegionId and type "java.lang.Integer", but added it not yet to the query. The report runs fine,both from iReport and JasperServer. No errors. Then I add the parameter to the query in the Where clause WHERE RegionId = $P{RegionId} Then the following error occurs, see below. Questions: What is wrong with $F{Aantal} . Without the Input control this field in the detail section gives no problem. How should I solve this problem? Code:1 - Error evaluating expression : Source text : $F{Aantal} java.lang.Exception: 1 - Error evaluating expression :     Source text : $F{Aantal} at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Â

Perhaps I can describe what I'm looking for with the example of "Microsoft Word" and "Microsoft Word Viewer". "Word Viewer lets you view and print Microsoft Word documents on a computer that does not have Microsoft Word installed." This is what I'm looking for, a standalone program people on Windows and Mac can install and where they can open an already made iReport report. So the end users only have to download the "iReport viewer" and the report file. What is my situation. I have a standalone computer program which uses a SQLIte database. For this program I have made reports with iReport. This works very well. Now I want other users of this program to also be able to run these reports. The only thing they should do is at the first time is: install the SQLite JDBC driver. Select the SQLite dabaseAfter that they only have to open a report run it. iReport works already that way. When I open iReport, it shows me my available reports. Actually a clone of the iReport program without the design functionality is what I'm looking for. The end users I have in mind are not techniciens, so installing webservices, configurating them is far beyond their knowledge. Is there such a standalone iReport viewer? If no, could a stripped down version of iReport be made as iReport viewer?