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

[Radian89]

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

 

[arnelgp]

please test this

 

[Radian89]

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

 

[arnelgp]

test again please.

 

[arnelgp]

test again please

 

[Radian89]

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

 

[arnelgp]

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

 

[Radian89]

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

 

[arnelgp]

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).