Add Multiple sub report in single detail section without overlap

Question

0.00/5 (No votes)

See more:

Avoid sub report overlap
1)In crystal report have three sub report one by one so it can overlap one another.
2)I don't need each sub report in different section.
3)I need each sub report in single detail section without overlap.

Example:

-------------------Detail section--------------------------------
-------------Sub Report One--------------------
-------------Sub Report Two--------------------
-------------------End of detail section---------------

Posted 1-Apr-14 19:58pm

Member 9991744

Updated 1-Apr-14 19:59pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2014-04-01T20:39:00

Solution 1

try this...
Detail section -> right click -> Insert section below
it will be another detail section will run same as detail section your report will be as it is and overlapping problem will be solved

---------------  Detail section  ---------------   -> right click -> Insert section below
	-------------Sub Report One-----------------
---------------Detail section (a)---------------
	-------------Sub Report Two-----------------
---------------  Report Footer   ---------------

Happy Coding!
:)

Posted 1-Apr-14 20:39pm

Aarti Meswania

Comments

Member 9991744 2-Apr-14 3:26am

Thanks for your reply, I know this solution already but i need to place the two sub report in single section without overlap.

Member 9991744 2-Apr-14 7:37am

Please reply fast

Aarti Meswania 2-Apr-14 7:56am

if you already know solution then why are you not using it, is there any reason?

Member 9991744 3-Apr-14 3:21am

Thanks for your reply ,
-again i will remind you, i don't need each sub report in single detail section
-I need to place each sub report in single section

In my report view
------------------------Detail section-------------------------------------

------Sub report one------- | -----Sub report two-----------
------Sub report three----- | -----Sub report four-----------

------------------End of detail section--------------------------

I think now you understand my question Please reply fast

Thanks
G.Mani

Aarti Meswania 3-Apr-14 3:30am

then move sub report three and four in detail section b
or
fix hieght and width of all sub reports

Member 9991744 3-Apr-14 3:43am

Nice Thanks for your reply
see let explain my situation

-Sub report one contain 3 record
-Sub report two contain 0 record
-Sub report three contain 0 record
-Sub report four contain 4 record

If i will do your way means
----------------------Details section(a)---------------------------------
---Sub report one------ ---Sub report Two------
1)Record one
2)Record two
3)Record three

----------------------Detail section(b)----------------------------
---Sub report three------- ---Sub report four------
1)Record one
2)Record two
3)Record three

See both side gap will be create that is the main problem for my crystal report.

Aarti Meswania 3-Apr-14 4:21am

okay then what o/p you want?
I think you want to display sub report one and four together in detail section a right?

Member 9991744 3-Apr-14 6:00am

If i place four sub report in single detail section, empty sub report will be suppress so the gap should be avoided.
if all the sub report have more then two record means it will be overlap one another.
this is my situation please help me.

Member 9991744 3-Apr-14 6:04am

Needed output is
----------------------Details section---------------------------------
---Sub report one------ ---Sub report Two------
1)Record one 1)Record one
2)Record two 2)Record two
3)Record three 3)Record three

---Sub report three------- ---Sub report four------
1)Record one 1)Record one
2)Record two 2)Record two
3)Record three 3)Record three

------------------End of detail section--------------------------
this is the output i want please help me

Aarti Meswania 3-Apr-14 6:24am

what do you mean by "If i place four sub report in single detail section, empty sub report will be suppress so the gap should be avoided."

can you show me design view how should it look
1. if sub report 2 and 3 is empty?
2. if sub report 1 and 4 is empty?
3. if sub report 1 and 3 is empty?

Member 9991744 3-Apr-14 7:07am

Thanks for your reply
First i will explain using single detail section

*Going to explain using Single detail section
*1. if sub report 2 and 3 is empty?
--------------------Detail section-----------------------------------
---------Sub report1----------- ----------Sub report2----(empty)---
1)Record one ---------Sub report4------------
2)Record two 1)Record one
3)Record three 2)Record two
----------Sub report3---(empty)---

*2. if sub report 1 and 4 is empty?
----------------------------Detail section------------------------------
---------Sub report1---(empty)-- ----------Sub report2---------
----------Sub report3---------- 1)Record one
1)Record one 2)Record two
2)Record two 3)Record three
3)Record three
---------------------------End of detail section-------------------------

3. if sub report 1 and 3 is empty? (here is the problem started 2nd sub report overlap 4th sub report).

----------------------------Detail section------------------------------
---------Sub report1---(empty)-- ----------Sub report2---------
---------Sub report3---(empty)-- 1)Record one
2)Record two
3)Record three
----------Sub report4---------
1)Record one
2)Record two
3)Record three

The second sub report overlap fourth sub report. this is the problem for single detail section.

***************************************************************************

*Going to explain using multiple detail section
1. if sub report 2 and 3 is empty?
--------------------Detail section(a)-----------------------------------
---------Sub report1----------- ----------Sub report2----(empty)---
1)Record one
2)Record Two
3)Record Three
----------------------Detail section(b)----------------------------------
----------Sub report2----(empty)--- ---------Sub report4-----------
1)Record one
2)Record two
3)Record three

see both side gaps are there this is the problem for multiple detail section

Member 9991744 3-Apr-14 7:15am

From this itself you may not understand means send your mail id. i will send crystal report images.

Aarti Meswania 3-Apr-14 7:35am

ok I have not tried it but can suggest you how can you achieve this
take 2 detail sections as I told you
put sub report 1 n 2 in section A
put sub report 3 n 4 in section B

now right click section A -> tick "underlay following section" press formula button for that option write down condition that if sub report 2-3 is suppressed or 1 and 4 is suppressed is true then it should underlay section

Member 9991744 4-Apr-14 0:27am

I don't know how to check the sub report is suppress using formula, so please give example.

Member 9991744 7-Apr-14 3:23am

I don't know how to check the sub report is suppress using formula, so please give example. Please reply faster.

Aarti Meswania 7-Apr-14 4:10am

search on google for that because I already suggest a way to solve issue, I think you have to create some global variable and maintain record count for all 4 sub-report then you can make the final condition for section 'b'

Sanju TV 25-Sep-17 16:32pm

Hi Sir, Did you get the solution for this problem? I am also stuck in same issue.