Solved

Infoview incorrectly displays field length from Crystal reports

Posted on 2009-03-30
6
344 Views
Last Modified: 2013-11-15
In Crystal Reports I am able to shorten a field if I don't want the whole thing to display (such as if a field is too long for the space available in a report). But even when I shorten the field display in Crystal Reports, it still shows the entire field (which I don't want) in Infoview.

I could make formulas to just display the first N characters, but this is clunky and annoying. Is there something wrong with Infoview or is there a setting I missed?
0
Comment
Question by:ngwsls
  • 4
  • 2
6 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24025594
Make sure you don't have CAN GROW set for the field when you format the field.
It is on the COMMON TAB

Does it make it taller or wider?

mlmcc
0
 

Author Comment

by:ngwsls
ID: 24029858
I should have mentioned already I do not have "can grow" checked on the field format.  In fact, I tried it both ways and Infoview ignores it.
Example:
What the field contains:   Customer Verylong Name
What I want to display (and what Crystal Displays):     Customer Verylon
What Infoview displays:  Customer Verylong Name
So of course it runs into the next column of data.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24030625
It must be an Infoview problem because Crystal doesn't allow fields to grow in width only in height.

mlmcc
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:ngwsls
ID: 24031758
I was afraid that was the answer but thought I would at least see if there was something I was missing.  Thanks anyway!
0
 

Author Comment

by:ngwsls
ID: 24034719
mlmcc was on the right track.  The answer is to format the field and select "Can Grow" on the Common tab. Then you can either let the field be "taller" or you can set a limit of 1 line and it will just display the shorter text.
Am awarding the points to mlmcc because he had the right idea in the first place.
0
 

Author Closing Comment

by:ngwsls
ID: 31564582
Please see my last comment for the complete solution.  MLMCC deserves the points because he got me going in the right direction.  Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now