chetan_33

Can you please point me to a sample of groups within SUBDATASET for a crosstab I am trying to build up a cross tab report in which context it can be of help.

Hi Teodord Thanks for reply Teodord I looked into jasper jar withign the iReport but couldnt locate any logging related properties. Can u please tell me what property has to be added and in which path I have a need whereby I want to see what query is getting executed after all the parameterisation. Also since my cross tab display is not workgin right now I was interested in debugging the rendering of cross tab as to the row and column headers and the data fetched This was important since I am trying to develop reports with iReport And from ur suggestion what I see is I have to configure the IDE eclipse with jasper So these are 2 different part of world unless we have iReport plugin for eclipse!! or is there any other way? Post edited by: chetan_33, at: 2006/07/28 13:55

for jasper1.2.5 and iReport1.2.5 While defining Sub datasets through iREPORT we get to see Group & Properties button besides the field, parameter and variable buttons Does anyone know what this group is for and hwo it is to be used. I was not able to figure it the cross tab samples of jasper

Hi All, I am using jasper and iReport1.2.5 and created a very simple crosstab on the same lines (& nearly same business model) of ShipmentsReport in jasper sample. But the data within crosstab is not being rendered. Its totally blank. All the necessary parameter passing was done as in sample. I even tried to have data fetched in the subdata set without using parameters. But to no help. The only change is it is within a external grouping on organisation in main report whcih is working fine. My sql query is pasted at end here I wasnt able to attach a 250 KB doc (screen grabs with details of iReport ) and I can mail you if u need more information. You can zoom and see the details for helping me Is this a bug in jasper/iReport?? I see Similar postings at http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&view=threaded&id=268&catid=8 http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=189#189 ################## sub data set Query SELECT sapKna.Name1 as alias_STPartn_Name1, material.PHier2_Val, material.PHier3_Val, material.FAKD1, absUms.JAHR, absUms.MONAT,absUms.MENGE , absUms.EINHEIT, absUms.WERT,absUms.WAEHR FROM aduint.CUB_AbsUms absUms, aduint.SAP_KNA1 sapKna, aduint.ADIS_BW_MATERIAL material WHERE ( cast(JAHR as numeric) >= (DATEPART(YYYY,CURRENT_TIMESTAMP)-4) ) AND ( (absUms.PNRAG LIKE '%0000684465%') OR (absUms.PNRAG LIKE '%0000001734%') OR (absUms.PNRAG = $P{PARAM_subDataSet_PNRAG}) ) AND ( absUms.VKORG LIKE '%%' OR absUms.VKORG = $P{PARAM_subDataSet_VKORG} ) AND sapKna.KUNNR = absUms.PNRWE AND material.MATNR = absUms.MATNR order by alias_STPartn_Name1, absUms.PNRWE,material.PHier2, material.PHier3, material.FAKD1, absUms.JAHR, absUms.MONAT ###################### Post edited by: chetan_33, at: 2006/07/28 08:50 Post edited by: chetan_33, at: 2006/07/28 08:52

Hi All I am new to jasper report and wonder whether there is any logging within jasper whose level can be changed to things like information or debug so that I get the executed query printed out on console or into a log file? Same also for iReport It shows the compilation output message and error but better if we can get more details by referrign complete information in console or a log file Any inputs to help me?

Hi Neetika I am also carrying out a similar exercise and right now looking at Jasper. Will like to be in touch with you for the same. I already have posted my queries since long but seems no one is interested to support fresh users of jasper/iReport and in absence of complete documentation its a tough job to evaluate and claim the product capabilites You can see my posting at http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=8&id=108#108 I would be interested to know your findings. Hope you share it. Thanks

This is already posted on sourceforge at http://sourceforge.net/forum/message.php?msg_id=3830751 however found that jreport has new home so reposting here.Hope to see some reply soon. This post may be interesting for architects of this project to identify new features. I expect to see some inputs from them as well Hi All, This weekend I need to be prepared with evaluation results of these reporting solutions and have inclination towards open source Jasper. Writing to this forum inorder to resolve certain tricky/complex queries, more supporting inputs on its comparison and near future features expected. I had chance to understand and work JasperReport+iReport for not more than 5 days and felt this forum could offer me insight of it in short time. And am evaluating jasper report against SQL Server 2005 Reporting service. The evaluation is meant to get alternative reporting solution for existing custom java report engine in a full fledged J2EE application with huge amount of data and having short development time. Also main objective of study being being able to compare for this two against current/old reporting engine I am MAINLY LOOKING FOR INPUTS & solutions on following points at the moment which are partly or completely UNCLEAR after my initial study. Points 3, 4, 8, 10 - (what all approaches?. one approach I saw is it may require generating jrml file usign velocity approach as in one sample of IBM. However from a page on web I come to know that escaping $ seems to be problem in this case. ) 11- How is drill down for formats other than HTML addressed - mainly XLS, XML 15 to 25 Evaluation points 1. the capability of new reporting engine to render similar reports as in old system, addressing atleast all features in old engine (this are mentioned separately below) 2. Determine the integration for the reporting engine with existing appln i.e. interfacing that this old system can do with new system for getting the report. 3. and integration in Portlet environment is important 4. Performance 5. Scalability and the scope for future extensibility in the new engines Desired FEATURE of new reporting engine 6. Generate a report - typically separating UI definitions, data source and generate various O/p formats as HTML, XLS, XML, PDF. 7. Address internationalisation and localisation ( locale specific date formatting) 8. Support for parameterisation of queries (entered from search and advanced search pages). and any provision to make search and advanced search screens for input parameters 10. Dynamic queries -- i.e. further ability to ignore part of SQL based on input parameter not provided [This is VVIP factor and I want to know how it is addressed in these engines]. This also influences certain part of output data not being fetched. Thereby output columns or dataset may be dynamic. 11. sub reports & Drilldown 12. Cross tab reports 13. Current engine carries out calculations through queries unlike the approaches in these new engines. 14. Offline report capabilites as schedule, mailing is not a requirement at moment. 15. There are no major charts display as of now but can have a drilldown chart. 16. Can the report be displayed with lazy data fetching in cases of tons of data 17. Support for style sheet. Plus provision to address output file specific formattings 18. Use of separating pagination component in rendered reports. I felt the pagination logic is tightly coupled in jasper output may be with certain objectives for good!! 19. Does XML output retain the layout details defined in iReport 20. There can be multiple nested groups of data with calculations like TOTAL for columns being required at end of each group. is this possible? 21. Further to point 20 possibility to show single group completely on same page if data exceeds the pagination being set. Its like adding the page breaks at end of group overriding the defined pagination preferences(say 20) . This is since group sums displayed looks incorrect if 5 out of 50 columns are on preceding page. So effectively if there are 10+10records in 2 groups then I can show it on same page but if there are 10 +50 records in 2 groups then will like to have page break after the first 10 and then next page break after the 50 and then resume normal display 22. Licensing for JasperServer in case of applications with ASP model. I understand that JasperServer is required for analysis and workflow solutions which is not in my case. But does it help in point 3, 8, 10 23. Looking for known limitations in Jasper and which of them are expected to be resolved in near future. 24. Can jasper report address sorting on multiple column headers? How does if fucntion in case of grouping - i.e are the grouped records sorted or the complete set of data 25. Can the rendering be initated before the complete filling process happens? how to do? I am trying my best to learn up the jasper to address this but at moment it seems to be going slow and bank on the experts in this community. I saw the webinar yesterday and may be few points are also inputs to Teodur for new features. Thanks and Regards