Crystal Reports - Format Field

ramziabk
ramziabk used Ask the Experts™
on
In Crystal Reports I created a new report with the format below:

Number of Employees Per Department             Dept1               100
                                                                          Dept2               50
                                                                          Dept3               500
                                                                          Dept4               40
The "Number of Employees Per Department " is a static field suppressed. Is there a way that this fields be centered justified? and how?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:


Hi RAm

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

Horizontal alignment > choose 'centered'

Author

Commented:
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

Commented:
Oh you want the text centered verticvally, and horizontally?
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Author

Commented:
that's true.
Commented:
From what I know crystal reports doesnt have this option.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

Author

Commented:
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
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
The answer provided by kingjely is the answer.  You should accept it.
http://www.experts-exchange.com/Microsoft/Applications/Q_26556728.html?cid=1572#a33946065

mlmcc

Commented:
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 :)

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

mlmcc

Author

Commented:
Closed

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial