raja_s_patil

After many trials I found a workaround to this issue. Shifted all calculations and printing to subreport's summary section. added last page footer to subreport and placed elements like Page # / Page Count whch need to appear on every page there. added page footer to subreport and placed page total and Page #/page count on it and print when expression to print it except last page. Placed a Group in Main-Report which breaks for each detail band which contains sub-report. set Subreport element's run to bottom property = true. Now I am getting report which satisfies 100% requirements. However I would like to improve my knowledge about Subreport return values, reset mechanism, and expression evaluation time. Somehow Information on this topic seems to be rare. If somebody has any links/posts on this please do post them. Thanks and warm regards. Raja Patil

Well, Meanwhile I shifted Main Report -> Group Footer Calculations to Sub-Report summary section and Passed Few Fields required for Calculations as Parameters to Subreport. The Result is almost fulfilling the requirement. The Only Thing remaining is Showing running Totals in Page Footer if Sub-report is spanning more than one page. I tried adding page footer to sub-report but its not being printed at exactly same location that of Main Reports page footer. Can somebody help me in this Regard ? However I will restore back version for Main report calculations and post it here shortly. Its for some other report where its not possible to shift calculations to sub-report.

hello, I am trying to print a Bill type report. which has some header information and item details. The Record class is as Follows billNo, billDate, ......... , discRate, taxRate, billItems (collection with details about each billItem like ......... qty, rate, amount) The datasource is beansCollection which has only one record for Testing purpose but in production there can be many. Each bill is to be started on new page so I added group on main report breaking on billNo property. The bill items are printed in subreport which is embedded in detailBand of Main report. In main report Pageheader band prints billNo, billDate, CustName, cust adress etc etc. Group Footer need some calculations based on Total of Amount (totValue) returned from subreport as follows. discount = (TotValue * discRate)/100.00 Total = TotValue - discount. TaxAmt = (Total*taxRate)/100.00 BillAmt = Total + taxAmt Rounded to Integer amount. ok What I did. I defined a variable in subreport as subToTAmt calculation type sum on field Amount of billItem class. defined a vaiable totValue in master report and type system. and did reurnValues mapping. Then defined rest of the variable in Proper order so that dependency variables are appearing before. Now when I preview report the page header, detail band, groupfooter bands prints except calculated vaiable values which are printed as null. The calculated variables are depending on totValue returned from sub report which is printed correctly but rest vaiables like discount, Total, taxAmt, billAmt are being shown as null. For discount I changed expression to $V(totValue) still its shown as null. Can somebody help me in this situation ? Thanks and warm regards. R. S. Patil

Hello, Earlier I was using iReport and have some experience in Using the designer. Now I have installed, Eclipse Java EE IDE for Web Developers. Version: Indigo Service Release 2 Build id: 20120216-1857 and JSS plugin 1.1.2 from http://jasperstudio.sourceforge.net/updates/ While designing the report I cant see green snap lines when I am trying to move elements and object being moved is not snapping either to grid or other objects left/right/top/bottom as its happening in iReport. What can go wrong with this type of setup Thanks and warm regards. Raja Patil

Hello, I am using Jasperreports in a project. I am really happy with its flexibility and ease of use. It has nice features about styles, external style templtes, scriptlets, and format factories. However in case of styles its bit uncomfortable to use when conditional stylling is required. e.g. when highlighting required on amount say values < min value, value > max value are to be shown in different style then there is feture of conditional styles but you can not use template feature for this and for each report conditional styles are to be defined in respective reports. In case of changing style is required then all reports are need to be modified which defeats purpose of style templates. I feel that this problem can be solved if feature of style expression is implemented. A element can have style property as at present which will be used as default and report designer can continue using it. Additional style expression property will return name of style to be used at runtime the style name can be from template or report doesn't matter and be used to render the element. the expression may look like ((${Fld}>max ? "style_Max" : (${Fld} < min ? "style_Min" : "style_Default")) or a scriptlet function can return string value in case of some complex decision making. How everybody feels about this suggestion. Hope it is to be discussed in detail. Thanks and warm regards Raja Patil PS : I have Opened Feature Request at http://jasperforge.org/projects/jasperreports/tracker/view.php?id=5844 If you feel this feature is Usefull then please Vote for it. Post Edited by raja_s_patil at 07/23/2012 20:05

