Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

Avoid overlapping the sub reports

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


0
v_pushparaj
Asked:
v_pushparaj
  • 2
  • 2
  • 2
  • +2
1 Solution
 
DRRYAN3Commented:
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.

DRRYAN3
0
 
jtreatCommented:
Create a separate section for each subreport. The second section will not start until the first section has finished.
0
 
DRRYAN3Commented:
jtreat

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.

DRRYAN3
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
ComTechCommented:
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
name.
If you're having a problem with a Member, you can refer it to us.


Thank you and welcome to EE,
ComTech
Community Support

Ps. I will have to reject you proposed answer.
0
 
jtreatCommented:
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.
0
 
ComTechCommented:
No porblem, jtreat been there myself.

ComTech
0
 
jrmnCommented:
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.

cheers,
jrmn
0
 
v_pushparajAuthor Commented:
Thanks, It worked. Now it is not overlapping


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now