burferd Posted July 18, 2007 Share Posted July 18, 2007 This should be an easy question to anyone who does reports frequently. I have a report that I am currently grouping on the "table" band. Under 'Group properties' I have the 'Group Expression' set to a field that is coming back from the database. This works fine, but I need to have the grouping be caused by either of two fields that come back from the database. How do I group by a change in more than one field? Thanks Link to comment Share on other sites More sharing options...
codyjasperForge Posted July 19, 2007 Share Posted July 19, 2007 Enter the two fields into a variable's expression. Base your group on the variable instead of either field. WHen the variable changes, the group will change. Tell me if this works...Hope it helps... Link to comment Share on other sites More sharing options...
rollinsruss Posted August 17, 2009 Share Posted August 17, 2009 It does indeed work and your suggestion is precisely what I needed! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now