Crystal Reports VS 2012.

I am creating a report and in the details section I put in a text object and field object and when I insert them they are nice and even. When I go to preview them the Text is at the top of the section and the field object is at the bottom. Any ideas how to get them to line up? I have looked at the formatting and this is driving me crazy.
riley00Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If both object have the same height, then perhaps the field object content starts with a carriage return or Line Feed.

Try to strip those invisible characters away using something like:
Replace(Replace({your_data}, Chr(10), "'") , Chr(13), "")

If that was not the issue, provide the rpt.
mlmccCommented:
Are they still both the same size?

Is either of them set to GROW?
If so try making it a little wider.

mlmcc
riley00Author Commented:
Thanks for you response, my field object is coming form a SQL DB. I have created several reports using the same database with out this issue. so I am not sure why it is a problem with this one.
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

riley00Author Commented:
Not lining up
mlmccCommented:
Have you used this field before?

In preview mode has the field object moved or is it taller?

mlmcc
riley00Author Commented:
this is in the detail section, it is like the Text object goes to top of section and the field object goes to the bottom of the section.
riley00Author Commented:
No, same just not lined up.
mlmccCommented:
I understand that.  Ido pointed out one possible cause that there is a <CR><LF> in the text.

Can you answer the questions I posed.

I don't recall ever seeing something like that except when the data has formatting in it.  Field objects just don't move on their own.

mlmcc
riley00Author Commented:
This is how it looks in my editor
mlmccCommented:
Can you upload the rpt file?

mlmcc
riley00Author Commented:
Sorry, but wont that give any proprietary info with it?
mlmccCommented:
I don't need it with data or just limit it to the 2 offending fields

mlmcc
riley00Author Commented:
How would I limit it to the 2 fields?
mlmccCommented:
Delete the rest from the report then save under a new name

mlmcc
riley00Author Commented:
mlmccCommented:
The problem is the Cone field is NULL for some records so it doesn't show a value.

You have the text object formatted to suppress if duplicated.  Turn that off and you will see they fields line up correctly.

mlmcc
riley00Author Commented:
Yes, but when I do that it puts in 3 instances of the text field and the 2nd lines up correctly. how do I get rid of the other 2?CR3.jpg
mlmccCommented:
One way would be to filter out the records with the NULL values.

I assume there are other types that are being used and other regions reported on.

Since you are using a text field as the label I don't think you can group on anything.
If you can then the data could go into the group header.

mlmcc
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Filter out records without a value or suppress the section based on the same logic.
riley00Author Commented:
OK, where do you go to filter the null values?  Sorry newbie.
mlmccCommented:
You use the SELECT EXPERT.

Click REPORT --> SELECTION FORMULA  --> RECORD
Use a formula like
     NOT IsNull({CFTMain.Cone})

Open in new window


If there are other filters then use AND  as
{CFTMain.Date} = currentdate-1
AND
NOT IsNull({CFTMain.Cone})

Open in new window


To use suppression
Right Click the section in the left margin
Click SECTION EXPERT
Click the formula button to the right of SUPPRESS
 IsNull({CFTMain.Cone})

Open in new window


The method you use needs to be tuned for the data.  The report probably has other regions and other fields.  I don't think you want to suppress or filter out records based solely on the one field

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
riley00Author Commented:
Thanks So much for your help, greatly appreciated!!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.