TechnologiesAIProductsAI & Analytics

Last Week in the Forums: Adding a Calculated Measure in a Crosstab, Page n of m Auto Text Spacing

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 month of the year now and the forums are very busy! A huge thanks goes out to those members who are helping answer questions in the forum. It is a great help to us moderators and the community!

The first topic I’ll cover this week is how to add a computed measure in a crosstab row. This can be done by simply clicking on the icon next to the measure in your crosstab and choosing to add a derived measure. The expression builder gives you the ability to create a computation using the values from the row.

For the next topic, the poster had an issue with the spacing of the auto text “page n of m” element in PDF. The problem was that the spacing between the word “page” and the n page number had to be enough to fit multiples of 10 or 100 if there were that many pages, the spacing didn’t self adjust. The solution given was to use a page variable to store the current pageNumber value and a report variable to store the page total of the report, then to place these values in-line in the masterpage footer, rather than using the auto text element.

The last topic for this week is about assigning a name to a dynamically created report item. The poster wanted to be able to name their dynamic element so that they could access it by name rather than having to know the element ID. The answer given for this was to grab the element and then use the setName(“StringName”) function to give it a name.

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