Solved

Infoview incorrectly displays field length from Crystal reports

Posted on 2009-03-30
6
349 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
[NotSupportedException: Not supported within subreports.] 2 79
Speed Up Crystal Report 5 61
display n/a in column 2 31
Crystal Reports 12 41
1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

828 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