Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports Space issue

Hi please solve this.

In the database i created a table like this.

labelkey language targetvalue

emp english Employee

date english Date

total english Total

emp french employé

total turkey oamgft

emp turkey i?çi

total french ntahiri

date turkey tarih

date french toplam

i create one parameter language.

i created 3 formulas like this total emp,date

For total if {label.language}={?language} and {label.labelkey}="total" then {label.targetvalue}

For emp if {label.language}={?language} and {label.labelkey}="emp" then {label.targetvalue}

For date if {label.language}={?language} and {label.labelkey}="date" then {label.targetvalue}

If i select language=turkey the result is comming bot lot of blank spaces comming

In detail section/section expert i checked suppress blank section option.

But still some space is there like this.




But i need to dispaly those 3 fields in one row please help me

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2012 at 11:13 AM

    Hi divya ,

    To display 3 fileds in one row,

    Create a formula targetvalue , and select total+emp+date formula from Report fields.

    With Regards


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Divya,

      As addition to sriram you can create a new formula and add those fields in the formula with concatination operator ➕.

      So you can create a formula like below and display that value.

      value = trim(Total)+" "+ trim(emp)+" "+trim(date)


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.