Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Repeating records on reports

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Repeating records on reports

    I know this probably a simple problem, but I am stuck on it. In a typical invoice typr application, I have a report designed which is a monthly sales report where all the invoices for 1 month are listed with a total. The problem is that I am getting a repeated of each invoice by the number of child records in the child table. I would like only 1 entry per invoice. Comments are appreciated.

    Thanks

    Alex Levy
    Alex Levy
    Tampa, FL

    #2
    RE: Repeating records on reports

    I think Tom covers it pretty well here.

    Msg ID: 25034
    Subject: RE: Multiple print problem
    Author: Tom Cone Jr
    Date: 08-02-2000 20:53
    File:

    Actually there are more than one.

    I often leave the set 'as is', but add a group break to the report, based on the linking field between the parent table and the child table.

    Then I put the fields from the parent table in the 'group header', and the fields from the child table in the 'group details'. Summaries, totals and counts I put in the 'group footer'. Grand totals covering all 'groups' in the report I put in the 'report footer'.

    You will find that if your report is based on a one-to-many set and you include fields from the parent table in the 'details' section of your report you see the values repeat over and over. By putting them in the group header you only see them once. Even though they are present 'virtually' in the set, since you don't put them in the details section, you never see them after the header prints.

    Hope this makes sense. Even if it doesn't, I recommend you experiment along these lines. I'm sure you'll be able to figure it out.

    -- tom



    There can be only one.

    Comment


      #3
      RE: Repeating records on reports

      The rule seems to be that any info in the detail section will print as many times as it occurs in the child table. So I added another group section and moved the invoice (parent) data to this section. In doing so, there are blank spaces left by the number of child records there are. Can this be compressed ?

      Alex
      Alex Levy
      Tampa, FL

      Comment


        #4
        RE: Repeating records on reports

        So do you still need to see the detail? If not, go to report properties, and anwer NO to does report have a detail section.

        Tom

        Comment


          #5
          RE: Repeating records on reports

          Alex, the rule is more complex than that.

          If the report is based on a set.
          If the set includes a one-to-many link.
          If the report has a details region.
          If fields from the parent table are placed in the details region - or -
          fields from the child table are placed in the details region.

          Then

          The parent and child table fields will be printed, for each child table that exists.

          To the observer it will seem as though the parent table fields are 'repeating'. However, the child table fields will not 'repeat', since it's likely each child table record is different. However, even the child records will be printed one after the other, as many times as there are child table records.

          Often the simplest fix is to define a group break based on a unique field in the parent table. then put the parent table fields you want to see in the group header region. then put the child table fields you want to see in the group details region.

          -- tom

          Comment


            #6
            RE: Repeating records on reports

            Alex,
            Put child table fields in a subreport. The parent will repeat 1 time in the report and all the child records for that parent will appear 1 time in the subreport.

            Comment


              #7
              RE: Repeating records on reports

              Yes, that is how I now undertsand the report generator to work. I also found out that unless "has detail records" is unchecked in the report properties, it will print blank lines for each number of child records in the table.

              This has been a change from the previous Alpha Four, version 6 where there was a setting in the range card for "unique" records. This makes sense now. I appreciate everyones input and thanks for the help.


              Alex Levy
              Alex Levy
              Tampa, FL

              Comment

              Working...
              X