Custom Expressions in JRS Report Builder
On the format results tab in JRS Report Builder there is a button to add a Custom Expression: But what does it do and how do you use it ? The first thing to understand is that custom expressions are written in the language of the data source: Data Warehouse: SQL Lifecycle Query Engine: SPARQL They are a great way of adding data to your report that isn't directly reportable. The easiest way to understand it is by example. Let's say you are reporting on requirements in DOORS Next and those requirements have two attributes: Let's say that in the report you want a sum of those attributes. Sure you could add a third custom attribute into the requirements module and then write some java script to populate it, but instead calculating it dynamically as part of the report is surprisingly easy. First create the report as normal and add the two custom attributes as columns. Then click Add Custom Expression to add another column that will be populated by your expression. In this ...