joannem

Hello, Can anyone assist me with why I would be getting this error? I am using an xml file which does have data in it, however when I run the report I get th error "The document has no pages". Thanks in advance, Joanne Post Edited by joannem at 07/21/2009 20:28

Hello, I have dumped the database on the one system which contains jasperserver and would like to load it into jasperserver on a different system. I found the dump command no problems but am unsure how to use this dump file to load into msql on the other system. Any commands I see they are asking for the database name but I'd like to load the complete dump file. Any assistance would be greatly appreciate! Thanks in advance! Joanne

I've attempted and I continue to get casting errors. I've created the variable "$V{NUM_FORMAT}" and put in the initial value "new java.text.DecimalFormat("0.##")". I've tried setting the "Variable Class Type" to Double, String, java.text.DecimalFormat ..... My variable that I want to use this format in contains "( ($F{venprice} != null ) ? $F{venprice_label} + ": " + $V{NUM_FORMAT}.format($F{venprice}.doubleValue()):$F{venprice_label} + ": " + 0.00)" I continue to get errors like the following 1. When I have the Variable Class Type on NUM_FORMAT is set to java.text.DecimalFormat ...... "The method doubleValue() is undefined for the type DecimalFormat" OR 2. When I set the Variable Class Type on NUM_FORMAT to java.lang.Double ..... "Cannot cast from DecimalFormat to Double" as well as the one above "The method doubleValue() is undefined for the type DecimalFormat". So I'm assuming that I need to have the variable NUM_FORMAT set to java.text.DecimalFormat but then how do I correct the error regarding the method doubleValue() ? Thanks for your help!

Haven't had a chance to try the last post but going to attempt today!

I have tried using the NUM_FORMAT option but I get an error. What is the variable class type supposed to be set to for this variable? I left it as string not really thinking about it but then got an error "Cannot cast from Decimal Format to String". I've tried setting it as Double but then get the error only references Double instead of String. Sorry but java is not my strong point so any assistance would be greatly appreciated. Thanks!

Hello, I have a field in my template which contains a text field as well as a decimal field. Example: $F{venprice_label} + ": " + $F{venprice} - venprice_labe needs to be a string variable but venprice needs to be a 2 place decimal field. Can anyone tell me how to set this in the expression for my field. Thanks!

Hello, Is there any type of orphan control or keep together command that wil allow you to keep 2 bands together if hit the end of the page? For example I do not want to see a group header as the last thing on a page and the detail for that group header to be on the next page. There are 2 bands in this instance.. the group header and the detail. How do I keep this from happening? Thanks in advance!

Hello, I am having some difficulty in getting my report query set up so that I can access the data the way I want to. I am using an xml file and selecting Xpath for my Query Language. My xml file is in the following format <smartxml> <lang> <labels> </labels> </lang> <repdata> <invcd>1234</invcd> <whs>abc</whs> <uom>each</uom> <serlot> <lotcd>t12</lotcd> <onhand>20</onhand> </serlot> <serlot> <lotcd>t22</lotcd> <onhand>50</onhand> </serlot> </repdata> <repdata> <invcd>1234</invcd> <whs>zxy</whs> <uom>each</uom> <serlot> <lotcd>bb3</lotcd> <onhand>10</onhand> </serlot> </repdata> </smartxml> So if I put in the query /smartxml/repdata then I am able to get the following Invcd 1234 Whs UOM abc each Lot On Hand t12 20 Whs UOM zxy each Lot On Hand bb3 10 This is not correct because when there is more then one serlot tag within the repdata tags then I only get the first occurance. If I put the query to /smartxml/repdata/serlot I then get all occurances of the serlot within the repdata tags but I'm trying to group by Invcd and Whs and it disregards any grouping within the repdata tags. I really hope this makes sense to someone as I am not sure how to resolve getting what I see above but under the first occurance of the lot where there is t12 (lot) and 20 (onhand) there should also be t22 (lot) and 50 (onhand) Any assistance would be greatly appreciated!

Thank you for your help, it worked perfectly!

Thank you for the response. I am using my subreport to display the details of my report and the page numbering is set in my main report however I cannot get the page count to work. I'm trying to display Page X of Y. Any suggestions on how I do this?

Hello, I am using a subreport and want to use page numbering but if I put the page numbering in the main report that calls the sub report then on the first page I get 1 of 1 and the next page which is the detail of my report (subreport) is 2 of 0, then 3 of 0. Does anyone know how I can use page numbering on my report and make it work on both the main report and sub report? Thanks in advance!

Is there a way to check to see if a value of a variable that is performing a count is odd or even value? For example I have created a variable tranno_count. I have a coloured box that is sent to the back of my data and I want to say to print this box when the value of tranno_count is odd. This is so alternate lines are displayed with a coloured background. Does anyone know how/if I can refer to a variable value as being odd or even? Thanks in advance

