Jul 06 2007

How many values were picked from a list?

Categories: Report Techniques, Variables! Dave Rathbun @ 1:06 pm

The Challenge

It is not uncommon for a report writer to want to know how many items were selected from a prompt. The challenge is that there really isn’t a way to do that, at least not one that is available as a function. So this article will show an interesting way to solve that challenge. It is not my original idea; it came from a post on BOB. At the moment I cannot find the post in order to give credit to the original author.

In a nutshell what is required is as follows:

  • Capture the user’s response to the prompt
  • Count the number of semi-colon characters found in that string

Continue reading “How many values were picked from a list?”