Adding an index based on a cross-tab

Friday 8 November 2013 @ 12:18 pm

Jamie Wiseman, one of the SAP bloggers, wrote up a clever way to create an index using a cross-tab and using the ‘Display String’ property. It uses some fairly complex formulas but I was surprised that he didn’t use any arrays. Instead he used a very long string of characters. By using the InStr() function to find the matching entry and page number he avoided the complexity of looping through arrays. Not simple, but simpler.

The second part of the post has to do with creating hyperlinks to take you to the index pages, but this only works if you are publishing this to CR Server or BOE. Still the index idea is pretty clever.

(For examples of my most popular formulas, please visit the FORMULAS page on my website.)

Leave a Reply

Recrystallize Pro