crinch

Hi Olga Thank you for your reply, I have tried your line of code ($P{country_param}!=null?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") even with different combinations like ($P{country_param}!="null"?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") ($P{country_param}!=NULL?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") ==========with the scenario, if the user did not enter country=============== First of all using this line, it doesn't run in iReport tool and gives alert message like "The document has no pages". However works fine in iReport tool if the user enters any country. I have still used the above line of code of combinations and export the report in the JRS, like the below one ($P{country_param}!=null?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") if the user select country or not, the empty result is returned. I have attached the screen shot which has empty value. Also, when I go to create an input control the 'visible' checkbox every time gets checked and can't be un-selected. I really thankful to you for this. CRINCH

Hi Olga, Thanks for your replry, I have checked the "parternerId" parameter spelling and there is no issue with this. If I use only this parameter and reports works fine in JRS. However when I use "$P!{country_param_qry}" this query then there is problem wit the report. Actually I am trying to making the second input as optional if the user enter the country it will fetch the records against only that country but if the user did not enter the country so all the records will be fetched. So to get the functionality I have created two parameters to manipulate the query. This works fine in iReport tool but when I go in JRS it doesn't work. I am thinking about this line ($P{country_param}!=""?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") the above linke I had set this in iReport tool [default value expression] of the parameter "country_param_qry". Is there something we need to to in JRS against "country_param_qry" parameter to get this funtionality in JRS. WHAT DO YOU THINK. I have also tried to print this parmeter, it prints accurate value in iReport but prints null in JRS. I have attached the screen shot of JRS. Once again, I am really thankful to you for reply. CRINCH

Hi I am using JasperSoft 4.5 and have created a report which has two parameters - country_param : takes input from user - country_param_qry : checks first parameter's value and manipulate the query accordingly. e.g; i have set its [default value expression] like this. ($P{country_param}!=""?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") the QUERY is like this ============query==================== SELECT sp.OrderId, sp.ShippingCountry FROM tblshippedorders sp WHERE sp.PartnerId =$P{parternerId} $P!{country_param_qry} ORDER BY `sp`.`OrderId` DESC ==================================== This scenario works fine in iReport tool but when I export it in the Jasper server and create these parameteres but it did not work. I think there is need to make association between these 2 parameters in Jasper server report as done in iReport tool using second parameter's [default value expression] Need help to handle this Thanks

Hi, I am using JasperSoft 4.5 and created report in iReport tool. I have created two paramters lik 1 - country_param 2 - country_param_qry: I have set its [default value expression] as ($P{country_param}!=""?" AND sp.ShippingCountry='"+$P{country_param}+"'":"") so it is checking first parameter's value and manipulate it accordingly. Then this parameter is used in QUERY lik this =============query==================== SELECT sp.OrderId, sp.ShippingCountry FROM tblshippedorders sp WHERE sp.PartnerId =$P{parternerId} $P!{country_param_qry} ORDER BY `sp`.`OrderId` DESC ===================================== It is working fine in iReport Tool's Preview but when I export this file in Jasper Report Server and run it after creating 2 parameters it doesn't work. I think the first parameter's value is not being passed to second parameter OR I don't know how to set second parameter's defaul value expression to first parameter as done in iReport tool. Any one has idea how to handle this scenario. Thanks

Hi, I am using Jasper 4.5. I have created a parameter in a report using iReport Designer Tool[of Parameter Class is DATE]. when this input box alerts, it displays the date format as [Thu 09/06/2007] . Can I change this date format to [YY-MM-DD] means 2007-09-06. Help is required. Thanks CRINCH Post Edited by crinch at 08/09/2012 07:52

Hi, I am using Jasper Report server 4.5, i have created a report in the ireport. I have place two input parametere as date start and date end. it works fine while getting input as dates from user. Now I want that if the user did not enter dates the date part of the query should not run as we done in the php applications like ============= if($dtFrom != '' && $dtTo != '') { $strWhere = " AND DATE(OrderDtTm) >= '" . $dtFrom . "' AND DATE(OrderDtTm) <= '" . $dtTo . "'"; }else{ $strWhere = ""; } $qry = "select * from abc where partner id = 120 " . $strWhere; mysql_query($qry) ============= so all records will be fetched without having date comparison in the query if the user did not enter the date statrs and end. CRINCH

