Results 1 to 7 of 7

Thread: 100 Char fit into 80 Char width

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Aug 2007
    Location
    Kolkata. India
    Posts
    25

    100 Char fit into 80 Char width

    Hi all ,
    Need your help.


    I am making a Crystal Report which formats like

    Date Product Customer Quantity Rate Value

    Date = 10 Char
    Product = 100 char
    Customer = 100 Char
    Quantity= Numeric
    Rate= Numeric
    Value = Numeric

    Paper Size (A4) Portrait Mode, Arial Font, Font Size is 12,

    First of All, the total width of all the data fields exceed the length of A4 length paper size

    Now I would like to get some facility in Crystal Report to accommodate the maximum length of Data Field by reducing the character spacing but not the height of the character in specific font (such as Ariel 12 for us) to fit into the user defined length of data fields at design time.

    Exmple :
    We like to fit 100 characters into 80 characters length width


    We have tried the character spacing Property of Crystal Report but didn’t get the success of the required result.

    Urgent ........

    From
    Mayukh

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: 100 Char fit into 80 Char width

    Quote Originally Posted by Mayukh
    We like to fit 100 characters into 80 characters length width
    The only thing that will accomplish this is to lengthen the 80 characters to 100.

  3. #3
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: 100 Char fit into 80 Char width

    Would you allow AutoGrowth to let CR add lines to the field?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  4. #4
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: 100 Char fit into 80 Char width

    Would AutoGrow actually exceed a specific text length?

  5. #5
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: 100 Char fit into 80 Char width

    Grow will allow to add lines downward in CR. So you would have 80 chars on line1 and another 20 on line2
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  6. #6
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: 100 Char fit into 80 Char width

    Quote Originally Posted by GaryMazzone
    Grow will allow to add lines downward in CR. So you would have 80 chars on line1 and another 20 on line2
    Ahhhh....gotcha.

    So, this would seem to solve your problem, right Mayukh?

  7. #7

    Thread Starter
    Junior Member
    Join Date
    Aug 2007
    Location
    Kolkata. India
    Posts
    25

    Re: 100 Char fit into 80 Char width

    Quote Originally Posted by Hack
    Ahhhh....gotcha.

    So, this would seem to solve your problem, right Mayukh?

    Hi,

    Thanks for giving some views on my topic.
    But like to tell you that, i will accommodate all
    the 100 characters into one field by reducing character spacing.

    Although still i am looking for solution.

    Thanks in advance

    Mayukh

Posting Permissions

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



Click Here to Expand Forum to Full Width