incirlikhodja

Thanks! That was the issue. The default had been set to a value. I cleared the value and all is well now.

When I attempt to compile my main report, the compiler fails saying that it cannot find my subreport. I receive the following error message: <see the message in the Code area> Code:  Compiling to file... C:\Documents and Settings\jerry_dunn\My Documents\My Projects\Subversion_Repository\Redesign\icps\icps-web\src\web\WEB-INF\reports\pt\DD592SummaryReport\DD592SummaryReport.jasper  Compiling subreports....  Unable to locate the subreport with expression: "$P{SUBREPORT_DIR} + "Garnishments01.jasper"".java.lang.Exception: C:\ICPS\src\icps-web\icps-web\src\web\WEB-INF\reports\pt\DD592SummaryReportGarnishments01.jrxml not found.     at com.jaspersoft.ireport.designer.utils.Misc.locateFileFromExpression(Misc.java:1373)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.compileSubreports(IReportCompiler.java:1403)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:508)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Compilation running time: 2,328!

I have numeric and text values on a report that were produced by a scriptlet. In the report specification file (i.e. the jrxml file), I have applied bold face formatting. However, when the report renders, my values are not bold faced even though I have indicated to do so. This is nonconditional formatting. So this bold face formatting should take place. Any explanation for why jasper behaves in this manner for report values that were produced via scriptlets?

Portugese text "Bonus de Língua" incorrectly appears as "Bonus de LÃngua". Special characters appear incorrecltly sporadically. There appears to be no rhyme or reason. What are the possible causes?

I need to use a parameter of Collection type in the SQL of a report. I need to loop through the Collection items in the SQL. Can anyone provide sample code of how to do that? Thanks so much!

I have two variables in the No Data Band. When I test for no data, the No Data Band appears as it should; however, the variables in the No Data Band do not appear. Both variables use scriptlets. One variable, takes today's date, passes it to a scriplet which renders the date in the Portugese language. The other variable takes one of the input parameters and prints it with some text. Both variables use scriptlets. Do scriptlets not execute when the No Data Band is encountered? I have tried different evaluation times: report, page, auto. Nothing seems to work. Please advise.

I have a report containing a summary. The summary ejects to a new page and contains the page header in it. The page header contains a variable called OrgHeader that contains on of two possible values. "Organization: " + $F{org_name_tx}" OR Organization: " + "Summary" In order to assing the variable the value of "Organization: Summary", I have to somehow detect or know that I am on the last page of the report. Is there a parameter or system variable or some means of user defined variable that I can use to detect the last page?

I figured it out! On the properties of the report at the root level there are properties "Summary on Page" and "Summary with Page Header". Now...the only thing remaining is to figure out how to determine within a variable that I am on the summary or the last page of the report. I need to evaluate that and then set the header variable to say "Summary" Instead of Organization. Evaluating the field organization is not helping since it never seems to evaluate as null even though it is null on the last (summary) page. Any insights here? Post Edited by incirlikhodja at 08/10/2010 18:59

I have a report in which I am ejecting pages on a group called "Organization" When I am at the end of the report, I would like to have a Summary page with a header. How do I eject to new page on the summary band, force the page header, and check within a variable that I am at the end of the report so that I can dynamically set a header to say "Summary" instead of "Organization? I tried inserting a page break in the summary band. However, that does not force a page header on the next page with it. Also, is there a system variable, value or property that I can check to see if I am at the end of a report? Please advise. cheers, Jerry

That worked! Thank you VERY much!! There was one more item I had to do. I had to set the object to grow with overflow as well because some subreports had to expand over several pages. It would be nice if in a future release they would allow subreports to have borders and padding like other objects. It would make it much easier. Anyway, Thanks again! GREATLY appreciated!

I have a detail band with a subreport in it. I need to surround it with a border, however when I right-click the subreport object on the main report, there is no option in the pop-up for "borders and padding". I have also looked for a border option in the properties of the subreport. This subreport will grow and shrink. So I need for the border surrounding the subreport to grow and shrink with the subreport. How do I accomplish this?

That worked GREAT! Thank you VERY much!

