Mahfooz546 Posted July 6, 2018 Share Posted July 6, 2018 I am creating a report in which i am calculating subtotal, and other calculations of records which are in detail band please tell me how i can do it, I am calculating subtotal of first 4 records by adding them and I am calculating subtotal in summary band.HOA Senior Manager182 18233 6455 324 227 525 2410 9I want to sum first 4 records, these records are in detail band.Subtotal = 182+33+55+4+7 Link to comment Share on other sites More sharing options...
hozawa Posted July 7, 2018 Share Posted July 7, 2018 Create a new variable. In the properties for this variable, set "Calculation" to "Sum" Link to comment Share on other sites More sharing options...
Mahfooz546 Posted July 13, 2018 Author Share Posted July 13, 2018 @hozawa but how I can identify the records in variable, there are 8 records in the detail bands and I want the sum of first 4 records 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