HELP! subreport can't auto expand/create page break without messing with header (1 Viewer)

Hi all,

I need help, i've been trying to create a subreport, they're connected by "no-kegiatan" displayed as "kegiatan".

(my file is attached)

so for each no Kegiatan > there would be a subreport... i already made subreport to

can grow = yes

following this suggestion
https://social.msdn.microsoft.com/Forums/office/en-US/07374a44-eddb-46b9-b412-dcb517990d31/start-a-subreport-on-a-new-page-if-it-doesnt-fit-on-current-page?forum=accessdev"]https://social.msdn.microsoft.com/Forums/office/en-US/07374a44-eddb-46b9-b412-dcb517990d31/start-a-subreport-on-a-new-page-if-it-doesnt-fit-on-current-page?forum=accessdev

but if you take an example 17-PKA-0410 (on page 105, in print preview), on page 104 displaing 17-PKA-0409, my main information didn't display, instead only the expanded subreport of 17-PKA-0410. please help, this is frustating! :banghead:

i need both the main displayed, and subreport will be forced to create a new page if the list is longer than it should be.

thanks a lot
warm regards

Adrian

please test this

Hi Arnelgp,

no, didn't workout..
now it's not showing the detailed subreport that should be expanded. only showing the header.

thanks a lot
warm regards

Adrian

test again please.

test again please

Hi Arnel,

thanks so much for the help, but we're still bumped

here's the difference... this is the complete list of subreport from 17-PKA-0410, but the header is missing
"i64.tinypic.com/33zcilt.jpg

and here's your attachment, printed as pdf
"i66.tinypic.com/27y0jk2.jpg"

here's what we missed in red square
"i68.tinypic.com/2psisf6.jpg"

any ideas? sorry, can't post a pic yet.... follow that link from tinypic...

Warm regards

Adrian

see report1. i have to change the subreport. see also the recordsource of main report.

Hi Arnelgp,

How did you do that? i always using report wizard. so i don't know how to add page header & footer like you did.do yo mind if you explain a bit about it?

SO many thanks
this saves me from my deadline...
warm regards

Adrian

if you will open the Report1 in design view,
you will noticed in the detail section, i
copied the Report Header from the SubReport.
then I removed it from the SubReport.

also pay attention to the Main Reports,
Record source, QueryProkarReport.
i change this to include only those
records with corresponding records to
tbl_DatabaseBudget. always make the
records source of the main report to
a table with unique values and not
on tbl_DatabaseBudget, since there
are many duplicate keys there.

also i redesign the two Grouping.
the first is grouped on Expression:
=[No Unit Karya] & [No Kegiatan]
and the other Grouped on "" (empty string).