tag:blogger.com,1999:blog-16506996.post6708523228803780857..comments2024-02-08T01:57:07.944-07:00Comments on The Digital Voice: BIRT: Resort Columns After Report Has Been RunJohn Wardhttp://www.blogger.com/profile/10741149622435353727noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-16506996.post-53257366605211071782012-04-25T06:37:20.675-06:002012-04-25T06:37:20.675-06:00Thanks John for the article. It was helpful.
I cr...Thanks John for the article. It was helpful.<br /><br />I created a sample report with the sorting option as you have explained.<br /><br />This might be helpful if anyone is having issues.<br />http://www.birt-exchange.org/org/forum/index.php/topic/17847-sorting-in-birt/page__st__20__p__99634&#entry99634Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-38961565050357664332009-03-19T12:15:00.000-06:002009-03-19T12:15:00.000-06:00Hi John Wardyou had mentioned:If you are using an ...Hi John Ward<BR/><BR/>you had mentioned:<BR/>If you are using an embedded BIRT Report Engine, your going to take the values from POST, and add them to the Parameter Map in the Run task.<BR/><BR/>I am trying to send parameters through request object. I want to use the following in initialize function of the report:<BR/><BR/>var id = reportContext.getHttpServletRequest(). getAttribute("list");<BR/><BR/>reportContext.setParameterValue("Report_Param",id);<BR/><BR/>How do i pass the request object from my JSP to the BIRT report? I have set the value of "list" using request.setAttribute("list", list) in the application.<BR/><BR/>thanks<BR/>NeetiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-22205616117876970682009-02-19T07:39:00.000-07:002009-02-19T07:39:00.000-07:00I need to give a space for comments where comments...I need to give a space for comments where comments can be added electronically by users Is it possible in Birt report.I would highly appreciate if someone can give me solution.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-51747579001910856112009-02-02T09:26:00.000-07:002009-02-02T09:26:00.000-07:00Thank You Sir, You gave me a wonderful idea,It is ...Thank You Sir, You gave me a wonderful idea,It is working as I wanted.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-27060811383283695112009-01-30T19:11:00.000-07:002009-01-30T19:11:00.000-07:00To do a date range drill through, you would have t...To do a date range drill through, you would have two Report Parameters in the detail report for the date range. <BR/><BR/>In the master report, when creating your drill through, you would set the target reports parameters to the appropriate parameters in the summary report. So in the summary report, if your date range was called startDate and endDate, you would set the startDate and endDate in the Target report to something like params['startDate'] and params['endDate']. The expression builder will help you put in the correct paramters.<BR/><BR/>See: <BR/>http://birtworld.blogspot.com/2008/05/birt-drill-through.html<BR/><BR/>http://www.birt-exchange.com/devshare/designing-birt-reports/389-birt-drill-through/#descriptionJohn Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-12360315939160464952009-01-30T11:46:00.000-07:002009-01-30T11:46:00.000-07:00I want detail report(I am using drill through appr...I want detail report(I am using drill through approach)to run for the same date range which is given for master report.eg if master report is supposed to run for may,june 2008 then details should be for this range.<BR/>I would appreciate if someone can help me.<BR/>Thank YouAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-26540601414630965462008-07-02T06:36:00.000-06:002008-07-02T06:36:00.000-06:00Hi,I am working on birt 2.2.2. I made a report usi...Hi,<BR/><BR/>I am working on birt 2.2.2. I made a report using cross tab(data cubes). It gives error when i tried to fetch many rows(almost 300 rows) while its working fine if i fetch some rows(less then 300 rows). Is there any limitation in Birt? I want to show 20000 rows can you please tell me how i can generate report with 20000 rows. <BR/><BR/>Thanks. <BR/><BR/>I got following error<BR/><BR/>"The following items have errors: <BR/><BR/>ReportDesign (id = 1): <BR/>- Retrieving binding data error <BR/>Retrieving binding data error ( 5 997 time(s) )<BR/>detail : org.eclipse.birt.report.engine.api.EngineException: Retrieving binding data error at org.eclipse.birt.report.engine.internal.document.v4.DataItemExecutor.doExecute(DataItemExecutor.java:96) at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:293) at org.eclipse.birt.report.engine.internal.document.v4.ExtendedItemExecutor.prepareChildExecutor(ExtendedItemExecutor"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-90132120224716255252008-07-01T01:27:00.000-06:002008-07-01T01:27:00.000-06:00Hi John ward,I am using web viewer.Hi John ward,<BR/><BR/>I am using web viewer.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-64730988239066676822008-06-30T12:18:00.000-06:002008-06-30T12:18:00.000-06:00Again, thats going to depend on the deployment sce...Again, thats going to depend on the deployment scenario. If your using the BIRT Web Viewer, your just going to add the values in your JSP page to the URL. If your using an embedded BIRT Report Engine, your going to take the values from POST, and add them to the Parameter Map in the Run task. Without knowing how you have BIRT set up, I really can't tell you for sure.John Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-22767051229059228662008-06-30T05:05:00.000-06:002008-06-30T05:05:00.000-06:00Hi John,Thanks. I have made customize jsp paramete...Hi John,<BR/><BR/>Thanks. I have made customize jsp parameter page. in this page user select value from list box. now i want to get these selected value in report. If customized jsp page is not right way then please tell how i can make it? like embedding.<BR/><BR/>Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-20370604405871345212008-06-26T17:14:00.000-06:002008-06-26T17:14:00.000-06:00Well, that depends on how your calling your report...Well, that depends on how your calling your report. If you have a customized JSP parameter page, are you including the BIRT sample web app, or are you embedding the Report Engine API into your app and calling reports that way. If your using the sample web app, you only need to call the web app with a URL parameter like "myArea=value". If your embedding it, then the reportContext.getHttpServletRequest() will only work if you are calling the calling portion via a POST request. Id need a little more info to know how your calling the report to answer that for sure.John Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-35553697934654399092008-06-26T05:07:00.000-06:002008-06-26T05:07:00.000-06:00Hi,I have made one customize html parameter page i...Hi,<BR/><BR/>I have made one customize html parameter page in jsp. Now when i tried to get htlm text value into birt script, it return null value. how i can get html text value in birt report.<BR/><BR/>This is my birt script code:<BR/><BR/>req = reportContext.getHttpServletRequest();<BR/>val =req.getParameter("myArea");<BR/><BR/><BR/>Can you pleas tell me how i can get html text value in birt script.<BR/><BR/>ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-70564153579746058582008-05-08T23:54:00.000-06:002008-05-08T23:54:00.000-06:00I reworked the script. Apparantly there has been a...I reworked the script. Apparantly there has been a change in the accessibility of some of the classes, and have been re-exposed as SimpleApi. I redid the script itself to use this interface instead. This will fix the issue you are experiencing on Tomcat.<BR/><BR/>importPackage (Packages.org.eclipse.birt.report.model.api.simpleapi);<BR/>if ( params["rptprmSortOrder"].value != null )<BR/>{<BR/> var sortCondition = SimpleElementFactory.getInstance().createSortCondition();<BR/><BR/> switch (params["rptprmSortOrder"].value)<BR/> {<BR/> case "date" :<BR/> sortCondition.setKey("row[\"PAYMENTDATE\"]");<BR/> break;<BR/> case "price" :<BR/> sortCondition.setKey("row[\"AMOUNT\"]");<BR/> break;<BR/> }<BR/><BR/> sortCondition.setDirection("asc");<BR/><BR/> this.addSortCondition(sortCondition);<BR/>}John Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-91359574164990081572008-04-23T00:35:00.000-06:002008-04-23T00:35:00.000-06:00I tried the example with this code:importPackage( ...I tried the example with this code:<BR/><BR/>importPackage( Packages.org.eclipse.birt.report.engine.api.script.element );<BR/>importPackage( Packages.org.eclipse.birt.report.model.api.simpleapi );<BR/><BR/>var sortCondition = StructureScriptAPIFactory.createSortCondition();<BR/>sortCondition.setKey("row[\"WORKGROUPID\"]");<BR/>sortCondition.setDirection("desc");<BR/><BR/>var sortKey = sortCondition.getStructure();<BR/>this.addSortCondition( SimpleElementFactory.getInstance().createSortCondition(sortKey));<BR/><BR/><BR/>in Eclipse-preview the snippet works, but with tomcat it throws following error:<BR/><BR/>java.lang.NoClassDefFoundError: org/eclipse/birt/report/engine/script/internal/element/SortConditionImpl<BR/><BR/>any idea what this error could cause?<BR/><BR/>greets, yvesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-28429843860931503412008-04-15T01:49:00.000-06:002008-04-15T01:49:00.000-06:00Hi John,All these above example passed single valu...Hi John,<BR/><BR/>All these above example passed single value but I want to pass multi selected value. In Master report I have a multi selected value parameter I want to pass this parameter to detail report. I used drill-through (select detail report parameter and given a master parameter). It generates the following error in detail report.<BR/><BR/>ReportDesign (id = 1): <BR/>+ Cannot get the result set metadata.<BR/>SQL statement does not return a ResultSet object.<BR/>SQL error #1: ERROR: syntax error at or near "["<BR/><BR/>Cannot get the result set metadata.<BR/>SQL statement does not return a ResultSet object.<BR/>SQL error #1: ERROR: syntax error at or near <BR/><BR/>Can you guide me how I can solve this problem.<BR/><BR/>Thanks<BR/><BR/>AlviAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-83191734374951127992008-04-10T09:05:00.000-06:002008-04-10T09:05:00.000-06:00Alvi,Yes, what you are looking for is called a dri...Alvi,<BR/><BR/>Yes, what you are looking for is called a drill-through. It is he same steps as the last section of this article, where you would select a text/data/label element, and in the property editor, go to the hyperlink section, and choose drill-through as your action type. Here are a couple of articles on how to do that.<BR/><BR/>http://help.eclipse.org/help31/index.jsp?topic=/org.eclipse.birt.doc/birt/birt-18-4.html<BR/>http://www.eclipsemag.net/ecm/ecmfeatures/psecom,id,44,nodeid,3.html<BR/>http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/drill/index.php<BR/><BR/>There should also be a section in the BIRT help file about how to do this.John Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-83047823546254423152008-04-10T02:25:00.000-06:002008-04-10T02:25:00.000-06:00Hi John,Thanks for response. I would like to know ...Hi John,<BR/><BR/>Thanks for response. I would like to know how I can pass parameters from one report to another report. Could you tell me any tutorial or give me example. <BR/><BR/>Thanks<BR/>AlviAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-63171774116006451202008-04-09T09:46:00.000-06:002008-04-09T09:46:00.000-06:00Alvi,I can't really make heads or tails of the sit...Alvi,<BR/><BR/>I can't really make heads or tails of the site. Unfortunately I am limited to only English and Spanish as languages. With that being said, based on your description, there are two things you might want to consider. I believe you can do what you are looking for with BIRT by using the design Engine API to manipulate the Cube that generates the crosstab. Its a little bit of legwork, but I believe it can be done. If your looking for something a little easier to develop, Actuate, who are the developers of BIRT, have a few commercial options that build cubes, but I haven't worked with those products specifically. <BR/><BR/>JohnJohn Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-26574059455065845972008-04-09T05:31:00.000-06:002008-04-09T05:31:00.000-06:00We are in the process of migrating an existing sta...We are in the process of migrating an existing statistics-solution from Oracle with Olap-option on Orion server to our Birt/porgresql/jboss - environment.<BR/>The existing solutions provides functionality for rotation of the result-table/cross-tab. The rotaion works in such a way that the enduser can manipulate the way the table is presented after it is generated. For instance: The enduser can choose to rotate the result-table eigther left, right or even freely. If the "rotate left" option is choosen then one of the horizontal indexes is moved to the vertical axis, and at the same time one of the vertical indexes is moved to the horisontal axis. You can see the existing solution here: http://www.shdir.no/pasopp/index.jsp - try and push the upper button named "Vis tabell" (which is equivalent to "show table" in Norwegian).<BR/>Any idea on how to replicate identical or similar behaviour with Birt? Is the solution to create multiple different cross-tabs?<BR/><BR/>Thanks<BR/>AlviAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-60287717584906985912008-04-02T16:18:00.000-06:002008-04-02T16:18:00.000-06:00So does anyone have a suggestion on how to get the...So does anyone have a suggestion on how to get the ASC and DESC to toggle if the user clicks on the header again (twice)?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-66869802759067748412008-04-02T16:15:00.000-06:002008-04-02T16:15:00.000-06:00I couldn't get his example to work either. But thi...I couldn't get his example to work either. But this works.<BR/><BR/>importPackage( Packages.org.eclipse.birt.report.engine.api.script.element ); <BR/>importPackage( Packages.org.eclipse.birt.report.model.api.simpleapi ); <BR/><BR/>var sortCondition = StructureScriptAPIFactory.createSortCondition(); <BR/>sortCondition.setKey("row[\"WORKGROUPID\"]");<BR/>sortCondition.setDirection("desc");<BR/><BR/>var sortKey = sortCondition.getStructure();<BR/>this.addSortCondition( SimpleElementFactory.getInstance().createSortCondition(sortKey));Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-38735386280891197792007-09-18T07:43:00.000-06:002007-09-18T07:43:00.000-06:00This seems straight forward; however, I have been ...This seems straight forward; however, I have been unable to apply this to a simple case I'm working on. <BR/><BR/>"importPackage( Packages.org.eclipse.birt.report.engine.api.script.element );<BR/><BR/>var sortCondition = StructureScriptAPIFactory.createSortCondition();<BR/><BR/>sortCondition.setKey("row[\"Personnel_Services\"]");<BR/><BR/>sortCondition.setDirection("asc");<BR/><BR/>this.addSortCondition(sortCondition);"<BR/><BR/>The variable sortCondition winds up as type SortConditionImpl and the table (MultiRowItem) expects the ISortCondition type. Exception is:<BR/>org.mozilla.javascript.EvaluatorException: Can't find method org.eclipse.birt.report.model.simpleapi.MultiRowItem.addSortCondition(org.eclipse.birt.report.engine.script.internal.element.SortConditionImpl).<BR/><BR/>Any thoughts would really help me out.Unknownhttps://www.blogger.com/profile/00496035277443266832noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-86578955288318091142007-08-18T16:20:00.000-06:002007-08-18T16:20:00.000-06:00What you are talking about doing is called a drill...What you are talking about doing is called a drill down report. What you do is on the data element int he report with your customer informat, under the properties tab, go to the Hyperlink section. Change the Link To option to Drill Through. From there, you select your other report, and specify which data elements and report parameters go with the target reports parameters. Be sure that you have a parameter in the target report with the customer id in order to filter that data. Once done, you can run the report with the employee information and click on the link and pull up the detail information. <BR/><BR/>Hope that helps. Ill try to write an article explaining how to do that in the next few days.<BR/><BR/>JohnJohn Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-67586222182345077012007-08-18T06:49:00.000-06:002007-08-18T06:49:00.000-06:00I want to link two reports with conditions. e.g. I...I want to link two reports with conditions. e.g. In one report i have list of the accounts and in another report i have account details. Now when i'' click on any account from the list i want to display only account details which is clicked..Anonymousnoreply@blogger.com