Solved

Infoview incorrectly displays field length from Crystal reports

Posted on 2009-03-30
6
347 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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