Solved

Infoview incorrectly displays field length from Crystal reports

Posted on 2009-03-30
6
342 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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

13 Experts available now in Live!

Get 1:1 Help Now