I'm trying to restrict the data in my report to the past 7 days. Possible?
figured it out!
added an expression to the container, IF(NOW()-SHIPDATE>6,"N","")
then brought that field into the pivot table and wrote a macro to sort out the "N"'s
add the where in your container statement
Where DATEDIFF(day, SHIPDATE, Getdate()) <7