tag:blogger.com,1999:blog-16506996.post4445278159565179819..comments2024-02-08T01:57:07.944-07:00Comments on The Digital Voice: BIRT: Using the Design Engine API and Open LibrariesJohn Wardhttp://www.blogger.com/profile/10741149622435353727noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-16506996.post-54350356124134699722011-02-15T19:15:52.693-07:002011-02-15T19:15:52.693-07:00Hi John,
Actually the report is created earlier o...Hi John,<br /><br />Actually the report is created earlier on so my program only needs to run over the report and display all the info in the report. If i use the one that you shows me, then it's like creating a new Data Report Item, am i right?<br /><br />Another way of getting value expression of the data is extracting the data column binding of the (parent/main) table. I tried this method but i face great difficulties...<br /><br />Do you mind showing me how to extract the data column binding of a table?<br /><br />Thanks.Cassandrahttps://www.blogger.com/profile/16851847931451226188noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-72144455643228002712011-02-11T11:24:55.840-07:002011-02-11T11:24:55.840-07:00This is already in the example. The lines with:
f...This is already in the example. The lines with:<br /><br />for (Iterator i = columnList.iterator(); i.hasNext();)<br /> {<br /> String columnName = (String) i.next();<br /> <br /> ComputedColumn computedColumn = StructureFactory.createComputedColumn();<br /> computedColumn.setName(columnName);<br /> computedColumn.setExpression("dataSetRow[\"" + columnName +"\"]");<br /> PropertyHandle computedSet = reportTable.getColumnBindings( );<br /> reportTable.getColumnBindings().addItem(computedColumn);<br /> <br /> //add new data item and cell<br /> DataItemHandle data = reportDesign.getElementFactory().newDataItem(columnName);<br /> data.setResultSetColumn(columnName);<br /> CellHandle cell = (CellHandle)detailRow.getCells().get(x);<br /> cell.getContent().add(data);<br /> x++; //advance position<br /> }<br /><br />That is creating the Table Binding, and creating a Data Report Item that references those Table Bindings.John Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-33845377890699904722011-02-01T02:52:15.166-07:002011-02-01T02:52:15.166-07:00Hi,
I have all the datasets and data that i need ...Hi,<br /><br />I have all the datasets and data that i need in a rpt report but if a data is not binded to a dataset then its value expression cannot be displayed.<br />So, could u please kindly show/ guide me in binding the data to its dataset so i can display the value expression?<br /><br />Thank you!Cassandrahttps://www.blogger.com/profile/16851847931451226188noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-31884147733635724242009-11-16T08:26:33.648-07:002009-11-16T08:26:33.648-07:00So cool thank you :)So cool thank you :)Alp Yogurtcuoglunoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-40988924441443957822009-03-25T00:03:00.000-06:002009-03-25T00:03:00.000-06:00Eugene,Let me know if you are still having issues....Eugene,<BR/><BR/>Let me know if you are still having issues.<BR/><BR/>JohnJohn Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-49969606495278640802009-03-23T23:28:00.000-06:002009-03-23T23:28:00.000-06:00Hi John,Thanks for helping me out today at eclipse...Hi John,<BR/><BR/>Thanks for helping me out today at eclipsecon 2009! I am having some problems with the the code you have posted here. I am trying to execute this code through a wizard on the init method, just to see if it will work, and the code keeps failing here:<BR/><BR/>IDesignEngineFactory factory = (IDesignEngineFactory) Platform<BR/> .createFactoryObject(IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY);<BR/><BR/>the factory always comes back null. Do you have any quick suggestions? Perhaps you can contact me tonight or tomororw?<BR/><BR/>Thanks in advance,<BR/>-EugeneEugenehttps://www.blogger.com/profile/16752132957368813617noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-28412216384641245842009-03-14T19:23:00.000-06:002009-03-14T19:23:00.000-06:00Sorry for the delay in response. I've been kind of...Sorry for the delay in response. I've been kind of in a funk in terms of blogging over the past few months. I hate prepping for conferences.<BR/><BR/>To answer your question, it's right there in the example. <BR/><BR/>dataSetHandleToUse.getCachedMetaDataHandle().getResultSet().iterator<BR/><BR/>Hope that helps.<BR/><BR/>JohnJohn Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-82157045087626786012009-03-04T08:03:00.000-07:002009-03-04T08:03:00.000-07:00I found your article very helpful.I wanted to add ...I found your article very helpful.<BR/><BR/>I wanted to add some columns to a pre-existing dataset but could not figure out how to iterate over the static columns from the javadocs.Eric Njoguhttps://www.blogger.com/profile/16457514551214542630noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-56240118156529412562008-12-10T21:55:00.000-07:002008-12-10T21:55:00.000-07:00Hello All, I am newbei to BIRT. I do load data fro...Hello All, <BR/><BR/>I am newbei to BIRT. I do load data from a pojo model and show it in reports. This works for a sample examples found in internet. <BR/><BR/>In my case, Running RCP application with model built completely by using EMF relfection API and I donno how to invoke those from a javascript and hence I populate to a dummy list and give it to the Birt to generate reports.<BR/><BR/>I have copied all the jars referred in the classes under<BR/>eclipse\plugins\org.eclipse.birt.report.viewer\birt\WEB-INF\lib<BR/><BR/>There are No errors, but data is not getting populated in viewer.<BR/> <BR/>I Appreciate for any posssible solution. <BR/><BR/>Regards,<BR/>RamapriyaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-22001812433714658192008-05-13T02:10:00.000-06:002008-05-13T02:10:00.000-06:00Hi to allvery good aproachHi to allVery good appro...Hi to all<BR/>very good aproach<BR/>Hi to all<BR/>Very good approach!<BR/>I’m learning how to build reports with birt 2.2. I’m working with myeclipse 6.0.1 GA<BR/>Is it possible to add a column to a dataset using javascript? I m not talking of <BR/>“computed columns”. I want to build using another column using a formular similar to this<BR/><B><BR/>amount = 23790;<BR/>i = 0;<BR/>curr2 = new Array(); //is the new column I want to build<BR/>While ( tmp = fetch(mydataset) ){<BR/> my_cur = tmp[“cur”]; //cur is a column of the dataset, and my_cur the current element of the column<BR/> val = amount / my_cur;<BR/> amount -= val * my_cur;<BR/> curr2[i++] = val ; //adding an element to the new column<BR/>}</B><BR/> <BR/>Have a nice day<BR/>surf_dgm at yahoo dot comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-26661775955362564132007-12-11T15:12:00.000-07:002007-12-11T15:12:00.000-07:00Sorry for the delay in response.There are a number...Sorry for the delay in response.<BR/><BR/>There are a number of different ways to obscure the actual report file. I suppose that it may not be a good idea to display the report file in a URL< but I have yet to see anyone exploit it, although it may not be that difficult. I suppose it would be possible to build a report mapping into the Web Viewer, then you would just pass in a report ID rather than the path to the report to run.<BR/><BR/>As far as the database conneciton string, you could build a event handler for the Data Source that would populate that connection string based off of some sort of logic. There is also the connection pooling, which I havent worked with myself, however Jason Weathersby and Scott Rosenbaum over at BIRTWorld wrote an article about a few months back.<BR/><BR/>JohnJohn Wardhttps://www.blogger.com/profile/10741149622435353727noreply@blogger.comtag:blogger.com,1999:blog-16506996.post-62322802929235696362007-11-03T07:51:00.000-06:002007-11-03T07:51:00.000-06:00Hi,Its nice to meet a BIRT enthusiast. Well i am t...Hi,<BR/><BR/>Its nice to meet a BIRT enthusiast. Well i am trying to be one. I am actually working with BIRT and kinda just starter. <BR/><BR/>I am able to make BIRT reports through Eclipse IDE, but when I need to deploy the reports I am stuck up. I don't know where BIRT reports will fetch the Database connection string and database related information. I am looking to generalize that Database connection issue, rather hard code any where in report. !!! <BR/><BR/>Secondly, I need to understand how to deploy them into the web application. Will it be wise to just give a link for the BIRT reports in .jsp pages? <BR/><BR/>I would appreciate if you could tell me how that could be possible. <BR/><BR/>Thanks,<BR/>PranavPranav Aggarwalhttps://www.blogger.com/profile/03218312035990296702noreply@blogger.com