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

New to Alpha 5

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

    New to Alpha 5

    We just converted from Alpha 4 to Alpha 5. I've created a report to print quotations for our customers. My problem is there is a huge gap between each line item. I'm sure there is something easy that I can't seem to find. Can anyone give me advice as how to make it print without these extra blank lines between each item? I need it to look like single-spaced.
    Thanks, any help would be appreciated.
    Linda Moore

    #2
    RE: New to Alpha 5

    Linda:

    In the report editor, detail section, close the white above and below the detail fields. Make sure that the field height is no greater than it has to be. Right click on a detail field and pick properties;dimensions. Height should be around .188 to .200 - set it there if you have to.

    Keep playing with it with 'Print Preview' to see how you're coming and save it when you get there.

    Ken the Newbie
    [I'm sure one of these board Guru's wil come up with a better idea - you see I'm just a little less 'new' than you.]

    Comment


      #3
      RE: New to Alpha 5

      Thanks Ken. I'll try it and let you know how it works.
      I liked Alpha 4 a whole lot better.
      Thanks again
      Linda

      Comment


        #4
        RE: New to Alpha 5

        Well Ken,
        It didn't work. Let me know if you have any more suggestions. It's the only thing wrong with the whole report.
        Thanks again
        Linda Moore

        Comment


          #5
          RE: New to Alpha 5

          Linda,

          Move the curser to the bottom of the white 'Detail' section and when the curser turns to double arrow, drag that part to the bottom of the fields in the detail section. This will close the gap.

          kenn
          TYVM :) kenn

          Knowing what you can achieve will not become reality until you imagine and explore.

          Comment


            #6
            RE: New to Alpha 5

            Ken,
            I've done that. The detail section on the screen isn't much more than 1/2" in size but when I print there is about 2 " between the lines.
            Do you think I need to start over?
            Thanks
            Linda

            Comment


              #7
              RE: New to Alpha 5

              Sometimes forms and reports get corrupted and starting over is often much quicker than trying to figure it out.

              kenn
              TYVM :) kenn

              Knowing what you can achieve will not become reality until you imagine and explore.

              Comment


                #8
                RE: New to Alpha 5

                Is your report base on a set ? If so, anything printed from the parent table will print as many blanks as there are records in the child table.


                Alex
                Alex Levy
                Tampa, FL

                Comment


                  #9
                  RE: New to Alpha 5

                  You could try right clicking on the details section and selecting the option "shrink contents of the band"?

                  Regards

                  Glen Schild
                  Glen Schild



                  My Blog

                  Comment


                    #10
                    RE: New to Alpha 5

                    Do you have any groups? If there is a group break and the group header or footer has any space in it, this will cause the same problem.

                    If you can't find the problem and this is in one table (not a set), you can zip the files (.dbf, .cdx, .fpt, .ddd, .ddm, .ddx) and attach them with your message here. I guarantee somebody will look at them and help you out.

                    If it's in a set, you would have to include all the set files (.set, .sem, .sex) and all the files from each table in the set.

                    Recommendation: If there is a lot of data, make a copy of the files and delete most of the records before attaching it here.

                    Comment


                      #11
                      RE: New to Alpha 5

                      Linda,

                      You liked Alpha 4 better because you know how to use it. In reality, Alpha Five is far "better", because it is far more powerful and flexible. But that power, and the the innumerable options, require more learning. Understandably this can be frustrating at first. Gradually as you get the hang of it you will probably appreciate A5 for all it is. If you have been reading this board you are probably aware of the many avid A5 enthusiasts gushing with praise at every opportunity.

                      Peter

                      P.S. That is not to say A5 is perfect, it's not. But its damn good! Trust me.
                      Peter
                      AlphaBase Solutions, LLC

                      [email protected]
                      https://www.alphabasesolutions.com


                      Comment


                        #12
                        RE: New to Alpha 5

                        Hi Linda,

                        Have you set the detail properties to "shrink contents of band"? Right click on your details section, choose properties. Now on the region tab make sure "shrink contents...." is checked. If this still doesn't do it, my guess would be that you've got an object in this section that is either outside the 'borders' or is so small you are overlooking it. It is easy when placing objects on the report to click inadvertantly and actually place a very small object on the report. This is especially easy when placing conditional objects. The section will then remain large enought to encompass all the objects, even if there is nothing to print. One way to check for this is to click on a object in the section you are having trouble with. The object will be 'highlighted' by the little squares (handles) around the object. Now press the tab key and the 'highlighting' goes to the next object. Keep pressing the tab key and make sure you can see each and every object. If you have a small 'invisible' object it, in turn, will become highlighted and you can delete it.

                        As for liking A4 better, I know where you are coming from. I very much wanted to see Alpha Software come out with a windows version of A4. Well, in a way they did, A5. Now I wouldn't care to go back to A4. It was a wonderful tool, but wait until you get used to A5.

                        Good luck,

                        Jim

                        Comment


                          #13
                          RE: New to Alpha 5

                          The form is part of a set. Unfortunately, I don't know how to zip files. What it is, I have a customer table, and a bids table. We enter our bids in the "bids" data base and print the bids from the set consisting of the customer and bids tables. It worked fine in Alpha Four and that's why it's so puzzling now. I'll try all of your advice and let you know if it works. Thanks for the help/
                          Linda

                          Comment


                            #14
                            RE: New to Alpha 5

                            If that's what's happening, do you have any idea how to fix it?
                            Thanks
                            Linda

                            Comment


                              #15
                              RE: New to Alpha 5

                              Hey Jim...It worked...I had 2 RTF fields floating around that I didn't know were there. Thanks a bunch. Now, 1 more question if you don't mind.
                              I have and index by bid number. It is the default index. But when I tell the report to print and pick the bid number it comes up with "no records" I know the record is there because I entered it myself. Do you have any ideas on this?
                              I sure don't want to have to go "mark" and then "un-mark" everytime I need to print.
                              Thanks in advance
                              Linda

                              Comment

                              Working...
                              X