Hello, I am trying to log into jasperserver as jasperadmin but I cannot remember what the password is. I thought for sure there was a file that contained the usernames and passwords. Can anyone assist me with this. Thanks in advance!

Thank you Scott for your assistance. I have purchased the iReport documentation, unfortunately I do not have it with me today. I will see what I can come up with from the information you gave me!

Hello, Can anyone assist me with Scriplets, what they are and how to use them. I am new to iReport and have been given the suggestion to use scriplets to solve one of my issues, however I'm not really sure what I do. Thanks in advance!

Hello, Does anyone know a way to set the format for a decimal field to have a certain number of decimal places based on a number in the data. For example, I have a field in my xml file called dec_places. The value in this field is what I need to use to set the number of decimals for the field formatting. Does anyone know how I go about doing this? Any assistance would be greatly appreciated. Thanks!

I have a report template showing inventory values. My data comes from an xml file. In the xml file it indicates the number of decimal places the inventory amounts are to be displayed with. Is there a way to dynamically set the format for these inventory amounts to display using the field indicating the # of decimal places to display? For example If my decimal point field in the xml file has a value of 2, then the inventory amount should be displayed as 100.00. If my decimal point field in the xml file has a value of 0, then the inventory amount should be displayed as 100. Any assistance with this would be greatly appreciated! Thanks in advance!

I found my problem. I am using sub reports and the page footer was set in the sub report which does not display on the bottom of each page on the main report. I had to set the page footer on the main report instead!

Hello, Does anyone know how to get the page footer band to always print at the bottom of the page? If the detail band finishes with the data in the middle of a page, the page footer band will print the foot information at this point. I would rather have that a page footer is always the footer (bottom of the page). Any suggestions would be greatly appreciated. Thanks in advance!

Hello, Is there a way to control the size of a band based on the data. For example I want to print my data in a band that only will take up at the most a 1/4 of the page. If it hits that limit I want a new page started. I am unable to figure out how to do this, does anyone have any suggestions?

Hello, I am trying to set up a template to print a cheque and need to be able to set the band sizes with a maximum and minimum band size (which would be the same). The cheque is made up of 3 areas. The top 2 areas will have the same information which contains the transactions that make up the cheque amount and the bottom part will be the actual cheque. I need each band to be a specific size. If I set the band size to 250 and put the data fields I want to print, I do not get the desired output. I need to be able print each record from the datasource that pertains to that cheque within the top 2 sections. There could be 20 records for the one cheque and as soon as the data were to hit the max size of 250 then I need to start a new page with this data continuing only in the top 2 portions of the cheque. If there were only 1 or 2 records that pertain to that cheque I would like those 2 records printed in that band but the band size to still fill with nothing to the max size of 250. I hope this makes sense and if anyone can help me here, it would be greatly appreciated. Thanks in advance!

Hello, When generating a pdf report to disk using web services, I get the following error.... ClientAbortException: java.net.SocketException: Broken pipe at org.apache.axis.AxisFault.makeFault(AxisFault.java:101) at org.apache.axis.attachments.AttachmentsImpl.writeContentToStream(AttachmentsImpl.java:512) at org.apache.axis.Message.writeTo(Message.java:545) at org.apache.axis.transport.http.AxisServlet.sendResponse(AxisServlet.java:902) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:777) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.JIPortletAuthenticationProcessingFilter.doFilter(JIPortletAuthenticationProcessingFilter.java:87) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: ClientAbortException: java.net.SocketException: Broken pipe at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:366) at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:353) at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:392) at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:381) at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:88) at org.apache.axis.attachments.DimeBodyPart.sendChunk(DimeBodyPart.java:381) at org.apache.axis.attachments.DimeBodyPart.send(DimeBodyPart.java:358) at org.apache.axis.attachments.DimeBodyPart.write(DimeBodyPart.java:233) at org.apache.axis.attachments.DimeMultiPart.write(DimeMultiPart.java:46) at org.apache.axis.attachments.AttachmentsImpl.writeContentToStream(AttachmentsImpl.java:511) ... 47 more Caused by: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:746) at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:433) at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:348) at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:769) at org.apache.coyote.http11.filters.IdentityOutputFilter.doWrite(IdentityOutputFilter.java:126) at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:579) at org.apache.coyote.Response.doWrite(Response.java:559) at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:361) ... 56 more Has anyone come across an issue like this that could help me out as I'm at a loss as to what is wrong. Thanks!

