bmccorkle

Hello, I currently have a report that works in IReport 5.1 . That has a java.util.Collection parameter assinged. That gives the user the ability to select multiple records to print at the same time. This report works great in Ireports, but I am having a problem writing the process that goes into Oracle Apex to work. In Apex I have an item that is a multi selection then I have another item that tranforms that into a comma separated list. example 632,658,569 Here is the Process I have written so far.. declare l_additional_parameters varchar2(32767); begin xlib_jasperreports.set_report_url ('http://jasper.XXXXX.net:####/JasperReportsIntegration/report'); l_additional_parameters := 'ID in (' || :p15_TEST || ')'; xlib_jasperreports.show_report (p_rep_name => 'Print_WrkTck', p_rep_format => xlib_jasperreports.c_rep_format_pdf, p_data_source => 'XXXXXXXXXXXXXXX', p_additional_params => l_additional_parameters); apex_application.g_unrecoverable_error := true; end;

Hello, I am tring to dynamically render 3 jpeg images into an Apex report using ireport and jasper. I am tring to dynamically create the file name. Here is what I have so far: I created the report and added the images to the report, created a parameter for each image. Now I need to be able to dynamically create the image name because I 25 jpeg images but I only want certain ones that match my varibles. Now under the parameter for the image in the expression I am tring to create example "big-blue.jpg" where big-blue is a varible. I have tried different ways like """ + $P{big-blue} + ".jpg" + """ This does not work for me. I really need the " around the file name.. Thanks in advance..

Hello Everyone, I am new to using jasper Ireport 5.1 with Oracle Apex. I have created a docuement that has 2 paraments and a jpeg Logo. In the designer everything works great. But in Apex, I can get the report to render through Apex without the Logo but when I try to run it with it I get File does not begin with '%PDF-' error. I have searched all over the web for a solution. I have setup in my report a paramenter with the direct link to the jpeg file and using it to render the image. I have no idea where to go from here. Thanks for any help with this matter..

I figured out the other issues. It is now wokind thanks alot...

Thanks for you help. I have 2 questions.. I have titles like Name: but it does not like the : Is there a way to show that? Now I deleted the Language="groovy" I am now getting these errors and it is still not wanting to render my parameter for some reason: Errors compiling T:Oracle BackupsMAXApexRCSTECH Jasper RptsTestPrint_wktckt_P15_ID.jasper!Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@1874d8e net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Syntax error on token "ID", delete this token value = Print ID; //$JR_EXPR_ID=8$ <> 2. Syntax error on token "No", delete this token value = Serial No; //$JR_EXPR_ID=10$ <> 3. Syntax error on token "for", . expected value = Paid for Insurance; //$JR_EXPR_ID=11$ <-> 4. Syntax error on token "ID", delete this token value = Loaner ID; //$JR_EXPR_ID=12$ <> 5. Syntax error on token "Date", delete this token value = Today's Date; //$JR_EXPR_ID=14$ <--> 6. Syntax error on token "ID", delete this token value = Student ID; //$JR_EXPR_ID=16$ <> 7. Syntax error on token "Loaner", delete this token value = Issued Loaner; //$JR_EXPR_ID=17$ <----> 8. Syntax error on token "SN", delete this token value = Loaner SN; //$JR_EXPR_ID=18$ <> 9. Syntax error on token "ID", delete this token value = Print ID; //$JR_EXPR_ID=8$ <> 10. Syntax error on token "No", delete this token value = Serial No; //$JR_EXPR_ID=10$ <> 11. Syntax error on token "for", . expected value = Paid for Insurance; //$JR_EXPR_ID=11$ <-> 12. Syntax error on token "ID", delete this token value = Loaner ID; //$JR_EXPR_ID=12$ <> 13. Syntax error on token "Date", delete this token value = Today's Date; //$JR_EXPR_ID=14$ <--> 14. Syntax error on token "ID", delete this token value = Student ID; //$JR_EXPR_ID=16$ <> 15. Syntax error on token "Loaner", delete this token value = Issued Loaner; //$JR_EXPR_ID=17$ <----> 16. Syntax error on token "SN", delete this token value = Loaner SN; //$JR_EXPR_ID=18$ <> 17. Syntax error on token "ID", delete this token value = Print ID; //$JR_EXPR_ID=8$ <> 18. Syntax error on token "No", delete this token value = Serial No; //$JR_EXPR_ID=10$ <> 19. Syntax error on token "for", . expected value = Paid for Insurance; //$JR_EXPR_ID=11$ <-> 20. Syntax error on token "ID", delete this token value = Loaner ID; //$JR_EXPR_ID=12$ <> 21. Syntax error on token "Date", delete this token value = Today's Date; //$JR_EXPR_ID=14$ <--> 22. Syntax error on token "ID", delete this token value = Student ID; //$JR_EXPR_ID=16$ <> 23. Syntax error on token "Loaner", delete this token value = Issued Loaner; //$JR_EXPR_ID=17$ <----> 24. Syntax error on token "SN", delete this token value = Loaner SN; //$JR_EXPR_ID=18$ <> 24 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:204) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:512) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Compilation running time: 376!

Hello I am a newbie. Just got setup with Oracle Apex 5.0 and JasgerReports usind IReports 5.1. I have create my data sources correctly that I know of. I have ran a basic simple report that did allow me to preveiw it in IReports. I come from using BI Publisher so this is a learning curve. So, I started to create what I really needed. A printout that prints out in a form like format and not in a table format. I have created a query that works fine as long a I do not put in a parameter which is not working for some reason. I am having no luck at all with this. So, when I try to run my report I get this: Errors compiling T:Oracle BackupsMAXApexRCSTECH Jasper RptsTestPrint_wktckt_P15_ID.jasper! Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@2bd3b0 net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: calculator_Print_wktckt_P15_ID_1443123967049_219409: 183: unexpected token: : @ line 183, column 30. 1 error at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:113) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:201) at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240) at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:156) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:439) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:528) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: calculator_Print_wktckt_P15_ID_1443123967049_219409: 183: unexpected token: : @ line 183, column 30. 1 error at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:302) at org.codehaus.groovy.control.ErrorCollector.addFatalError(ErrorCollector.java:149) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:119) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:131) at org.codehaus.groovy.control.SourceUnit.addError(SourceUnit.java:359) at org.codehaus.groovy.antlr.AntlrParserPlugin.transformCSTIntoAST(AntlrParserPlugin.java:141) at org.codehaus.groovy.antlr.AntlrParserPlugin.parseCST(AntlrParserPlugin.java:107) at org.codehaus.groovy.control.SourceUnit.parse(SourceUnit.java:236) at org.codehaus.groovy.control.CompilationUnit$1.call(CompilationUnit.java:161) at org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:900) at org.codehaus.groovy.control.CompilationUnit.doPhaseOperation(CompilationUnit.java:564) at org.codehaus.groovy.control.CompilationUnit.processPhaseOperations(CompilationUnit.java:540) at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:517) at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:109) ... 7 more Compilation running time: 40!