tag:blogger.com,1999:blog-20788401.post4748626667716704531..comments2024-01-05T06:28:19.101+01:00Comments on daust_de :: Oracle XE / APEX: JasperReportsIntegration: Passing multiple parameters to the reportAnonymoushttp://www.blogger.com/profile/04283721022948206416noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-20788401.post-5676055044811611372017-10-17T08:47:23.840+02:002017-10-17T08:47:23.840+02:00Hi JBL,
> Wow, thank you Dietmar for jumping ...Hi JBL, <br /><br />> Wow, thank you Dietmar for jumping on both of my requests<br />Well, you got lucky :). I was in the middle of upgrading the integration to the latest jasperreports version anyway ... so I just took care of that as well. <br /><br />Cheers, <br />~Dietmar. <br />Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-10495856498626333792017-10-17T00:43:13.392+02:002017-10-17T00:43:13.392+02:00Wow, thank you Dietmar for jumping on both of my r...Wow, thank you Dietmar for jumping on both of my requests. I am hosting my application at maxapex.com, so I will see if they will upgrade to your latest updates.<br /><br />JBLhttps://www.blogger.com/profile/01342384483662572830noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-69031009593461710862017-10-15T23:42:35.046+02:002017-10-15T23:42:35.046+02:00Hi JBL,
>I really need to adjust the time dat...Hi JBL, <br /><br />>I really need to adjust the time data in my report to the client timezone. I keep getting the timezone of the report server. Would it be <br />>possible to have the integration updated to be able to pass time zone, just like you can pass locale?<br />Yepp, I have just added the feature to the release 2.4.0 ... please give it a try and report the feedback. <br /><br />Cheers, <br />~Dietmar. Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-53495667582651074992017-10-15T23:41:06.605+02:002017-10-15T23:41:06.605+02:00Hi JBL,
> they now have some "Built-In&q...Hi JBL, <br /><br />> they now have some "Built-In" java functions in the Expression Editor. If I use any of the built-in functions I get errors when running >on my apex hosting server<br />I have just a few weeks ago learned about that. It was a missing .jar file in my package. It is now fixed in release 2.4.0, you can find it here: http://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/<br /><br />It will need some more testing but it already looks quite good. The jasperreports libraries are also upgraded to 6.4.1, the current release. <br /><br />Cheers, <br />~Dietmar. <br /><br />P.S.: BTW, where are you hosting your application? <br />Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-92127464922723560312017-10-12T00:03:33.537+02:002017-10-12T00:03:33.537+02:00I really need to adjust the time data in my report...I really need to adjust the time data in my report to the client timezone. I keep getting the timezone of the report server. Would it be possible to have the integration updated to be able to pass time zone, just like you can pass locale?JBLhttps://www.blogger.com/profile/01342384483662572830noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-34475106975022265842017-10-11T20:51:20.856+02:002017-10-11T20:51:20.856+02:00Using JasperSoft Studio 6.1.1, they now have some...Using JasperSoft Studio 6.1.1, they now have some "Built-In" java functions in the Expression Editor. If I use any of the built-in functions I get errors when running on my apex hosting server. I'm sure it is missing the .jar that includes these functions, I'm just wondering if I just need to request the hosting company add the jar to their report server or if that would require an update of your plug-in?JBLhttps://www.blogger.com/profile/01342384483662572830noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-22919344316851035002017-08-02T18:34:28.943+02:002017-08-02T18:34:28.943+02:00Hi Harikrishna,
I am sorry, but I cannot help yo...Hi Harikrishna, <br /><br />I am sorry, but I cannot help you with this. <br /><br />You are using the JasperServer but I have created my own J2EE for Jasper using the public libraries. You can find it here: <br />http://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/2.3.0-beta/Index.html<br /><br />It creates a wrapper using pl/sql to build the report url and call a j2ee application through utl_http on the database. <br /><br />Best of luck, <br />~Dietmar. <br />Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-77238395915354949772017-08-02T08:06:11.489+02:002017-08-02T08:06:11.489+02:00Dear Dietmar,
I am new to the jasper reports.here...Dear Dietmar,<br /><br />I am new to the jasper reports.here i developed jasper reports through the jasper reports studio.<br /><br />finally i was deployed report into jasper server. in server datasource i was manually configured the oracle schema name.<br /><br />for me i don't want to manual configuration of the schema names, because all the development phases we are having different schemas.<br /><br />schema names no need to change each time . here in oracle reports we will send schema names in url.<br /><br />http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow<br />&_flowId=viewReportFlow<br />&ParentFolderUri=/reports<br />&reportUnit=/reports/reportID<br />&standAlone=false<br />&_repFormat=pdf<br />&P_REP_SR_NO=102<br />&P_COMP_CODE=120<br />&P_REP_ID=samplerep<br />&j_username=jasperadmin<br />&j_password=jasperadmin<br /> <br />this is the way i am calling jasper reports from java.<br />is there any way to do like this..<br /><br />Please help me on this one.<br /><br />ThanksHarikrishnahttps://www.blogger.com/profile/11343507303778219253noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-51450673852902327282016-06-17T19:29:13.422+02:002016-06-17T19:29:13.422+02:00Hi Tony,
just pass it as a regular item , e.g. a...Hi Tony, <br /><br />just pass it as a regular item , e.g. apex_util.url_encode(:p1_picked_date). In APEX all variables are text (varchar2). <br /><br />in the report you will have to convert it to a real date (e.g.: to_date($P{pDate}) in the report query. <br /><br />Does that make sense? <br /><br />Cheers, <br />~Dietmar. <br /><br />Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-13420531159610350932016-06-17T18:07:12.210+02:002016-06-17T18:07:12.210+02:00Hello Dietmar,
Hope you are doing well.
When p...Hello Dietmar,<br /> Hope you are doing well.<br /> When passing parameters to the JasperReportsIntegration from APEX, will it handle parameters that are date datatypes (e.g. fields from APEX that are populated by an APEX date picker?<br /> If so, how is that done in the PL/SQL that is used to call the report?<br /> <br />Prost / Zum wohl<br />Tonytespos58goohttps://www.blogger.com/profile/12991671822105664971noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-64106815664442318562016-06-03T19:46:26.472+02:002016-06-03T19:46:26.472+02:00Hi Datta,
difficult, you provide too little info...Hi Datta, <br /><br />difficult, you provide too little information. <br /><br />You did not provide any code and don't know anything about the report. <br /><br />How can I test what you are doing? <br /><br />Cheers, <br />~Dietmar. Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-39096535682171900372016-06-03T12:24:42.808+02:002016-06-03T12:24:42.808+02:00Hi Guys,
I created a Jasper report and checked pr...Hi Guys,<br /><br />I created a Jasper report and checked preview in pdf format. It shows correct pdf.<br />when the same report is called from application "A" (on DB schema A). It displays a blank page immediately without any error. The code for calling report in form is as below,<br /><br /><br />However, in the same report if the report format changed to html it display correct report output in html format.<br /><br />The report attributes are correct because I tried calling the report from application B (on schema B) and it works fine with pdf output.<br /><br />I do not understand the issue. Pls helpDattahttps://www.blogger.com/profile/03995778240354988475noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1525168328194937052014-05-21T18:49:15.950+02:002014-05-21T18:49:15.950+02:00well, you could troubleshoot your statement here ....well, you could troubleshoot your statement here ... but I would rather recommend computing this flag in your sql statement so that in the report it boils down to a single and thus simple check. <br /><br />it is good practice to create a view for your report and compute as many relevant parts of your report already WITHIN sql ... makes your life a lot easier. <br /><br />Cheers, <br />~dietmar. Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-8310491924908426252014-05-21T18:43:25.802+02:002014-05-21T18:43:25.802+02:00Thank you for the reply aust.
based on the parame...Thank you for the reply aust.<br /><br />based on the parameter value selected according to the scenario, i want to display the field.<br />in the above condition, am calculating the average of responses based on the value selected for deliveryType,course_id,instructor_id<br />parameters.<br /> Anonymoushttps://www.blogger.com/profile/09731740158143807923noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-43357863566400781692014-05-21T18:36:39.153+02:002014-05-21T18:36:39.153+02:00what are you trying to achieve ... what is your us...what are you trying to achieve ... what is your use case?<br /><br />cheers, <br />dietmar. Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-40923671532805913512014-05-21T18:34:37.960+02:002014-05-21T18:34:37.960+02:00Hi,
can anyone suggest me where i am doing wrong. ...Hi,<br />can anyone suggest me where i am doing wrong. only first condition is working fine.remaining all are failing to display in ireport.<br />please suggest.<br /><br />((null == $P{reportSearchDTO.deliveryType} || $P{reportSearchDTO.deliveryType}.equalsIgnoreCase(“All”)) &&<br />(null == $P{reportSearchDTO.instructorID} || $P{reportSearchDTO.instructorID}.equalsIgnoreCase(“All”)) &&<br />(null == $P{reportSearchDTO.course} || $P{reportSearchDTO.course}.equalsIgnoreCase(“All”)))?$F{national_avg_cond1}.doubleValue():<br />((null == $P{reportSearchDTO.deliveryType} || $P{reportSearchDTO.deliveryType}.equalsIgnoreCase($F{DELIVERY_NM}.toString()))&&<br />(null == $P{reportSearchDTO.instructorID} || $P{reportSearchDTO.instructorID}.equalsIgnoreCase(“All”))&&<br />(null == $P{reportSearchDTO.course} || $P{reportSearchDTO.course}.equalsIgnoreCase(“All”)))?$F{national_avg_cond1}.doubleValue():<br />((null == $P{reportSearchDTO.deliveryType} || $P{reportSearchDTO.deliveryType}.equalsIgnoreCase(“All”))&&<br />(null == $P{reportSearchDTO.instructorID} || $P{reportSearchDTO.instructorID}.equalsIgnoreCase($F{SELECTED_INST}.toString()))&&<br />(null == $P{reportSearchDTO.course} || $P{reportSearchDTO.course}.equalsIgnoreCase(“All”)))?$F{national_avg_cond1}.doubleValue():<br />((null == $P{reportSearchDTO.deliveryType} || $P{reportSearchDTO.deliveryType}.equalsIgnoreCase($F{DELIVERY_NM}.toString()))&&<br />(null == $P{reportSearchDTO.instructorID} || $P{reportSearchDTO.instructorID}.equalsIgnoreCase($F{SELECTED_INST}.toString()))&&<br />(null == $P{reportSearchDTO.course} || $P{reportSearchDTO.course}.equalsIgnoreCase(“All”))) ? $F{national_avg_cond2}.doubleValue():<br />((null == $P{reportSearchDTO.deliveryType} || $P{reportSearchDTO.deliveryType}.equalsIgnoreCase(“”))&&<br />(null == $P{reportSearchDTO.instructorID} || $P{reportSearchDTO.instructorID}.equalsIgnoreCase(“All”))&&<br />(null == $P{reportSearchDTO.course} || $P{reportSearchDTO.course}.equalsIgnoreCase($F{COURSE_NM}.toString())))?$F{national_avg_cond2}.doubleValue():<br />((null == $P{reportSearchDTO.deliveryType} || $P{reportSearchDTO.deliveryType}.equalsIgnoreCase(“”))&&<br />(null == $P{reportSearchDTO.instructorID} || $P{reportSearchDTO.instructorID}.equalsIgnoreCase($F{SELECTED_INST}.toString()))&&<br />(null == $P{reportSearchDTO.course} || $P{reportSearchDTO.course}.equalsIgnoreCase($F{COURSE_NM}.toString())))?$F{national_avg_cond3}.doubleValue():0.0Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-2449296388043889222013-12-30T16:00:23.445+01:002013-12-30T16:00:23.445+01:00Hi Diego,
this is currently not possible, just s...Hi Diego, <br /><br />this is currently not possible, just strings. <br /><br />Cheers, <br />~Dietmar. Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-7878687790664098242013-12-26T05:49:50.796+01:002013-12-26T05:49:50.796+01:00hi Dietmar,
i would like to know how can we pass p...hi Dietmar,<br />i would like to know how can we pass parameters of the following types: integer and date to the report in iReport.<br /><br />thanks for your answer.diegonoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-1153645945334107312013-06-20T12:44:02.510+02:002013-06-20T12:44:02.510+02:00Hi Ricardo,
please explain in more detail ... I ...Hi Ricardo, <br /><br />please explain in more detail ... I don't understand. <br /><br />Cheers, <br />~Dietmar. Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-87115308060582008112013-06-20T04:38:16.600+02:002013-06-20T04:38:16.600+02:00Hi, i have a problem with ".show_report"...Hi, i have a problem with ".show_report", there is a way to show the report on the browser with ".get_report"? i really needed!! Anonymoushttps://www.blogger.com/profile/16229288075526354004noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-26810245525583098892013-06-04T14:36:11.888+02:002013-06-04T14:36:11.888+02:00Hi,
it's working great with me when I pass on...Hi,<br /> it's working great with me when I pass one parameter but when I tried to pass two it gave me an error "the file might be damaged".<br />removing the second parameter from the code is returning me to a printable pdf!<br />Bayan AljifriBayan Aljifrinoreply@blogger.comtag:blogger.com,1999:blog-20788401.post-69412651139792911382013-06-03T08:53:36.688+02:002013-06-03T08:53:36.688+02:00Hi,
I am currently faced with a situation. You ha...Hi,<br /><br />I am currently faced with a situation. You have Parameter 1,2,3 etc. and values can be passed to each of these, right?<br /><br />What if you have one parameter to Jasper, but this parameter can have multiple values and each of these values should be passed to Jasper? Can this be done?Anonymoushttps://www.blogger.com/profile/03544237544282319597noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-55967477285117974562013-04-27T21:00:51.652+02:002013-04-27T21:00:51.652+02:00Hi Damir,
I don't see a problem here. The UR...Hi Damir, <br /><br />I don't see a problem here. The URL is constructed using the package xlib_jasperreports. The url is ONLY used when calling the J2EE application using utl_http from whithin the database. This URL is never exposed to the client, the rendering request is tunneled through the database which functions as a proxy.<br /><br />I always even suggest that the J2EE is only reachable by the database server and not the end user directly. <br /><br />Thus, the end user will have no access to the URL. You can do any kind of security check within you database package or plsql process in APEX before calling the api. <br /><br />In JasperReports itself, you will typically construct the where clause using the passed parameters. <br /><br />If you use $P{..} JasperReports will produce bind variables (query parameters), while $P!{..} will be replaced as text in the query string.<br /><br />By using $P{..} you will also be pretty save with regards to SQL injection attacks. <br /><br />If you spot any security issue here, please let me know. <br /><br />Cheers, <br />~Dietmar. <br /><br />Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-67334470118048085382013-04-27T17:45:19.212+02:002013-04-27T17:45:19.212+02:00Hi!
I'm wondering if this is poassed through ...Hi!<br /><br />I'm wondering if this is poassed through URL, how to protect that from url tampering ... changing parameters?<br /><br />RG<br />DamirDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-20788401.post-27468125623647406342013-04-10T15:02:09.529+02:002013-04-10T15:02:09.529+02:00Hi Dietmar,
I am facing a new weird case.
when I p...Hi Dietmar,<br />I am facing a new weird case.<br />when I preview the report from ireport it's giving me the right report but when I try it from apex it's just showing blank page. I tried to put a number in the report sql instead of the parameter to check if the report going to appear from apex. yes it is giving me the report but once i returned the parameter it stops working.<br />note I am using java.lang.string for it and the name of the parameter is just the same as the one I am using in apex page process region.any clue?bayannoreply@blogger.com