I have done this, I am very thankful to you for this. Thanks alot Olga! Post Edited by crinch at 08/06/2012 10:47

I have created report in iReport My Query was =========== SELECT sp.OrderId, sp.OrderDtTm,sp.Email,o.CustomerID, C.FirstNameB,C.LastNameB, sp.Subscribe, sp.Item, sp.StyleNo, sp.Size, sp.Color,sp.Quantity, sp.Price, sp.Total,sp.BillingCountry, sp.ShippingCountry, sp.StoreOrderNo FROM tblshippedorders sp LEFT JOIN orders o on (sp.OrderId = o.ID) LEFT JOIN customers C on (C.ID = o.CustomerID) WHERE sp.PartnerId =$P{parternerId} ORDER BY `sp`.`OrderDtTm` ASC =========== When I run the report it takes input from me and fetch the data successfully. Now I add this reoprt in report unit and created an input control which will be promt when the report will run. Would you like to tell me what will be the input controller name and what will be parameter name in the URL so the report could run successfully. Thanks again!

Olga, I am really thankful for your reply. My requirement is not an input control rather an a parameter from the URL when this report will be accessed. I am already created a data source. So how I will enter parameter in the URL and that should be acceptable while running a report in the Jasper Report Server.

Hi, I am using JaserReport Server 4.5, I have created a report using iReport which has query. It runs successfully and it is input based report, the report takes input from user while go to preview in iReport. I need to create a dashboard and embed this report in Jasper Server. I am not getting understand how to do this becuase the report is parameter based. I need help to how to implement this scenario. Thanks in advance

Hi, I am using JasperReport Server 4.5, I am creating a sample report in iReport using a query. I need to display text field value by calculating something like this number_format(($newOrders*100)/$totalOrders, 2) where $newOrders = query field & $totalOrders = variable. I know how to set the value of a field by right clicking on the field and select 'Edit Expression' and then we select query fields, variable etc. But I am not getting understand how I can set the value of field by making calculation of other query fields and variables. I am very much thankful for help.

Hi, I am using JasperReport Server 4.5 with iReport. I have two different reports which run perfectly as individual. Now I want to merge them using sub-report concept but I am getting problem. Most of the examples I have checked are parameters base, these parameters are used in sub-reports as input but in my case there is no need of paramter for sub-report. I have follow some links and videos but are in vain like 'http://www.youtube.com/watch?v=8GufzAOU4JY' I just place a sub-report element in the master report and set it as using existing jar file, when I click on preview button I get error which I have attached with this post. I need any online link/video which shows how to merge two reports using sub-report concept(the reports are simple and no parameter/input is used in any child report). I am very thankfull to you for this.

Hi, I am new to Jasper Report Server and using Jasper report server 4.5.0 Enterprise. I have followed the link mentioned below to avoid the 'View' link from menu if the logged user has role 'Role_Test' http://community.jaspersoft.com/questions/542445/how-hide-menus-based-roles-jasperserver-45 and also add a new context like this [/code]on the below mentioned location C:\Program Files\jasperreports-server-4.5\apache-tomcat\webapps\jasperserver-pro\WEB-INF\actionModel-navigation.xml but when I get logged in with role Role_Test, the 'View' link still shows in the menu. Please help me out how to do this and also how I can hide other menu links agaist a specific role. I am very thankful to you for this.

Hi, I am using Jasper Reprot Server 4.5.0. I have checked its sample data and its SuperMart Demo Dashboard. I have created a simple dashboard, I want to call this dashboard in my corporate web application. Is there any API available to call this dashboard. I have tried to find such API but I could not find. Help is required, thanks in advance

Hi, I am using Jasper Reprot Server 4.5.0. I have checked its sample data and its SuperMart Demo, I need to make such kind of dashboard and then call it in my php application using available APIs but I have found that there is no such API for dashboard. Can anyone help me out how I can handle this feature, is there replacement available of dashbaord which looks something like it which has different reports and charts in one place. Help is required, thanks in advance Post Edited by crinch at 07/13/2012 15:14