Joined: 06 Oct 2009
Online Status: Offline
Posts: 4
Topic: Report Filter Posted: 28 Oct 2010 at 9:07am
We have a report that generates multiple detail lines for an individual and the count of those lines goes in the group footer. the person who uses the report wants to be able to filter the report based on the count in the group footer. For example if there are 4 or more detail lines then the user wants to see that entry but if there is less than 4 detail lines the user doew not want to see that entry. Is there a way to do that and how do we let the user enter that value.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 28 Oct 2010 at 9:49am
If your Count is created using the COUNT function at a group level you can use a group select statement to filter.
Create a param as numeric then in the select expert toggle to the group statement and enter your criteria there
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