Hello, I am using iReport 4.6.0 and has successfuly used own format factory. To use it on report I have defined my class on report's property "Format Factory Class" and tested it. But hence onward I want to use it for all reports so would like to define it as to be used globally without modifying rest of the reports. Similarly reports designed in iReport are being used through web application in production environment with help of jasperreports jars. there also this format factory need to be used with modifying any of the reports. will it be possible ? If yes what shall I do ? Thanks and warm regards. Raja patil

hello, I am using iReport 4.6. While using designer I generally use very feature of drag and drop of fields and parameters. in this process or dragging from pallete the TextFields are created with default ht 20 px and font of Sans Serif. Then its imperative to change ht and font if diffrent values are needed which defeats purpose of drag/drop feature designed to save time. is there any way to set default text field ht and font etc. etc. ? thanks and warm regards. Raja Patil

Hello, I am using iReport 4.6 and designing a report with group. The requirement is I want to parameterize Page Breaks of group. i.e. before report and query is fired user will decide whether he wants page breaks for group through some user interface form along with other parameters for query like fromdate todate etc. etc. Though report is designed in iReport it will be run through spring web application service which executes query and produces javabean collection which is datasource for report. Since group page break has nothing to do with query processing it can be only passed to report through parameters. Can somebody guide me how can i fullfil this requirement ? Thanks and warm regards raja patil SOlution : I used scriptlet for this the code is as follows public class Scriplet_DBS_Office extends JRDefaultScriptlet { private Boolean groupNewPage = new Boolean(true); public Scriplet_DBS_Office() { } @Override public void afterReportInit() throws JRScriptletException { Object param = this.getParameterValue("USER_GROUP_NEW_PAGE"); if (param instanceof Boolean) groupNewPage = (Boolean) param; if ((this.groups.length > 0) && (this.groups[0].getName().contains("GroupBookingDate"))) this.groups[0].setStartNewPage(groupNewPage); } Now with Parameter "USER_GROUP_NEW_PAGE" true/false Group is Page break are taking place accordingly. Hope this helps others. Thanks and warm regards Raja Patil Post Edited by raja_s_patil at 07/21/2012 02:31

Thanks mrabbi Hi, you can revert to a previous configuration. Just go to About Eclipse. Click on "Installation Details" button, then select "Installation History" tab. After that select a valid configuration to revert to: check the content that suite your needs, probably the first one back in timeline that has not the 4.2 stuff. However could you please describe what happened? Did the update to Juno occurred while installing JSS 1.1.2? We tested the install from a Indigo java installation package, and nothing similar happened. Could please specify if you are using a special version of Indigo? Could also take a screenshot or list the update sites that are actually enabled? well, I will try to do what you suggested. Somehow I felt "juno" to be bit inconvenient to use and JSS being not supported is major reason to go back to earlier version. No upgrade to Juno didn't happened while upgarding to JSS 1.1.2. However I wanted to update JSS so clicked "check for updates" it showed available updates and I blindly clicked OK whithout checking what eclipse updates are indicated. I just saw that JSS new version 1.1.2 is there and clicked OK. when Installation completed and eclipse restarted Then by seeing splash screen I realized that it has been upgraded to juno. No way I doubt that by just updating JSS plugin to 1.1.2 eclipse has upgraded to juno, its my fault that I have not checked other updates indicated. I am not using any special vesion of Indigo its download from Eclipse site EE version and few additional plugins downloaded from respective sites such as code coverage, findbugs, spring IDE etc. etc. nothing special one. Thanks and warm regards Raja Patil

Thanks, BTW though its beyond your perview, I was using earlier Indigo and during software update eclipse also upgraded to Juno unknowingly. Can you help me in this situation by giving tips on how to revert back to earlier version ? Thanks and warm regards Raja Patil

I am also facing same problem but of bit greater magitude. Even with report is open and eclipse restart the outline is blank. Have you found any solution to this ? I am using "eclipse juno" and plugin ver 1.1.2 latest update Screen shot is attached herewith. Thanks and warm regards Raja Patil

Hello, I am judging possibility of using jasper report for creating Text file report exports suitable for printing on dot matrix printer. Assume paper size is 8.5" x 12.0" normal printer grid is 10 Chars/inch horizontally and 6 lines/inch vertically. which means each character will be 0.1" x 1/6". iReport has resolution of 75px/inch so the character size converted to pixel is 7.5px x 75/6px but we can mention x,y,w,h of element in whole numbers then how to tackle this issue ? I am sure, since jasper report is being used so widely there is some work around to this issue can somebody point me out that work around ? Similarly while designing the report how can I set grid lines according to this character grid so that text export will be easy

Hello Friends, I have a report structure like given below and is working Fine with Bean Collection data source. ------------------------------- Page Header (Fixed Ht.) ------------------------------- Detail Band section - A with Fixed Layout of many fields (Fixed Ht.) ------------------------------- Detail Band section - B with sub Report which can vary in height (Variable Ht.) ------------------------------- Detail Band section - C with Fixed Layout of many fields (Fixed Ht.) ------------------------------- Detail Band section - D with sub Report which can vary in height (Variable Ht.) ------------------------------- Page Footer (Fixed Ht.) ------------------------------- When Section B has more records then either section C or section D is spanning over second page but all information is shown as desired No problems at all. Please guide me, if I want to keep section B, C, D on its own page then what shall I have to do. In short the section should not span to another page, doesn't matter if no of pages increases or lot of white space is introduced on pages. Keep together like functionality for report elements. I tried with frame and put sub-report in the frame then sub report is not shown at all. I have not tried it for other field elements. Thanks and regards Raja.

Hello friends, I am doing a project in which a requirement has popped up. user wants a report in following format and each record has to be started on new page, each page should be of A4 size with fixed header and footer contents. the detail band may or may not span multiple pages since it depends on how much records table bands has. Page can break at line but if grouping of bands can be done then its desirable like keeping table or form bands together on a page. A java bean collection will be used as datasource (I can use it no problems) Hope iReport/Jasperreports can do this if yes how shall I proceed. Thanks and Best regards Raja Here is the format ------------------------ Header band (fixed height) ------------------------------ Header may contain a line or two with logo (to be printed on each page) ------------------------ Header band ------------------------------ ------------------------ topband starts (can be fixed or variable height) ------------------------------ +------------------------------------+ Name : <name> | | Description : <description> | | | Picture of Product | | Fixed size but should | some other fields go here which may be of memo type | scale keeping aspect | | ratio | +------------------------------------+ ------------------------ topband ends ------------------------------ ------------------------ table band starts (variable height) ------------------------------ Now here a table with multiple (variable number) Records. ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ------------------------ table band ends ------------------------------ ------------------------ form band starts (fixed height) ------------------------------ Here some fixed name/Value pair Lines like name : <value> ------------------------ form band ends ------------------------------ ------------------------ another table band starts (variable height) ------------------------------ again a table with multiple (variable Records) ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ........ ------------------------ another table band ends ------------------------------ ------------------------ Footer band (fixed height) ------------------------------ Footer may contain a line or two (to be printed on each page) ------------------------ Footer band ------------------------------ <page break > before next record is printed

Thanks Teodor, I posted this question in ireport forum first and waited for two days then I thought This might be in perview of JasperReports so I posted it here also. Sorry for inconvennience. Any how giulio has responded here the solution. Thanks once again and best regards Raja

Thanks giulio, I will Try with jar but can I distribute this jar with my application. I remmber discussion we had about i report Licensing. Thnaks and best regards Raja.

Thanks, I am designing reports using iReport and in that there are two different query language options xpath and xpath2. I got confused because when I use xpath2 the report gets compiled and executes well in iReport. iReport uses jasperReport as base so i felt that I might be missing something to get it compiled in PHP with jasperReports. However if I compile template in iReport and execute it in jasperReport with xpath2 it works fine. So only compilation is affected in jasperReports with xpath2 query language. Can u take a look at it why only compilation is affected when template is created with iReport ? as of today jasperReports works fine with iReport pre-compiled templates. However I will try same report with xpath as query language in more detail and let u know exactly what is hapenning Thanks and best regards. Raja.

Hi, I am using ireport to create Report Templates and PHP-Java-Bridge to compile it through PHP. iReport ver. is 3.5.2, JDK 6, tomcat 6.0, WAMP server. I have succesfully tested master-detail report using local XML data file with xpath2 queries for master and detail in ireport and its giving desired results. However when I am trying to compile reports with PHP following error is thrown net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: No query executer factory class registered for xpath2 queries. When I change query language to xpath it compiles fine in both iReport and PHP but the results are not as expected in both environments which is natural since it needs xpath2 features. Can somebody guide in this situation ? (The matter is bit urgent) My best guess to this problem is that i might have missed some .jars while copying from jasperreports 3.5.2. If it is so then please tell me which jar is required for using xpath2. Another guess is iReport uses some other compilation jars than what jasper reports uses but I feel its a remote probability. Thanks and best regards. Raja.

Hi, I am using ireport to create Report Templates and PHP-Java-Bridge to compile it through PHP. iReport ver. is 3.5.2, JDK 6, tomcat 6.0, WAMP server. I have succesfully tested master-detail report using local XML data file with xpath2 queries for master and detail in ireport and its giving desired results. However when I am trying to compile reports with PHP following error is thrown net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: No query executer factory class registered for xpath2 queries. When I change query language to xpath it compiles fine in both iReport and PHP but the results are not as expected in both environments which is natural since it needs xpath2 features. Can somebody guide in this situation ? My best guess to this problem is that i might have missed some .jars while copying from jasperreports 3.5.2. If it is so then please tell me which jar is required for using xpath2. Another guess is iReport uses some other compilation jars than what jasper reports uses but I feel its a remote probability. Thanks and best regards. Raja.

Hi, I am beginer for jasperReports. I am using Flex, PHP stack for project and have evaluated Jasper Reports as reporting engine for this project. I found it easy to create reports with ireport and most flexible as far as datasources are concerned. We have finalized on this. We are using PHP/Java Bridge (PJB) to communicate with Java and in turn with JasperReports. Our pilot project is a success in which we could compile/fill/export test reports and are found satifactory. While using jasperReport through PJB we have to deploy all required jars to Tomcats lib dir. In initial setups we copied whole lib dir from iReport to Tomcat's lib but we feel that this is a super set of all required jars. While upgrading to latest jasperReports we also want to do minimum download and deploy latest version. So please guide us what are the jars eccential for 1. Compling 2. Filling / datasource creation 3. Exports Thanks and best regards Raja

Hi, We are converting a Delphi-Firebird Desktop application in a web application. We have chosen following stack Flex for UI, PHP serverside with data abstraction (adodb) we dont want to use any sql queries for reports but will use PHP to generate XML/CSV files with help of ADOdb and business logic in PHP, inturn this script will spitout XML in nested object form or plain record set form, This is being done since we would like to keep business logic in PHP rather than in Stored Procs of database. The prospective needs flexibility to change dbms to one of following MySQL, PostgreSQL, Firebird, MS-SQL and Oracle without much hassle. We have succesfully tested PHP-Java integration with help of PHP/Java Bridge and a PHP script is able compile, fill and export .jrxml. Now what we need is as follows. This is just a offhand basic design to start discussion. Flex is not capable of displaying any weppage so a new browser tab/window is necessary for viewing the server generated report/export/print object. Flex application will collect parameters for report and will passthem to PHP RPC. The PHP script will take parameters and fetch data from database and process it there and create a xml/csv file for filling up the template of report report. after filling the report the script will first delete XML file generated save print object to disk. This filename can be a obscure one for security reasons. Then the PHP script will return the URL for viewer application with print file name to flex application. Flex application will take this url and simply open a New window/tab for preview of report. This Viewer service/application should have export/print buttons along with page navigation and zoom setting buttons. as soon as the viewer is closed the generated file should be deleted.well this is our wishlist we would like to here comments/suggestions etc. etc from this community for betterment of user experience, security and functionality. Please freely express yourself. this type of functionality is already existing in our Delphi-firebird C/S desktop application. Rightnow we have reached upto step 6 and are able to export to all available formats but have stumbled at web viewer application since this is our first web application. Thanks and best regards Raja.

Hi, I have successfully created master detail report with a XML file containing nested Objects. I am beginer with iReport and purpose of the post is to help other beginers like me. I am attaching reuired files herewith for ready reference. here goes the step by step description. Create a master report. In master report define a datasource pointing to XML file attached. Open Query dialogue and select xpath2. Set /root as document root and /root/VOPurchaseOrder as record node. Define necessary fields and place them on master report and test the report in preview. If above thing works fine then proceed further. Drag subreport and place it on detail band of master report. I skipped all steps in the wizard but u can answer those options. select subreport in master report and go to proerties pane. in subsection subreport properties->connection Type select useDataSourceExpression. in sunsection subreport Properties->DataSourceExpression enter ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/VOPurchaseOrder/array_items/VOPOItemRef") Not That this is very important Note that we have selected /root/VOPurchaseOrder as record node for master report and /VOPurchaseOrder/array_items/VOPOItemRef as subdatasource. This makes only nested VOPOItemRef objects for current record in master report are selected for subreport datasource and this is what is expected. I have stumbled on this step since i started learning iReport. Ths is very crucial concept of subdatasources which takes little bit of time to digest for newcommers in XML and XPATH area. After this the life is normal. Select subreport tab in main editor window and select query definition dialogue. in this dialogue set /root/VOPurchaseOrder as document root since Mater report is using it as record set. Then define /VOPurchaseOrder/array_items/VOPOItemRef as recordset node for subreport. donot forget to select xpath2 Then define fields and populate the detail band. save detail report and compile it. select master report in editor tab and run it. If all have gone well u will see report otherwise debug it.If u have some queries about this example ask freely in this thread. Since I am a biginner in iReport I may not be able solve some tricky XML docs but I will take some efforts to help u out as I could. Thanks and best regards. Raja. Post Edited by raja_s_patil at 07/26/2009 09:02

Hi , I have XML data file with nested Objects and I would like to print it in master detail form I have done master datasource and Report Linking to it and doing master part of the report. Now I am stuck with detail part of it since I dont have any idea about how to define subdatasource and how to insert subreport in detail band of the Master Report. I am attaching xml and .jrxml herewith. Can somebody help me with this ? Thanks and best regards Raja

Thanks Giulio, I am studying jasperreport from a Book "Definitive Guide" and very much impressed by the basic design developers have adopted. What I can say is its a "Master Piece Created by Genious" for database application developers. Its ease of use for Programmers, Functionality and Flexibility is enormous. I dont know much about developers of jasperreport but I guess that they must have developed and implemented lot of database applications. Best Regards. Raja.

Hi giulio, As I mentioned in my previous Post I succeded in Generating PDF and Showing it in Browser./tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif The Report Under Consideration was Report with NoData i.e. EmptyDataSource. In the evening I am Going to Try XMLDatasource and Then RemoteXMLDataSource. I am glad to here that u also like and interested in PHP. I have Learnt java but had never coded in it so I am taking very long time to understand and modify the procedure. The main hurdle is I dont know java, tomcat webInfo etc.etc. every time I have to refere to books internet etc. etc. I dont know even where to keep jar files and how they are refered all basic java deployment issue after that I have to figure out how jasperreport behaves it's again a new Land for me. I have to select jars to be put in tomcat directory by trial and error. And I am also not sure that what ever jar I copied are sufficient or Not. as more and more runtime errors occur I have to copy more and more jars. So if u are taking initiative let us open new Topic for this discussion I will contribute to it as I could and this will openup PHP, Flex developers a new option for reporting which PHP, Flex lacks (This is to best of my Knowledge I am beginer there too) or even u can write a blog for this and post url to this forum or PHP forum it will be most welcomed by PHP community. From My experience Person Knowing Java and jasperReport can do this within two three hours. Hope u take it generousely and help ppl like us. BTW u r suggesting that compilation of .jrxml is a Unnecessary step then Can I use .jasper created by iReport directly ? if Yes How shall I and what shall remove or add to the PHP code "the blog" has provided. Please also post necessary jars to be included in Tomcats lib directory i.e. for compilation/no compilation and runtime must jars. If possible give us the best location for placing jar files. The Blog confuses between jre/lib/ext and tomcat/lib. Thanks and Best Regards. Raja.