I have this requirement where I have to create a report which takes a number as a cut off value and using that value, the number of students have score greater than it is calculated. Normally, with one value prompt, we get one result. Is it possible to generate multiple results in the +-2 range of the cut off value given?
Thanks in advance.
Quote from: ironfury on 14 Jun 2016 05:16:43 AM
I have this requirement where I have to create a report which takes a number as a cut off value and using that value, the number of students have score greater than it is calculated. Normally, with one value prompt, we get one result. Is it possible to generate multiple results in the +-2 range of the cut off value given?
Thanks in advance.
Hi,
A prompt simply sets a value into a variable. You can use that variable in as many different filters and calculations as you choose within your report. In this case, it looks like you simply need to change the syntax of your existing filter from
[score] > ?Your Parameter?
to
[score] between ?Your Parameter? -2 and ?Your Parameter? + 2
You'd then need to change your count to count the number of students within each score in the range.
Cheers!
MF.