BIRT Exchange Forum: BIRT Exchange Forum -> Michael's BIRT Blog

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. School is out for many, so we might have a lull in forum traffic, over the summer, as people head off on vacation. Only time will tell. The forums are still busy, so far! As always, thanks to those users who help answer questions! It is a great help to the community!

The unanswered post I'll cover, this week, is about truncated text in Word output when dynamically hiding columns. The poster is having issues when they hide columns in their report and export to Word. The output is fine, if they don't hide the columns, but if they do there is truncated text. If anyone has experienced this issue or has a suggestion for the poster to try, please post in the forum thread!

The next topic I'll cover, this week, is about creating multiple rows out of a dataSet that has a SSV field for a column. The poster had a dataSet that had a SSV field, i.e. 234;227;24;86, that they wanted to turn into multiple rows. In the example field above, it'd be 4 rows, with all other data fields repeating, for each row. A solution is attached in the thread that uses a scripted dataSet to achieve this result. The data from the first dataSet is stored into arrays, then the scripted dataSet separates the original data into separate rows.

The last topic I'll cover, for this week, is about overlaying charts across a grid. The poster wanted to have a couple grid columns with pie charts "laying across them", so they laid over the grid border lines. A solution is provided that uses grids, cell borders, and merged grid cells to make it appear that the chart is overlaying the grid. The example can be found in the forum thread.

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.