My inclination was to use a main report that calculated the 90th percentile value in a shared variable, then use that shared variable in the selection formula of a subreport (placed in the main report footer).

 

Whenever I do so, the selection formula of the subreport doesn't compile, saying the shared variable must be evaluated later.  I thought that was the point of having the subreport, but then again, subreports are new to me.  Any thoughts?

 

Thanks immensely,

 

Jeremy

In any case, with some advice from a collegaue I got it to work.  I removed the shared variable, and simply used the PthPercentile function in a formula in the main report without declaring a variable.  I created a parameter in the subreport.  In the subreport links, I used the PthPercentile formula field as the field to link to and set the newly created subreport parameter.  Then I referenced the parameter in the subreport selection formula.  Voila, my results included only records less than the 90th percentile!

 

Sorry if this is real elementary - this is my first need to filter records based on a calculation evaluated within a report....