ProductsAI & Analytics

Last Week in the Forums: Maximum Columns for One Sheet in Excel Output, Can You Use More Than One Master Page For a Single Report Element

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. The forums stayed pretty steady this week as far as amount of questions asked. Many community members are available offering solutions to questions. The following are a few questions that were asked last week.

This question was about exporting to only 1 sheet in XLS. The person was having issues with their XLS output being split over multiple sheets and they wanted it to go to one only. They were having up to 365 columns. The answer to this was that the report had to be split over more than one sheet because Excel XLS file format only supports 255 columns, so this was not a BIRT issue.

The next question I’ll cover is about using multiple master pages within one table. The question asker wanted to have the first couple pages of their table be in portrait layout and the rest of the pages to be in landscape. The answer was that this is currently not a feature of BIRT. A single element can only have one master page, so to split it like this, two tables would have to be used with filters to limit the correct data to each table.

The last question I’ll cover this week is one about creating charts from the data in a list of CSV files. The issue was that the person had a “directory” of CSV files that they wanted to include in a list in their report and under each filename they wanted a couple charts for each file. So they wanted a table or list attached to the “directory” of flat files and in that table they wanted each row to access the data from the different flat file to create their charts. The solution to this was provided in an example in the devShare by Jason Weathersby.

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