Crystal Reports 2008 - Format field Spacing

Posted on 2012-09-05
Last Modified: 2012-09-13
I have a question about formating the field spacing in crystal reports, but I dont know if I can explain exactly what I mean.
When creating a report I have noticed the fields will probably not be aligned evenly when changing from Portrait to Landscape.

|FieldOne|   |FieldTwo| |FieldThree|         |FieldFour| ..... |FieldTen| and the rest of the page is blank and should be evenly spaced.

Is there a way to select all fields to have them all evenly spaced?

Just trying not to move each field individualy(way to time consumming)  

but maybe im just being lazy or havent found my Crystal report formating groove.  Is there any particular strategy that yall use when your creating a new report, to get it all lined up and looking nice quickly?  

Thank you in advance for your help
Question by:Amour22015
    LVL 11

    Expert Comment

    by:Simone B
    Click hold and drag your cursor around the fields you want to format. Then right click, and you should see an option to "Align" the fields. You can choose to align Top, Bottom, Middle, Right or Left, depending on your field placement.

    Author Comment


    This is what I am trying to do:

    When you create a new report and you click finish it assumes portrait and evenly spaces across the page from left to right.

    But if you change it to Landscape it keeps the fields in the same position as if it were a portrait.

    I want it to evenly space the fields depending on what size you give it as a Landscape?

    Is there a way to do this?

    This is what happens when you create a new:
    <==Left side of page                                                                            Right side of page ==>
    |FieldOne|   |FieldTwo| |FieldThree|  |FieldFour| ..|FieldFive  |Fieldsix|... |FieldTen|

    But this is what happens when you change to Landscape:
    <==Left side of page                                                                                  Right side of page ==>

    notice the space left over after the last field.

    LVL 11

    Expert Comment

    by:Simone B
    I'm so sorry, I misunderstood what you were looking for. I believe this should help:

    1.  Right click on the report and select Report, Style Expert, Yes.
    2.  Select Drop Table in the Report Style Expert dialog box and click OK.  Then Crystal Report will display a table frame around those report fields and they are in equal spacing.
    3.  Right click again to return to the Report Style Expert dialog box again, select Standard and OK.  Then the table frame is gone and those report fields remained equally spaced.
    LVL 100

    Accepted Solution

    Interesting idea.

    If that doesn't work, there unfortunately is not the equivalent of the VB6 HORIZONTAL SPACE EVENLY

    The only way I have found that helps is to set say the columns titles then select all the fields in that column and use the alignment/size.

    You can try using the vertical guidelines.  Unfortunately there is now easy way to move them other than 1 at a time.


    Author Comment


    Can not find what you mentioned in your last post?, don't see a style section within the Report section?  Looks like mlmcc is correct and I have to move the fields one-by-one?


    Author Closing Comment

    I quess you can not do this in Crystal Reports 2008? Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now