kogantivijay

Hi Pepe Martínez, Thanks for your reply, I appreciate your views and would like to go-ahead as per the design that we discussed and i would post here a link to my blog once it is done as i find not a good list of resources for this along with all the views that we discussed so that others can take advantage of it. I have one more question for you, this is just the extension/Modification of the Scenario 1 you have just defined : - SCENARIO I: You have a collection of objects ("main collection"). Each object has 5 attributes which are Lists ("subcollections"). You need to display everything in one report. The Question is now i want each object in the collection to have a separate report for itself.(Note that the object is again having 5 Lists as its elements)This way i can avoid calling the jasper for each object in the List by wrapping it in the another List. I hope i am clear at my question do let me know if u need any info. btw sorry for the late reply, i was on vacation. regards, vijay

Hi Pepe Martínez, Thanks for your reply, I have figured out the issue for the above error and yes you are right it is because of missing Full Name including the package. can you tell me if the solution that i am following is a right approach for the above mentioned scenario ie Multiple List objects. regards, vijay

Any suggestions on this would be appreciated.. vijay

Hi all, Can you please let me know the strategy that i need to follow (an Example would be great) to generate a Report from Multiple List Objects. For Example : I have : List 1 - List<Persons> List2 - List<Accounts> List3 - List<Activities> My requirement is that i need to create a Report with all the 3Lists merged into one.How should i do it ? Another Question is that i need to generate multiple such reports ie say for each Country i need to generate one such report explained above, what is the best way to do it ? Please provide your thoughts on the above Queries. regards, vijay

Hi pepe_martinez, The problem i have is that my bean is having a collection bean as one of its elements and showing this is the actual problem, i was able to generate the preview of the bean with out the bean element but i am unable to figure out how to report it along with the bean element. For Ex: I hae contact Object with elements: String name; long number; List<Phone> phones; List<Friends> friends; Now the problem is how do i show a report with all these elements into the report. Please let me know if you need any clarification.. Please help me out.. :( regards, vijay

Hi all, I am a newbee to JasperReports and Ireports. I have got a 5 List Objects created by my java application and the intention is to create a Report that would has data from all the 5Lists with couple of lists to be displayed as Group By and with Total/sum computations . I have done some study and my understanding is that this can be achieved using the DataSource "JavaBeans Set DataSource" and creating a Master object wtih the each of the 5List Objects as a Attribute on the Master Object and create a report with 5 Subreports and while inserting the SubReport for the Step2:Connection exp select the radio button: use a JRDataSourceExpression and with value" new JRBeanCollectionDataSource($F{<ListElement>})" . I was creating the SubReport for these lists seperately and able to get fields from the report query,also its compiling propely but unable to run(as i cant pass data to this subreport). Now the problem is when i am trying to run the MainReport i am getting this error: Errors compiling C:ireportfilesireport3BeanReport.jasper! Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@4f1cf1 net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, calculator_BeanReport_1258468487525_97523: 169: unable to resolve class JRBeanCollectionDataSource @ line 169, column 64.calculator_BeanReport_1258468487525_97523: 233: unable to resolve class JRBeanCollectionDataSource @ line 233, column 64.calculator_BeanReport_1258468487525_97523: 297: unable to resolve class JRBeanCollectionDataSource @ line 297, column 64. 3 errors at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:92) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:192) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:135) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:516) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Compilation running time: 328! I confirmed that jasperreports-3.5.2.jar is avialable and it has the class JRBeanCollectionDataSource as well. My Query's : a. Am i trying to implement in a proper way ie with subreports..etc or is there any other better way ? b. If it is the correct method how to get rid of this error,I tried with 3.6.1 version as well just to make sure it's not wrong with jars. FYI : I was trying to follow mostly as per the info in this site: https://knol.google.com/k/nasir-qureshi/jasper-reports-working-with-beans-and/3az55pmbwf6s/3#An_Example_of_Using_An_ArrayList_As_A_Data_Source_For_JasperReports I have already spent 2days to come to this point, Please help me out.. Post Edited by kogantivijay01 at 11/17/2009 14:40

Hi edwin, That was just a single element in the DB. thanks, vijay

Hi, First You design your REport with the parameters in your Query or wherever you want it might be some where in your Report if you need.. Now Before you call your Jasper Code just Create a haspMap and pass that parameter value like this. parameter.put(parameterInReport,"Hai"); Now while calling your Jasper Code send that HaspMap as a Parameter ..That will Resolve your Problem..

Hi Thanks for that ..but i have found an alternative too which i thought to share for rest : I have modified my Query (MYSql) and i was keeping that Temporary Rows as my Field and Setting the Field property to print when it is Not NUll and Blank when Null..So if my DataSouce has empty value it will never get print this way.. select concat(B.PG_DEGREE ," in ",B.PG_SPECIALISATION," from ",B.PG_UNIVERSITY_NAME," in ",B.PG_YEAROFGRAD) AS pg ,concat(B.UG_DEGREE ," in ",B.UG_SPECIALISATION," from ",B.UG_UNIVERSITY_NAME," in ",B.UG_YEAROFGRAD) AS UG from educational_qualification B where EMP_ID ='123' Hope this will help some one out there.. thanks, vijay kumar

hI..I think i have not explained my Problem properly..Let me keep it simple.. My Report has got a Design Like this.. OS Values :$F{OS} This one Fetched the Values from my DataBase Column OS which has got value like this: "ABC,EFG,HGI,KXY,ZLM,MUO" When i reun my Report It is printing like this : OS Values :ABC,EFG,HGI,KXY,ZLM,MUO But i need my Report to print like this: OS Values :ABC EFG HGI KXY ZLM MUO Hope i am clear this time svenn..Please Advice me on this as it is really Urgent.. Thanks, vijay kumar k.

Hi , I am using Jasper report to design my page.I have stuck up with a small problem and wasted almost the whole day to find out still in VAin.. I have a TextField ->Column(InDataBase) that i have placed in the report .The Value of that Column will be " ABC,EFG,HGI,KXY,ZLM,MUO " Now when i am printing the Column value in my Report it should display like --> ABC EFG HGI KXY ZLM MUO ___> This is all i need I guess it has to do with some settings but tried every thing ... Can some one Help me out..as i need it very Urgent Thanks, vijay kumar k. Post edited by: kogantivijay, at: 2007/05/16 16:29

If you can manage to get a ireport Manual there is a very simple example explaining how the SubReport will Work STep by Step ..I have learned the Similar Way.. To Get the Info to the Next Page make sure You tick Print When Detail Over Flows.. Thanks, vijay kumar k. Post edited by: kogantivijay, at: 2007/05/16 16:27

Hi , I am using Ireport to design my page.I have stuck up with a small problem and wasted almost the whole day to find out still in VAin.. I have a Field ->Column(InDB) that i have placed in the ireport .The Value of that Column will be " ABC,EFG,HGI,KXY,ZLM,MUO " Now when i am printing the Column value in my Report it should display like --> ABC EFG HGI KXY ZLM MUO ___> This is all i need I guess it has to do with some settings but tried every thing ... Can some one Help me out..as i need it very Urgent Thanks, vijay kumar k.

HI all, I have a problem using Print When Expression..Let me brief You the problem.. I have arranged the TextFields and Static Text like this. [$F{Hello}] [ Static Text Here "In the "] [$F{World}] Now My Requirement is that i have to Print that whole Line including Static Text only if [$F{Hello}] returns some value from the DB.If it has no value it should not print the whole line including the Static Text also..How can i do that.. Thanks, vijay kumar k.

HI all, I have a problem using Print When Expression..Let me brief You the problem.. I have arranged the TextFields and Static Text like this. [$F{Hello}] [ Static Text Here "In the "] [$F{World}] Now My Requirement is that i have to Print that whole Line including Static Text only if [$F{Hello}] returns some value from the DB.If it has no value it should not print the whole line including the Static Text also..How can i do that.. Thanks, vijay kumar k.