kevin15k Posted February 2, 2011 Share Posted February 2, 2011 During evaluation time I want to compare current row with the next row in my resultset. I am doing this since I only want to show a horizontal line when the orderID changes. For example if my result set looks like:OrderID555555555555556I only want to show the line after the last 555 so I need something to compare current OrderID with the next one coming up in the result set. Crystal reports had this functionality with a next() and previous() function.Post Edited by kevin15k at 02/02/2011 17:19 Link to comment Share on other sites More sharing options...
cbarlow3 Posted February 2, 2011 Share Posted February 2, 2011 What you need to do is to add a GROUP to your report based on the OrderID and specify that you want a group footer. In the group footer, just put a line at the very top of the footer and then reduce the height of the footer to practicaly nothing.Carl Link to comment Share on other sites More sharing options...
kevin15k Posted February 2, 2011 Author Share Posted February 2, 2011 Thank you Carl. I went into my report inspector, and apparently I already had a group named OrderID, must have created it with the report wizzard in the beginning, just right clicked on that and hit Add Band and it added it for me. Put the line in there and shrank the band and it seems to work. Thanks. 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