SubReport in Report layout issue (1 Viewer)

alvingenius

IT Specialist
Local time
Today, 04:18
Joined
Jul 10, 2016
Messages
168
Hello,

i've this main report named : "Formations" that have about 10 subreports

all this subreports have the same query criteria, and there's no link between main report and all subreports on it, i'm only using this main form to preview all this sup reports in one report combined.

here's a photo in design mode



and when i print preview it it shows the below photo :



My issues is :
1- Like u see in photo above at the end of the page there's only 2 subreports header and all data in the next page , and i wanna force it to keep together the whole subreport, like this option in other reports



means, this last 2 subreports, i want them to start in the next page automatically if they can't show on the current page

2- in this report , first report on the right have data more than the left one, and the report automatically work on the same height of the bigger subreport and make the whole row using same height
check this photo and the red square this space is empty in the left side because of this subreport on the right height.



i need this red area to be eliminated, means all subreports having it's own heights without affecting the whole row

i hope you get what i mean


Thanks
 

Attachments

  • Formation1.PNG
    Formation1.PNG
    39.3 KB · Views: 396
  • Formation 2.PNG
    Formation 2.PNG
    24.1 KB · Views: 375
  • Formation 3.PNG
    Formation 3.PNG
    5 KB · Views: 307
  • Formation 4.PNG
    Formation 4.PNG
    27.7 KB · Views: 354
Last edited:

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 03:18
Joined
Jul 9, 2003
Messages
14,642
I note you have yet to receive a reply, and it's been a while! thought I would give you a bump up the list and see if if your post attract any attention!
 

alvingenius

IT Specialist
Local time
Today, 04:18
Joined
Jul 10, 2016
Messages
168
I note you have yet to receive a reply, and it's been a while! thought I would give you a bump up the list and see if if your post attract any attention!

Thanks Uncle Gizmo :)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:18
Joined
May 7, 2009
Messages
16,788
do you mean padding a blank rows/record to compensate for the tallest subreport?
requires vba.
 

isladogs

CID VIP
Local time
Today, 03:18
Joined
Jan 14, 2017
Messages
16,382
Something like this? Sorry about the poor quality image. Its a screengrab of a screengrab



Try using 2 columns for your main report placing subreports in each column
 

Attachments

  • Capture.jpg
    Capture.jpg
    72.8 KB · Views: 341

alvingenius

IT Specialist
Local time
Today, 04:18
Joined
Jul 10, 2016
Messages
168
Something like this? Sorry about the poor quality image. Its a screengrab of a screengrab



Try using 2 columns for your main report placing subreports in each column

that's good idea but it won't fit in my situation
Using 2 columns will change the order of subreports
i mean that i wanna see the first 4 subreports in "Formation 1" beside each other not in a column way !

and still not found any fix of the last subreport that only shows the header and the data in the next page #1 issue
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:18
Joined
Oct 29, 2018
Messages
19,154
Hi. For a 2-column report, you can have it either side-by-side or top and bottom.
 

alvingenius

IT Specialist
Local time
Today, 04:18
Joined
Jul 10, 2016
Messages
168
Hi. For a 2-column report, you can have it either side-by-side or top and bottom.

in design mode in report if is sort all subreports groups in column way
it wont appear like what i want to be
 

isladogs

CID VIP
Local time
Today, 03:18
Joined
Jan 14, 2017
Messages
16,382
that's good idea but it won't fit in my situation
Using 2 columns will change the order of subreports
i mean that i wanna see the first 4 subreports in "Formation 1" beside each other not in a column way !

and still not found any fix of the last subreport that only shows the header and the data in the next page #1 issue

No. The subreports will be placed where you put them as is the case in my example. I have lots of similar reports with multiple subreports arranged in this way.

As for the other point, experiment with the Keep Together option. You may need to force a page break as well either using the property sheet or a page break control.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:18
Joined
Oct 29, 2018
Messages
19,154
in design mode in report if is sort all subreports groups in column way
it wont appear like what i want to be

Hi. I'm not in front of a computer right now, but I was thinking they would. For example, if you only put two subreports on top of each other on the first column and then set the column order to go sideways, are you saying they would still show up in one column?
 

alvingenius

IT Specialist
Local time
Today, 04:18
Joined
Jul 10, 2016
Messages
168
No. The subreports will be placed where you put them as is the case in my example. I have lots of similar reports with multiple subreports arranged in this way.

As for the other point, experiment with the Keep Together option. You may need to force a page break as well either using the property sheet or a page break control.

regarding subreports sortings can you please attach an example db ?

and regarding force page break, i can't use it as some of this sub reports may not have data and will shrink to 0' , so the page will be half empty !
 

alvingenius

IT Specialist
Local time
Today, 04:18
Joined
Jul 10, 2016
Messages
168
Hi. I'm not in front of a computer right now, but I was thinking they would. For example, if you only put two subreports on top of each other on the first column and then set the column order to go sideways, are you saying they would still show up in one column?

in case of 2 subreports only it will show as i choose " cross and down " or " down and cross "

but in case i have 10 subreports , and i wanna first 5 subreports to show in cross and down !! and the other 5 subreports the same way !!!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:18
Joined
Oct 29, 2018
Messages
19,154
in case of 2 subreports only it will show as i choose " cross and down " or " down and cross "

but in case i have 10 subreports , and i wanna first 5 subreports to show in cross and down !! and the other 5 subreports the same way !!!

That means there will be gap after subreport #5, correct? If so, have you tried adding an empty subreport between sub 5 and sub 6? Just curious...
 

isladogs

CID VIP
Local time
Today, 03:18
Joined
Jan 14, 2017
Messages
16,382
regarding subreports sortings can you please attach an example db ?

and regarding force page break, i can't use it as some of this sub reports may not have data and will shrink to 0' , so the page will be half empty !

Hi
Sorry the examples are from a commercial app with a 150MB FE & 1.5GB SQL BE!
If you are interested, you can download a DEMO version from http://www.mendipdatasystems.co.uk/school-data-analyser/4584605482. There are screenshots of several of my reports on that page

The screenshot below is from another similar report. All data is for a fictitious school used in the DEMO version



What I should have made clear was that I was arranging the subreports in 2 columns - NOT using a 2 column report. Hopefully the design view will clarify what I meant. Not all subreports are visible in the design view screenshot



I have the same issues with subreports that may be empty. It is also solvable with suitable use of CanGrow/CanShrink; KeepTogether; PageBreak & where necessary moving reports up if the one above has no records.

In design view try setting the height of each subreport to e.g. 0.5 cm


However these expand as required to display the data in each:
 

Attachments

  • ReportPreview.PNG
    ReportPreview.PNG
    99.8 KB · Views: 265
  • ReportDesign.PNG
    ReportDesign.PNG
    53 KB · Views: 310
  • MultipleSubreportsDesign.PNG
    MultipleSubreportsDesign.PNG
    32 KB · Views: 235
  • MultipleSubreportsPreview.PNG
    MultipleSubreportsPreview.PNG
    55.3 KB · Views: 265
Last edited:

Users who are viewing this thread

Top Bottom