honeybakliwal

Can you help me out where can i find domain.xml file because i am also facing the same issue

hi emmanuelpaul70 Can u please explain this in detail how u came upto the solution

I am using JasperReport Server Enterprise Edition. I have created Bar Chart with the following details On X axis i have value as period which has valiues in integer format as 1 ,2 ,3 ....and so on On Y axis i have sales qty in each period . Now i want to create hyperlink where i need to pass the X axis values to the drill down reports.. Please guide me how to fetch the category values and pass it on to the drilled down reports... I need to show the data in the same report itself on the same page Please this is really very urent Post Edited by honeybakliwal at 03/13/2012 07:47

Yes you can implement it with the help of cross tab

You can use list component

Create a variable type as double and in its variable expression rewrite statement as under ( $V{SumCTRLOrigCont}==0?0.0 : $V{SumCTRLDOPChgOrd} / $V{SumCTRLOrigCont} ) OR ( $V{SumCTRLOrigCont}==0?new Double(0) : $V{SumCTRLDOPChgOrd} / $V{SumCTRLOrigCont} ) Hope this solution works out :)

i have written a java code to populate the report data but the values are not getting populated into the pdf the code is shown below package jasper_Package; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.OutputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import java.util.Map; import net.sf.jasperreports.engine.JRException; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperRunManager; public class MySqlReportDSFill { Connection connection; Statement statement; ResultSet resultSet; Map values = new HashMap(); public void generateReport() { try { String query = "select * from customer"; Class.forName("com.mysql.jdbc.Driver"); connection = DriverManager.getConnection ("jdbc:mysql://localhost:3306/ireport?user=root&password="); statement = connection.createStatement(); resultSet = statement.executeQuery(query); JRResultSetDataSource resultSetDataSource = new JRResultSetDataSource(resultSet); while(resultSet.next()){ values.put("custid",Integer.parseInt(resultSet.getString(1))); values.put("custname",resultSet.getString(2)); values.put("phone",resultSet.getString(3)); values.put("email",resultSet.getString(4)); values.put("country",resultSet.getString(5)); values.put("state",resultSet.getString(6)); values.put("city",resultSet.getString(7)); System.out.println(values); } System.out.println("Filling report..."); JasperRunManager.runReportToPdfFile("/home/Honey/Honey/ireport Jrxmls/Java/JasperReports.jasper", "/home/Honey/Honey/ireport Jrxmls/Java/JasperReports.pdf",values,resultSetDataSource); System.out.println("Done!"); resultSet.close(); statement.close(); connection.close(); } catch (JRException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public static void main(String[] args) { new MySqlReportDSFill().generateReport(); } } Post Edited by honeybakliwal at 11/22/2011 13:25

Hello Everyone Can anyone help me out with the tutorial of how to implement Sort component avaialble with JasperReport Server 4.2+ editions Post Edited by honeybakliwal at 12/23/2011 10:45

Hi, I have created a report which is having fusion charts in it, when i deployed that report on to the JasperReport Server 4.1 Enterprise Edition it faces a issue which states as under When i try to run JasperReport Server on IE browser it shows Error in Loading Data in place of Fusion Chart, while the same report run successfully on all other browser with the flash chart please help me in resolving this issue

Hello, I am using jasperreport server 4.1 enterprise edition and i am facing toLoc.innerHTML = $(from location).innerHTML error when i am trying to run report on the server. I am attaching the screenshot of the error. Please help me in resolving this issue its really very very urgent Post Edited by honeybakliwal at 08/30/2011 13:01 Post Edited by honeybakliwal at 08/30/2011 14:18

Post Edited by honeybakliwal at 08/11/2011 05:53

Heyllo everyone i tried cascading parameters and did the same thing what is explained in the cascading parameter example in the sample reports My Requiremnt is i having 2 parameter say State(java.util.collection type) which is of multi select query type and have query as select distinct Customer_State from customer order by Cutomer_State; Another parameter named as City (java.lang.String) which is of single select query which has query as select distinct Cutomer_City from customer $X{IN,Customer_State,State} This second input control does not populate when I select something form the first. I see the visual icon showing that the server is doing something but the list stays empty. Thank you in advance for your time.

Heyllo everyone i tried cascading parameters and did the same thing what is explained in the cascading parameter example in the sample reports My Requiremnt is i having 2 parameter say State(java.util.collection type) which is of multi select query type and have query as select distinct Customer_State from customer order by Cutomer_State; Another parameter named as City (java.lang.String) which is of single select query which has query as select distinct Cutomer_City from customer $X{IN,Customer_State,State} This second input control does not populate when I select something form the first. I see the visual icon showing that the server is doing something but the list stays empty. Thank you in advance for your time. Post Edited by honeybakliwal at 08/11/2011 05:30

I am facing the error when i followed the above approach . It is not able to read the column name and flashing the error as Column name not found

Can anyone help us out even ia m nt able to implement font injasperserver while its so easy to implement them in iReport please help its really very urgent . Font is nt visible in jasperserver when i installed them in OS the font was visible injasperserver but wen i export it to pdf again i was disappointed please help me, as installing the font on every system at operating system is nt the right way to go ahead please guide me I am using Jasperserver 3.7.2 Enterprise Edition

Can anyone help us out even ia m nt able to implement font injasperserver while its so easy to implement them in iReport please help its really very urgent . Font is nt visible injasperserver when i installed them in OS the font was visible injasperserver but wen i export it to pdf again i was disappointed please help me, as installing the font on every system at operating system is nt the right way to go ahead please guide me I am using Jasperserver 3.7.2 Enterprise Edition

I am using jasperserver 3.7.2 Enterprise Edition

I am using jasperserver 3.7.2 Enterprise edidtion

hey Matt we are nt able to access it, is it possible you can post that article here so that it would be of great help to me

Can anyone help us out even ia m nt able to implement font injasperserver while its so easy to implement them in iReport please help its really very urgent . Font is nt visible injasperserver when i installed them in OS the font was visible injasperserver but wen i export it to pdf again i was disappointed please help me, as installing the font on every system at operating system is nt the right way to go ahead please guide me

Hi Anup, As per your issue you just have to create one variable of double type and in its variable expressionyou need to write one condition as described under (colummn.equlas'A'?column1.intvalue()+column2.intvalue:column1.intvalue()-column2.intvalue) If your name column is string Then just drag and drop that variable into the detail band of your report Hence your issue will be solved/tools/fckeditor/editor/images/smiley/msn/regular_smile.gif With Regards Honey Bakliwal

please help to solve the bug........

init: deps-jar: compile-single: run-single: simpleSubMasterList-------[{contraactname=5, contracttype=10 Apr 09, contractdesc=ABC Spa, contractid=13 Apr 09, componentlist=net.sf.jasperreports.engine.data.JRMapCollectionDataSource@c21495}] simpleDS2 values>>>>>>>>>>>>>>>>>>>net.sf.jasperreports.engine.data.JRMapCollectionDataSource@1d5550d simpleMasterList-------[{contractlist=net.sf.jasperreports.engine.data.JRMapCollectionDataSource@c2ea3f, reportingdate=23 May 2010, subject=New Request for CHL-99999999- THE PENINSULA BANGKOK(HBKK2000801), suppliername=THE PENINSULA BANGKOK, cmsagreementid=ABC-123456, reportingusagedate=29 May 2008}] simpleDS1 values>>>>>>>>>>>>>>>>>>>net.sf.jasperreports.engine.data.JRMapCollectionDataSource@a0dcd9 Entering Sep 9, 2010 3:32:24 PM net.sf.jasperreports.engine.fill.JRFillSubreport prepare SEVERE: Fill 6164599: exception net.sf.jasperreports.engine.JRException: Could not load object from location : nullnull at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:255) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:301) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:327) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:263) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2016) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:757) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:269) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:938) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:860) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:612) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205) at java.lang.Thread.run(Thread.java:619) net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Could not load object from location : nullnull at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:710) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:329) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:419) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:378) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:327) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:261) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:938) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:860) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:540) at net.sf.jasperreports.engine.JasperRunManager.runReportToPdfFile(JasperRunManager.java:351) at createeticket.TestOARP.<init>(TestOARP.java:99) at createeticket.TestOARP.main(TestOARP.java:111) Caused by: net.sf.jasperreports.engine.JRException: Could not load object from location : nullnull at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:255) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:301) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:327) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:263) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2016) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:757) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:269) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:127) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:938) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:860) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:612) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205) at java.lang.Thread.run(Thread.java:619) Java Result: 1 BUILD SUCCESSFUL (total time: 0 seconds)

Hi I'm trying to populate 2 subReports, each subReport has a table on it. I cannot seem to populate the second subReport table using the same data source(REPORT_DATA_SOURCE) eg. i used REPORT_DATA_SOURCE to populate both subReport tables, but only 1 report displays when both call this data source. The data for the main report displays as well as the the data for 1 subReport but not the second. the second report also does not even display the whole subReports table. eg. the column names that are static. Can anyone help me? or does anyone know if 2 subReports(with a table on each) can be populated? Thanx in advance.