Alpha Video Training
Results 1 to 8 of 8

Thread: Blank Space in report

  1. #1
    Member
    Real Name
    Edward Schwartz
    Join Date
    Oct 2000
    Posts
    31

    Default Blank Space in report

    I'm surether must be a simple way to do this, but I can not figure it out. Can anyone tell me how to eliminate the extra blank space on reports when a field such as FIRSTNAME and LASTNAME are places next to eachother? I know it works when I set up a letter, but can not figure out how to do it so the report does not have a lot of extra spaces in it.

    Thanks for the help
    Edward Schwartz

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Blank Space in report

    Edward,

    When your field is, say, twenty characters wide and you store the name Sam in the field, Alpha stores it as "Sam&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp".

    To get a first and last name field to display correctly you have to trim off the trailing spaces:

    rtrim(first_name_field)+"&nbsp"+rtrim(last_name_field)

    Stan

  3. #3
    Member
    Real Name
    Edward Schwartz
    Join Date
    Oct 2000
    Posts
    31

    Default RE: Blank Space in report

    Thanks for your answer. How exactly do I integrate this function in the report? I have little experience with Alpha.

    Edward

  4. #4
    Member
    Real Name
    Paul French
    Join Date
    Apr 2000
    Location
    Iowa
    Posts
    702

    Default RE: Blank Space in report


    While in design mode, select the View menu.

    From the View menu, select DragDrop List.

    The DragDrop List will open on your screen. Click your mouse cursor on the New Calc/Summary Field item and drag it to your report and release the mouse button. A dialog box will open where you enter a name for this calculated field. Type in something like FullName.

    In the Expression line, type the formula you want, or click on the x-y symbol at the end of this line to open the expression editor which allows you to drag and drop to create your formula and also test it on data you have already entered.

  5. #5
    Member
    Real Name
    Edward Schwartz
    Join Date
    Oct 2000
    Posts
    31

    Default RE: Blank Space in report

    Paul and Stan-
    Thanks for the extra clarification. I was able to do it and it works great. I can't thank you enough for stopping to share your expertise with me. With much appreciation--

    Edward Schwartz

  6. #6
    Member
    Real Name
    robert adler
    Join Date
    Apr 2000
    Location
    Boynton Beach, BL
    Posts
    591

    Default RE: Blank Space in report

    Ed:

    firstname-" "+lname will concatenate the two fields and trim the spaces from the firstname field.
    this is another method to using the trim, rtrim, ltrim and alltrim commands.

    bob

  7. #7
    "Certified" Alphaholic
    Real Name
    jim chapman
    Join Date
    Apr 2000
    Posts
    1,779

    Default RE: Blank Space in report

    Hi Ed,

    If you place a rich text object on the report and then drag and drop the fields into the rich text object, A5 will automatically take care of many of these detail (such as trimming, extra blank line removal, etc).

    The rich text object will allow much more and easier formating of text.

    Jim

  8. #8
    Member
    Real Name
    Edward Schwartz
    Join Date
    Oct 2000
    Posts
    31

    Default RE: Blank Space in report

    Jim-

    Thank you so much for that idea. It was an amazingly simple solution to the problem. I'm glad I learned how to use the trim functions, before getting your input, but for my purposes in this report the ease of your solution can't be beat. I really am fascinated by the versatility and multiple ways to solve a problem. Thank you again for the education.

    Edward

Similar Threads

  1. Blank Space in Letters
    By julian lewis in forum Alpha Five Version 6
    Replies: 10
    Last Post: 08-18-2004, 05:50 PM
  2. Add blank space on right.
    By CALocklin in forum Alpha Five Version 4
    Replies: 7
    Last Post: 09-25-2001, 01:56 AM
  3. Blank space in report(last try!)
    By Jeff Moses in forum Alpha Five Version 4
    Replies: 1
    Last Post: 10-02-2000, 08:08 PM
  4. Blank report space?
    By Jeff Moses in forum Alpha Five Version 4
    Replies: 0
    Last Post: 10-02-2000, 07:21 PM
  5. Insert A Blank Space
    By Thomas Holt in forum Alpha Five Version 4
    Replies: 12
    Last Post: 06-06-2000, 07:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •