Avoid overlapping the sub reports

Posted on 2001-09-04
Last Modified: 2012-06-27
When the two sub reports are placed one below the other in Main Report. The second Subreport and first sub report are overlapped. How to avoid the overlapping. All the data in the first Sub Report should be printed followed by the Second sub report

Question by:v_pushparaj
  • 2
  • 2
  • 2
  • +2
LVL 12

Expert Comment

ID: 6453685
Right click on each sub-report, select Format and make sure the check-box named Can-Grow is checked.  Resize the sub-reports to approximately the smallest amount of vertical space you anticipate them taking up and try it again.


Accepted Solution

jtreat earned 30 total points
ID: 6454393
Create a separate section for each subreport. The second section will not start until the first section has finished.
LVL 12

Expert Comment

ID: 6454514

Without going into all the gory details here, the accepted convention in the Crystal Reports area is to post your suggestions as a comment and to let the questioner select an answer from amongst the suggestions.  This may or may not be what you have experienced in other areas of EE.

Please post in the Community Support area if you have any questions about this.

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.


Expert Comment

ID: 6454737
Hello jtreat, please read the following concerning questions vs. answers.

From EE Policy:

Advice for Experts on Providing Solutions Through Comments or Answers
Experts may post solutions to your question in the form of a comment or answer, so be sure to check
every email notification as soon as it arrives. Often, an Expert posts the solution to your problem
as a comment because it is early in the collaboration process and other issues may be involved. In addition,
it is common etiquette in some topics areas to always post comments and not answers. There are several
reasons behind this thinking:

Questions do not become prematurely locked and the collaboration process is not inhibited when the question
is indexed as open for proposed solutions.
The question-asker has the power to select the best solution rather than one that is simply suggested
as an answer.
Watch out for unclear or multiple-part questions. You can send a comment to the member requesting that
they rephrase or break up the question before you submit an answer.
If you don't know the answer, leave the question for someone else.
If you are unsure of your solution, post it as a comment rather than an answer. Members can accept comments
as solutions and award points for them.
You are only responsible for providing one reasonable answer.
You may review information about a member, including their grading history, by clicking on their member
If you're having a problem with a Member, you can refer it to us.

Thank you and welcome to EE,
Community Support

Ps. I will have to reject you proposed answer.

Expert Comment

ID: 6454983
I apologize if I should have posted as a comment instead as an answer.

The subreports do need to be allowed to grow but this alone will not resolve the described issue. Fields start in the vertical position defined for that field relative to the section they are in. As the first subreport (or any field) grows vertically there is always the possibility of the field growing past the next field(s). The resolution is to insert a new section after the first field. The next field is then placed in this second section which will not start until after the first field is finished. This will allow that field to grow without affecting the following fields. This can be repeateed as often as needed.

Expert Comment

ID: 6455033
No porblem, jtreat been there myself.


Expert Comment

ID: 6455527
Hi v_pushparaj,

To simplify what jtreat have said, why not put each subreport on a different section (by inserting a new section)? This will ensure that when each subreports grows, it will not overlap the other ones.


Author Comment

ID: 6458396
Thanks, It worked. Now it is not overlapping


Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a recent question ( here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 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