On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.
Discussions
Include plain text or HTML file in report
One of the companies that uses BIRT want to include in their existing reports a doc files. The following solution is suggested to solve this problem: <br /> <br /> The report will read the data form the given Plain text or HTML file (parameter), and add it to the text widget. The widget will display the data in the correct…
How to join data sets
Using SQL to join queries can be complicated, to omit this use the data set join mechanism. This example report shows only how to join two data sets, the result can be joined again with another data set. Generally using the data set join mechanism, you can construct multiple join over the data sets.
How to replace DB connection parameters at run time
<p><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning /> <w:ValidateAgainstSchemas /> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility>…
How to Create Dataset Parameter
<p>DesignConfig config = new DesignConfig();<br />DesignEngine engine = new DesignEngine(config);<br />SessionHandle session = engine.newSessionHandle(null);<br />ReportDesignHandle design = session.createDesign();<br />ElementFactory elementFactory = design.getElementFactory();<br />OdaDataSetHandle dsh =…
How to Create Scalar Parameter
<p><span style="font-size: xx-small;">DesignConfig config = new DesignConfig();<br />DesignEngine engine = new DesignEngine(config);<br />SessionHandle session = engine.newSessionHandle(null);<br />ReportDesignHandle design = session.createDesign();<br />ElementFactory elementFactory = design.getElementFactory();<br /><br…
How to calculate subtotals per page
This example shows how to calculate column total per page and eventually the grand total. The page break interval is 10.
Create and use of JS functions
Define any js function in the initialize like:function myFunction(str){dosomething;}reportContext.setPersistentGlobalVariable("myFunction",myFunction);To use this function in script or in expressions just call:myFunction("str");
Combine reports
This examples shows how to combine HTML as well as PDF reports.
Create report dynamically
This example shows how to create a report using the api's.<br /> The data set will be created dynamically according to the data input.<br /> A table will be also crated dynamically and filled with the created data set elements.
