TechnologiesAIProductsAI & Analytics

Last Week in the Forums: Hyperlink in Only Certain Cells of Crosstab, Aggregate Average on Crosstab

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. I’ve missed the last several weeks of posting because of being at the hospital with my wife after complications from the delivery of our daughter. My time has been spent just trying to keep up in the forums. The year has been off to a fairly steady start in the forums. As always, thanks to those members who are helping answer questions in the forums. It is a great help to the community, especially with my being in and out over the past several weeks!

The first topic I’ll cover this week is how to have hyperlinks in only certain cells of a crosstab. The answer given for this was to remove the measure element in the crosstab and add a text element of type HTML and use the value-of tag to build url’s for the value you want a hyperlink for and to not build a hyperlink for other values.

The next topic for this week is how to have an aggregate average over a crosstab row. The answer given for this is to click on the icon next to the dimension, click on “total” and use the aggregation of average for the crosstab row.

The last topic for this week is about displying a “NO DATA” label when no data is returned. There were two possibilities given that work for this. One is to create a computed column in your dataSet with the aggregation of runningcount. You can then set visibility statements that check if a value exist for the computed field. If it doesn’t, you show or hide the elements appropriately. The other option is to initialize a variable in the initialize of your report and increment it in the onFetch method of your dataSet. If there are no rows, the value will not be incremented and then you can perform the same visibility statements to hide/show the elements with this value.

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