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. Forum traffic has been very high, as of late. EclipseCon is this week, so I'll be there, instead of in the forums. So, if you see a question you know the answer to, please feel free to provide your suggestions or solution. I'll be back, next week, though. As always, thanks to those users who help answer questions! It is a great help to the community!

The unanswered topic for this week is about creating custom group intervals for crosstabs. The poster has groupings they'd like to create in their crosstab so they can do aggregations over these groups. However, their groups are non-linear ranges. If anyone has created custom grouping ranges for crosstabs and has a suggestion or solution, please post in the thread.

The next topic I'll cover this week is about changing the title of the BIRT viewer. The poster wanted to change/remove the "BIRT Report Viewer" text from the title bar and page header. The solution to this is to simply use the __title URL parameter to assign a new value.

The last topic from last week is about changing colors by series in a chart. The poster wanted to know how they could specify a series to change the color of in their chart script. They knew how to change the color, just not how to do it only for a certain script. A simple snippet of code is included in the thread that should get this done.

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.

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. We're in the last week of the year! The BIRT Exchange forums have been quiet in the past week because of the holidays. I don't expect that they'll pick back up again until the beginning of next year! Many great questions and answers are being posted every day. As always, thanks to those users who help answer questions! It is a great help to the community!

The unanswered post from last week is about a coloring issue in an area chart. There isn't much explanation to go on for this issue. Two charts are shown in an attached image with different coloring. One showing the correct color and one showing different colors. The complaint is that the colors change depending on data order. If you've had an issue like this before, feel free to comment in the thread.

The second topic from last week that I'll cover is making all charts in a report have the same colors for shared categories. The series palette determines the color of the data points in your chart. The data points are colored in order based on the palette. If you have multiple charts with the same categories, but the charts are sorted in a way in which the categories aren't in the same order, the data points for each category will have different colors. An example in this thread will show how to use a simple script to provide custom coloring for each data point and legend item to match across all charts.

The last topic for this week is merging data in a joint dataSet. When you join two dataSets together, many times you'll end up with incomplete columns or two fields that you'd like to merge. To handle this issue, all you need to do is create a computed column in your new joint dataSet. In this computed column, you can fill in a default value for null values or if you want to merge two columns, you can check which column has data of the two columns you want to merge, and use that value as the output for the column.

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. I hope everyone has a safe New Year! See you in 2012!