?
Solved

Infoview incorrectly displays field length from Crystal reports

Posted on 2009-03-30
6
Medium Priority
?
353 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 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 101

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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

801 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