TechnologiesAIProductsAI & Analytics

Last Week in the Forums: Using Data from Two DataSets in One Table, Adding a Table of Contents Listing

This blog series takes a look back at the past week in the forums, recalling how active they were and highlights some of the questions asked that seem to frequent the forums or other interesting topics. The forums have been busy, busy, busy to start off the second month of the new year. Many good questions being asked, and, as always, thanks to those members who are helping answer questions. It is a great help to the community!

The first topic I’ll discuss from the forums this week is about using data from two dataSets in a single table. The poster wanted to have the first two columns in a table be from one dataSet and the third column to be from another dataSet. There are several ways to achieve something like this. One would be to create a joint dataSet within BIRT, joining your two dataSets on a shared field. Another option would be to do a union in your SQL query, which is essentially the same as the joint dataSet, only you don’t have to worry about BIRT processing the data, so it’s much quicker to it this way. A third option would be to embed a table into the third column of the first table and link the two tables using a filter or using dataSet parameter binding. In this case, the poster chose to join the data in a union in their query.

The next question I’ll cover this week is abouthow to add an item from your report to your TOC. The poster wanted to add the labels from their report to the table of contents, but didn’t know how. There is a property in the property editor for table of contents. All you have to do is add the expression of the label’s contents in the Table of Contents expression builder, like:


And you will get a new item in your table of contents for this.

The last topic for this week asks if the designer can be embedded into an application. The poster wanted to know if it was possible to embed the Eclipse BIRT designer into their application. The viewer can be easily used from another application through URL’s and such or by using the API’s directly. However, the designer would be much harder to embed in your application unless your application was an Eclipse RCP application. The reason for this is that the user interface and such of the designer is very heavily based on the Eclipse platform and eclipse plugin structure, as stated in the thread linked above.

Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment. 

Show More


OpenText is the leader in Enterprise Information Management (EIM). Our EIM products enable businesses to grow faster, lower operational costs, and reduce information governance and security risks by improving business insight, impact and process speed.

Related Posts

Back to top button