Crystal Reports - Format Field

Hi RAm

Right click the field,
go to common
halfway down the page is a

Horizontal alignment > choose 'centered'

Thank you Kingjely but this is won't solve my prb.

Your solution will center the text. If you go back to my question what I want is as follows:


                                                                          Dept1               100
                                                                          Dept2               50
       Number of Employees Per Department      Dept3               500
                                                                          Dept3               500
                                                                          Dept4               40

Hope I make myself clear.

Thanks

Oh you want the text centered verticvally, and horizontally?

that's true.

Agree.  There is no easy way to do that.  It can be done using a formula for the header that adds carriage returns to the front of the string.  CHR(13) is the carriage return

Do you know how many rows there will be?

mlmcc

I'm thinking that you've got something like this:

"Number of Employees Per Department"          {department field}            {count}

 and you're somehow suppressing that text field on every line except the first one.

 If so, is that a detail section or group header or ...?

 If you can determine how many lines there will be (Count may do the trick), then you may be able to use a variable to count the lines as their produced and not suppress that field on the middle line.

 James

Argh.  That should have been "they're produced" at the end, not "their produced".  :-)

 James

Well, I can't tell the count. This is a variable and can change anytime. Anyway if it is a hassele, then I'll live with what I have.

Sorry guys for bothering.
Thanks
Ramzi

The answer provided by kingjely is the answer.  You should accept it.
https://www.experts-exchange.com/questions/26556728/Crystal-Reports-Format-Field.html?cid=1572&anchorAnswerId=33946065#a33946065

mlmcc

I believe my answer is correct, and should be accepoted for when others search EE database, for this question, they will find the answer. RAther then it being deleted.

Sorry but,
I Don't think its my fault, Crystals doesn't support your request :)

You don't need to know the count ahead of time.  You just need to know it when you want to print the value.

mlmcc

Need to give the author a chance to accept the correct comment or continue the discussion

mlmcc

Closed