Jump to content

Display Record Count FP 9.0


alta_flyer
 Share

This topic is 4317 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I know I have done this in the past but can't find my notes. Is there a simple method of displaying the running count of records grouped by category and resetting each time category changes.

i.e. DVD's grouped and sorted by category and title. Want the count to reset to 1 each time a new Category is displayed. I realize I can create a Script to run each time I use the report and create a field which is updated with the appropriate number but wonder is there an easier way. The option of using "Restart Summary for each Sorted Group" on the Summary field does not seem to be available.

Link to comment
Share on other sites

  • 1 month later...

I'm not sure about 9, but in 11 you would want to add a trailing subtotal to your table. Make sure you select "Count," and not "Running Count" since you want it to reset on Category changes. Then add a sub-summary section to your report on Category and make sure to sort the records before running it.

Link to comment
Share on other sites

This topic is 4317 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.