Hello, My report contains a band with 2 rows of fields in it. The first row is for qty and the second row is for $ amt. The user has the option to print qty and/or sales. My issue is that my first line is the qty and my second line is the sales. If I choose to not print the qty but print the sales the space in the band where the qty normally would have printed is blank and I cannot figure out how to set any shrink to fit option to remove that empty space that was allocated for the qty. Any suggestions would be greatly appreciated! Thanks in advance!

Hello, I have been creating variables in my template to use in my footer bands, but have been getting errors on some of them and not sure why. I have 4 footer bands for summarizing data based on my groupings. My first set of variables I created for my 1 footer band are hr_int4_1, hr_int4_2, hr_int4_3... hr_int4_6. Each of these has a similar expression such as .. (($F{s_interval}.equals("4"))? Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3]):($F{s_interval}.equals("6"))? Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3])+Integer.valueOf($V{vends}[4])+Integer.valueOf($V{vends}[5]):($F{s_interval}.equals("8"))?Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3])+Integer.valueOf($V{vends}[4])+Integer.valueOf($V{vends}[5])+Integer.valueOf($V{vends}[6])+Integer.valueOf($V{vends}[7]):($F{s_interval}.equals("12"))?Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3])+Integer.valueOf($V{vends}[4])+Integer.valueOf($V{vends}[5])+Integer.valueOf($V{vends}[6])+Integer.valueOf($V{vends}[7])+Integer.valueOf($V{vends}[8])+Integer.valueOf($V{vends}[9])+Integer.valueOf($V{vends}[10])+Integer.valueOf($V{vends}[11]):Integer.valueOf(0)) The only difference between the expressions in the variables are the array elements they reference. I copied the variables I created and pasted them giving them names hr_mach1, hr_mach2, hr_mach3.... hr_mach4. The expression in each of these variables is the same as the variables I copied them from the only thing I did was change the "Reset Group". I did the same copy, paste, rename, modify reset group... for another summary band, but for some of the variables (not all) I get the following error, Error filling print... java.lang.ClassFormatError: Invalid method Code length 67473 in class file grossrecloc_1205419199404_966304 null java.lang.ClassFormatError: Invalid method Code length 67473 in class file grossrecloc_1205419199404_966304 at java.lang.ClassLoader.defineClass1(Native Method) .... I'm not sure what is causing this error. If I remove the variable that is causing this error and put a new one in I don't get this error... it happens for some variables but not all. The expression hasn't changed from one group to the next, just the variable name and the reset group. Can anyone assist me with what may be causing this error? Thanks in advance!

Hello, I have been creating variables in my template to use in my footer bands, but have been getting errors on some of them and not sure why. I have 4 footer bands for summarizing data based on my groupings. My first set of variables I created for my 1 footer band are hr_int4_1, hr_int4_2, hr_int4_3... hr_int4_6. Each of these has a similar expression such as .. (($F{s_interval}.equals("4"))? Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3]):($F{s_interval}.equals("6"))? Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3])+Integer.valueOf($V{vends}[4])+Integer.valueOf($V{vends}[5]):($F{s_interval}.equals("8"))?Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3])+Integer.valueOf($V{vends}[4])+Integer.valueOf($V{vends}[5])+Integer.valueOf($V{vends}[6])+Integer.valueOf($V{vends}[7]):($F{s_interval}.equals("12"))?Integer.valueOf($V{vends}[0])+Integer.valueOf($V{vends}[1])+Integer.valueOf($V{vends}[2])+Integer.valueOf($V{vends}[3])+Integer.valueOf($V{vends}[4])+Integer.valueOf($V{vends}[5])+Integer.valueOf($V{vends}[6])+Integer.valueOf($V{vends}[7])+Integer.valueOf($V{vends}[8])+Integer.valueOf($V{vends}[9])+Integer.valueOf($V{vends}[10])+Integer.valueOf($V{vends}[11]):Integer.valueOf(0)) The only difference between the expressions in the variables are the array elements they reference. I copied the variables I created and pasted them giving them names hr_mach1, hr_mach2, hr_mach3.... hr_mach4. The expression in each of these variables is the same as the variables I copied them from the only thing I did was change the "Reset Group". I did the same copy, paste, rename, modify reset group... for another summary band, but for some of the variables (not all) I get the following error, Error filling print... java.lang.ClassFormatError: Invalid method Code length 67473 in class file grossrecloc_1205419199404_966304 null java.lang.ClassFormatError: Invalid method Code length 67473 in class file grossrecloc_1205419199404_966304 at java.lang.ClassLoader.defineClass1(Native Method) .... I'm not sure what is causing this error. If I remove the variable that is causing this error and put a new one in I don't get this error... it happens for some variables but not all. The expression hasn't changed from one group to the next, just the variable name and the reset group. Can anyone assist me with what may be causing this error? Thanks in advance!