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

Group starting at end of page

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

    Group starting at end of page

    When running a report created in Alpha 5 Version 5 , a glitch in the handling of Groups and Detail sections was noted. What happens is that when a Group heading prints as the last line on a page and the Detail section should print
    starting on the following page , instead , the Detail prints starting at the top of the same page. Thus , what should be 2 pages prints as one jumbled page. We could not locate anything that would solve this , so to circumvent this , we have to add in dummy records to force the Group to start on the next page.

    Is there a solution for this? Or is this something that needs to be fixed in the program?

    #2
    RE: Group starting at end of page

    Jeff

    That's pretty wierd...

    Can you zip up the database and attach it to a message for us to look at?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.
    "Make it as simple as possible, but not simpler."
    Albert Einstein

    http://www.iadn.com/images/media/iadn_member.png

    Comment


      #3
      RE: Group starting at end of page

      The database is at the business owned by a friend. When I was there Monday figuring out why the report problem occurred , I did backup the database as it was at the time. I'll contact him and have him email me the Zip file Wednesday.

      I know that you can set the parameters so that Groups will not split between pages. However , as there some groups longer than a page , that won't work. I would have thought that the program would print the Group header on the page and continue the Detail on the next page. Guess not.

      Comment


        #4
        RE: Group starting at end of page

        Jeff

        It normally works well. Need to find what makes your circumstance different.

        20 questions can be fun, too time consuming. Posting the app is much faster to diagnose.
        Al Buchholz
        Bookwood Systems, LTD
        Weekly QReportBuilder Webinars Thursday 1 pm CST

        Occam's Razor - KISS
        Normalize till it hurts - De-normalize till it works.
        Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
        When we triage a problem it is much easier to read sample systems than to read a mind.
        "Make it as simple as possible, but not simpler."
        Albert Einstein

        http://www.iadn.com/images/media/iadn_member.png

        Comment


          #5
          RE: Group starting at end of page

          The backup file for the database is attached.

          Know what you mean about 20 questions. I volunteer in the HELP2000 Forum on CompuServe and assist users there. Sometimes you have to nearly drag info out of some users.

          Comment


            #6
            RE: Group starting at end of page

            Jeff

            I was able to stop the print overlap by expanding the size of the group 1 header.

            Some how the height was set to .094 inches and the field object CLASS was hidden. While it did show in the overlapping print, it was apparently the problem.

            I expanding the header enough to show the field and moved the field up to the top of the header.

            Try adjusting that on your database and see if that helps.

            Didn't check much beyond that. It looked pretty good to a non critical eye after the adjustment.
            Al Buchholz
            Bookwood Systems, LTD
            Weekly QReportBuilder Webinars Thursday 1 pm CST

            Occam's Razor - KISS
            Normalize till it hurts - De-normalize till it works.
            Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
            When we triage a problem it is much easier to read sample systems than to read a mind.
            "Make it as simple as possible, but not simpler."
            Albert Einstein

            http://www.iadn.com/images/media/iadn_member.png

            Comment


              #7
              RE: Group starting at end of page

              Tried out the changes and the report came out fine with the database in the present state. However , as the stock availability changes every week , just to be certain the change would work if another section had more items in it , I flagged a few more in the database under the CLASS called "Barbs". Unfortunately , the same problem occurred as before. The Class Header printed as the last line and instead of going to the next page to start the Detail section , it printed starting from the top of the same page.

              Comment


                #8
                RE: Group starting at end of page

                Jeff

                You have keep together on a page set for the detail region.

                You also need to do it for the group.

                Report in design mode, from the menu - report - properties - group properties - group 1 - OK - region tab - Keep group together on page (should be checked)
                Al Buchholz
                Bookwood Systems, LTD
                Weekly QReportBuilder Webinars Thursday 1 pm CST

                Occam's Razor - KISS
                Normalize till it hurts - De-normalize till it works.
                Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                When we triage a problem it is much easier to read sample systems than to read a mind.
                "Make it as simple as possible, but not simpler."
                Albert Einstein

                http://www.iadn.com/images/media/iadn_member.png

                Comment


                  #9
                  RE: Group starting at end of page

                  We had the "keep together on a page" option set for the Group , but instead of the report being 4-5 pages , it was 6-7 pages. Many pages ended up only half filled as the next Group would not fit the page. Also , what happens when a Group is longer than a page? That can happen (and has) with some of the sections.

                  Comment


                    #10
                    RE: Group starting at end of page



                    Jeff McKee wrote:
                    -------------------------------
                    We had the "keep together on a page" option set for the Group , but instead of the report being 4-5 pages , it was 6-7 pages.

                    ThenI would suggest that you use the continuation page for the group have have something like

                    CLASS cont'd

                    as the continuation header. That will fill up the page as much as possible.


                    Many pages ended up only half filled as the next Group would not fit the page. Also , what happens when a Group is longer than a page?

                    It prints a whole page and worries about the remaining portion as a separate partial page.

                    That can happen (and has) with some of the sections.
                    Al Buchholz
                    Bookwood Systems, LTD
                    Weekly QReportBuilder Webinars Thursday 1 pm CST

                    Occam's Razor - KISS
                    Normalize till it hurts - De-normalize till it works.
                    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                    When we triage a problem it is much easier to read sample systems than to read a mind.
                    "Make it as simple as possible, but not simpler."
                    Albert Einstein

                    http://www.iadn.com/images/media/iadn_member.png

                    Comment


                      #11
                      RE: Group starting at end of page



                      It prints a whole page and worries about the remaining portion as a separate partial page. Clarification - It then works with the next group to see if both will fit on one page. So it prints the whole page(s) and then continues on with the next group and tries to keep the groups together on a page if it can.

                      I think you'll prefer the continuation header.
                      Al Buchholz
                      Bookwood Systems, LTD
                      Weekly QReportBuilder Webinars Thursday 1 pm CST

                      Occam's Razor - KISS
                      Normalize till it hurts - De-normalize till it works.
                      Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                      When we triage a problem it is much easier to read sample systems than to read a mind.
                      "Make it as simple as possible, but not simpler."
                      Albert Einstein

                      http://www.iadn.com/images/media/iadn_member.png

                      Comment


                        #12
                        RE: Group starting at end of page

                        What do you mean by "continuation header"? I'm quite new with the program.

                        Comment


                          #13
                          RE: Group starting at end of page

                          Jeff

                          There are a couple of continuation headers. The one I'm refering to is part of the group properties.

                          Attached is an image of it.

                          I'd suggest that you look at the learning center of Alpha to get some of Jim Chapman's tutorial's, the other great doumentation that is linked by that page, the Alpha newsletter, and Peter Wayne's learn alpha.com site to help with all of the options that are available with the Alpha 5 development system.
                          Al Buchholz
                          Bookwood Systems, LTD
                          Weekly QReportBuilder Webinars Thursday 1 pm CST

                          Occam's Razor - KISS
                          Normalize till it hurts - De-normalize till it works.
                          Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                          When we triage a problem it is much easier to read sample systems than to read a mind.
                          "Make it as simple as possible, but not simpler."
                          Albert Einstein

                          http://www.iadn.com/images/media/iadn_member.png

                          Comment


                            #14
                            RE: Group starting at end of page

                            I use the tutorials whenever a problem that I cannot figure out from the docs occurs. This one dose not seem to be addressed.

                            I have tried all of the suggestions and , while they work on the snapshot of the database from last week , they fail with the database as it is this week. Being a tropical fish business with variable stock items from week to week , each group can vary in size each week. Even something as simple as having 3 more Barbs or other fish in the early groups can cause the problem. This is how I varify that the changes will work - I add in a few items.

                            It still looks to us on this end like a quirk in the program itself. If a group header prints as the last line on a page , one of 2 things should happen:

                            - the detail prints as normal starting at the top of the next page

                            - the group header is automatically moved to the top of the next page and printing continues as normal

                            Comment


                              #15
                              RE: Group starting at end of page

                              I ran into this recently, or something akin to it. As I recall I had to continue to experiment with different combinations for the header, the continuation header, and the group where I had to try different combinations of keep together and don't keep together for one or all of the possibilities.
                              Cole Custom Programming - Terrell, Texas
                              972 524 8714
                              [email protected]

                              ____________________
                              "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

                              Comment

                              Working...
                              X