Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-15-2019, 03:27 AM   #1
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Arrow SubReport in Report layout issue

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
Attached Images
File Type: png Formation1.PNG (39.3 KB, 114 views)
File Type: png Formation 2.PNG (24.1 KB, 109 views)
File Type: png Formation 3.PNG (5.0 KB, 110 views)
File Type: png Formation 4.PNG (27.7 KB, 81 views)


Last edited by alvingenius; 10-25-2019 at 02:44 AM.
alvingenius is offline   Reply With Quote
Old 10-24-2019, 06:04 PM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,357
Thanks: 554
Thanked 946 Times in 895 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: SubReport in Report layout issue

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!
__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
Tera (10-24-2019)
Old 10-25-2019, 02:46 AM   #3
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Re: SubReport in Report layout issue

Quote:
Originally Posted by Uncle Gizmo View Post
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

alvingenius is offline   Reply With Quote
Old 10-25-2019, 03:01 AM   #4
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: SubReport in Report layout issue

do you mean padding a blank rows/record to compensate for the tallest subreport?
requires vba.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-25-2019, 03:06 AM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,238
Thanks: 115
Thanked 3,074 Times in 2,792 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: SubReport in Report layout issue

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
Attached Images
File Type: jpg Capture.jpg (72.8 KB, 69 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-26-2019, 11:19 AM   #6
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Re: SubReport in Report layout issue

Quote:
Originally Posted by arnelgp View Post
do you mean padding a blank rows/record to compensate for the tallest subreport?
requires vba.
yeah that's #2 issue
and i want to remove this padding !
alvingenius is offline   Reply With Quote
Old 10-26-2019, 11:26 AM   #7
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Re: SubReport in Report layout issue

Quote:
Originally Posted by isladogs View Post
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

alvingenius is offline   Reply With Quote
Old 10-26-2019, 11:31 AM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: SubReport in Report layout issue

Hi. For a 2-column report, you can have it either side-by-side or top and bottom.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 10-26-2019, 11:33 AM   #9
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Re: SubReport in Report layout issue

Quote:
Originally Posted by theDBguy View Post
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
alvingenius is offline   Reply With Quote
Old 10-26-2019, 11:37 AM   #10
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,238
Thanks: 115
Thanked 3,074 Times in 2,792 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: SubReport in Report layout issue

Quote:
Originally Posted by alvingenius View Post
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.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-26-2019, 11:40 AM   #11
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: SubReport in Report layout issue

Quote:
Originally Posted by alvingenius View Post
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?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 10-26-2019, 11:41 AM   #12
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Re: SubReport in Report layout issue

Quote:
Originally Posted by isladogs View Post
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 is offline   Reply With Quote
Old 10-26-2019, 11:44 AM   #13
alvingenius
IT Specialist
 
alvingenius's Avatar
 
Join Date: Jul 2016
Posts: 68
Thanks: 7
Thanked 0 Times in 0 Posts
alvingenius is on a distinguished road
Re: SubReport in Report layout issue

Quote:
Originally Posted by theDBguy View Post
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 !!!
alvingenius is offline   Reply With Quote
Old 10-26-2019, 11:52 AM   #14
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: SubReport in Report layout issue

Quote:
Originally Posted by alvingenius View Post
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...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 10-26-2019, 12:06 PM   #15
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,238
Thanks: 115
Thanked 3,074 Times in 2,792 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: SubReport in Report layout issue

Quote:
Originally Posted by alvingenius View Post
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/s...ser/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:
Attached Images
File Type: png ReportPreview.PNG (99.8 KB, 23 views)
File Type: png ReportDesign.PNG (53.0 KB, 23 views)
File Type: png MultipleSubreportsDesign.PNG (32.0 KB, 24 views)
File Type: png MultipleSubreportsPreview.PNG (55.3 KB, 22 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)

Last edited by isladogs; 10-26-2019 at 12:34 PM.
isladogs is offline   Reply With Quote
Reply

Tags
subreport layout

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is this a Report/SubReport Issue? RoddyC Reports 4 04-11-2014 02:16 AM
Question printing issue with report with subreport glb466 General 2 06-02-2011 02:30 PM
Print Preview Report/ Subreport issue cath_hopes Forms 0 04-21-2008 05:10 AM
Report and SubReport Issue JudyHNM Reports 2 10-06-2006 04:52 PM
Report/Subreport criteria issue DblDogDare Reports 4 08-14-2003 07:43 AM




All times are GMT -8. The time now is 03:37 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World