Solved

Crystal Reports CanGrow Problem

Posted on 2004-09-01
7
5,045 Views
Last Modified: 2007-12-19
Using Crystal Reports that comes with Visual Studio.NET 2003.  Fields for which I have CanGrow set to True overwrite Fields and Text (in the same Section) that appear below them in design view.  I would have expected setting the CanGrow property to True would cause fields below my growing field to automatically move down, this is not the case.  The growing fields's text overwrites the text below it.  This behavior is not the same in Access reporting, in Access the fields move as I expect them to.  Am I missing a setting somewhere?  Is there something I can fix through code?

Thanks in advance

Eric
0
Comment
Question by:cotaej
[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
7 Comments
 
LVL 18

Expert Comment

by:bobbit31
ID: 11953111
yeah, either set the cangrow maxlines to a set number (>0) OR put the cangrow field in it's own section.
0
 

Author Comment

by:cotaej
ID: 11953221
Thanks for the quick response, we set the MaxNumberOfLines Property to 10000, this did not help.
Also putting the growing field in its own section would be our last option, the field is in the middle of other fields
0
 
LVL 28

Accepted Solution

by:
bdreed35 earned 350 total points
ID: 11953242
Put the field with the CanGrow set to True in its own section.  You can divide the section into subsections.  The CanGrow property of the field will allow that section to grow to accomodate it, but it won't start printing the next section until the first one is done.

For example, lets say all your firleds are in Group Header 1.
Right click the where it says Group Header 1 to the left of the report canvas, and choose insert Section Below.
This renames Group Header 1 to Group Header 1a, and creates a Group Header 1b.
You can then either move fields down form a to b, or you can click and drag b to move it above a.  The sections would then get renamed, and then you can move your fields up.
There is also a way to split a section by hovering over the left margin until the icon changes to a single horizontal line with an arrow pointing up and one pointing down.  Click and drag up and down and a gray line will appear.  When you let go of the mouse button, it will split the section at that position.

Anyway, if you get your field that you want to allow to grow, in to the a section, the a section will have to completely finish before it will start the b section.  This should solve your overlapping problem.
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 11953321
You need to play with multiple sections and probably underlaying.

section a - field1  field2            field4
section b -                     field3
section c - field5  field6  field7  field8

With the above example, you would set section a to Underlay Following Sections.
In section b you woulc set field3 to CanGrow
This would allow section a and b to llok seamless for the first line, but still allow field3 to expand and not overlap field7
0
 
LVL 10

Expert Comment

by:ebolek
ID: 11953351
Crystal recommends putting it into its owns ection for problems like addresses
For example if you have address 2 which could be null sometimes, you put it into its own section and then set it to supress blank sections. This is true for empty fields but also overlapping problem, If you set the can grow to true then the next section will start from the place that the previous section ends

There is no other way and the experts before me explained the problem very good

Regards
Emre
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

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…
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…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

732 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