I have a fundamental misunderstanding of how the "No Data" Band is used or how it works. I have a main report with several subreports, all of which use the No Data Band to indicate that there are no rows of data. It simply contains a header and a message indicating that there are no records (i.e. the subreport is empty). If my SELECT statement in my query yields no data, I would expect the No Data Band to display its contents. Am I wrong to make this assumption? Is there something I need to toggle or switch on or do in addition? Please advise. Currently nothing displays when there is no data, not the No Data Band, not anything.

I need the ability to do a running total on a column in both the header and the footer of a page. The header total must show the total of the column prior to the current page's transactions have been summed and the footer must show the total after the current page's transactions have been summed. For example, the first page should display zeroes in the header total because nothing has been added yet; while the first page footer should display the totals of the first page's transactions. In the same example, the second page's header should display the same number as the first page's footer because the second page's transactions have not been added yet. However, the second page's footer should display a total that reflect's the first page's footer total PLUS the transactions on the second page. It's a running total. How do I perform that in iReports?

I would like to use the COUNT function in Jasper Reports and need to know how to use it as I am getting an error. I have a string Field called bdg_id that I would like to count in a group Pay_Blck. I created a variable, changed the expression to bdg_id (which is string), indicated that I wish to COUNT on GROUP Pay_Blck. I have made the variable a type integer. I get an error which states "Cannot cast object 'B749' with 'class.java.string' to 'class.java.integer' I am not trying to cast the string to an integer. I merely want to count a field that is of string type called bdg_id in a group Pay_Blck and return an integer value of the Count. How do I do that?

Are there statements available in Jasper Reports that allow for aggregate functions such as SUM, AVG, etc? For example, something similar to the code shown. I would like to be able to create a variable that performs a SUM first on Field such as NECR_REPORT.TOTAL where the GROUP BY is on NECR_REPORT.PAY_BLCK_ID and I want to do this before performing a division by 100. I prefer to do this all in one variable rather than creating a separate variable to do the sum. I also prefer to not do this in the SQL if possible. Does Jasper Reports allow this? If so, what is the statement name and how do I use it? Thanks so much! Code:Sum ({NECR_REPORT.TOTAL}, {NECR_REPORT.PAY_BLCK_ID})/100

1. Making the parameter syntax change helped. 2. An example of what I am trying to do: Let's suppose that I have a variable called cnvtsumtotal that had some long complicated java code to compute it and I resorted to calling a scriptlet that contained that code. THEN I wanted to filter the rowset...comparable to a WHERE $V{cnvtsumtotal} > 0. I realize that I cannot do this in the SQL, correct? I was wondering if there was someplace else in the Jasper report where I could do this subsequent filter on the row set.

I have two questions 1. I am trying to use a parameter of a Jasper report in the following manner ($P{TimeKeeper} = 'ALL' OR tk.tk_id = $P{TimeKeeper} The parameter $P{TimeKeeper} is defined as a type String. However, this statement gets a syntax error on the part $P{TimeKeeper} = 'ALL' Saying that 'ALL' is a VARCHAR and that $P{TimeKeeper} is bit. Is this not allowed?? 2. I have a Jasper Report variable that I would like to use to further filter my result set in the query. The variable has a rather lengthy calculation that involved a call to a scriptlet. However, I would still like to use the variable to further filter in my query. Can this be done? Post Edited by incirlikhodja at 05/20/2010 20:33 Post Edited by incirlikhodja at 08/10/2010 19:20

I am trying to mimic a Crystal Report that uses the WhileReadingRecords statement in one of its formulas (i.e. variables). WhileReadingRecords forces the report generator to evaluate the formula while it is reading the database record data. Formulas are normally evaluated during the following times: - before the report generator reads database records. Similarly, Crystal reports has a statement called WhilePrintingRecords as well. Does JasperReports provide something similar? If so, please provide a sample of code as to how it is used. Thanks so much!

How do you split bands in iReports? I have a group band upon which I would like to split into 2-3 sections. How do I do that? THe user guide and the Definitive Guide both make mention of splitting bands, but never get around to explaining how to split bands. Also, the Wiki link in one of the other threads explaining how to split bands no longer exists. Please advise.