Jump to content
Sign in to follow this  
bradford

Reset count (running total) after pagebreak

Recommended Posts

I created a report that summarizes students on different buses. (It's for a school attendance.) I find that no matter how I define a calculation I am still stuck with the same result---the same result I get when I add @@ to the layout, just numbers that go up that don't restart. I want to see a running total of each student on the bus. When the page breaks for the next occurence I want to have the numbers reset. I have searched the web as well as this forum for an answer. For the record I don't think it's an easy one.

Share this post


Link to post
Share on other sites

If you have a Bus_ID, then why not use a SelfjoinOnBusId, with your Bus_ID at both sides of a relationship within the same file.

Then c_countPerBus = Count(SelfjoinOnBusId::Student_ID*)

* or any other field you have.

Share this post


Link to post
Share on other sites

Ugo, I like that example. It really puts in some cool things about ID# that I didn't know you could do. Thanks.

Share this post


Link to post
Share on other sites

since I am on the subject, I have made a report for attendance. It is sorted first by day, then time then class_id. My problem is that it is breaking the body when the page finishes and continues on the next page. Is there a way to not let is break it? so if the body doesn't fit it will continue it on the next page? I know there is the part function that page beaks after each occurrence but that isn't what I need. If I did that, then I would have 20 pages for a single day. A little too many sheets for my books. Any advice would be helpful.

Thanks for everything.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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