The scenario is this:

It is currently January and I am creating a spread report for March seasonal violation count.  I have to report my BOD limits for the month of March and only the month of March so my Limits on my BOD variable look like this:

Limit Name	Start Date	End Date	Description	Current Limit
DMAX	01-Mar-14	31-Mar-14	Daily Maximum Limit	> 3
DMAX	01-Mar-13	31-Mar-13	Daily Maximum Limit	> 3
DMAX	01-Mar-12	31-Mar-12	Daily Maximum Limit	> 3
DMAX	01-Mar-11	31-Mar-11	Daily Maximum Limit	> 3

The issue:

I go into Spread Report Design and select Locate > Number of Violations and nothing appears.

The work around:

Two of the most common limit violations and their formulas are as follows (using 99 as VarNum, change to your VarNum):

Limit Violation Description	Spread Report Formula
Daily Maximum Limit	=VIOL(99,"V","None","DMAX")
Monthly Average Maximum Limit	=VIOL(99,"M","AVG","MMAX")

I can copy the Spread Report Formula above to my report, and change the variable number 99 to the variable I need to report on.

For more on formula VIOL, see KB article Q10697