Manipulate report page header fileds through subreport

[Alp Bekisoglu]

Hi Experts,

A2K and a main report (just to provide sequential page numbering) that holds
a few subreports.

I have put two hidden fields on each subreport named item_en & item_tr. I
have two fields on the main report page header named tr & en. The main
report used ans a shell for all the subreports is an unbound report. Aim is
to set:
mainreport.tr = item_tr
mainreport.en = item_en
changing with each subreport.

I am trying to get this done with an if then... but just couldn't manage to
refer to the subreport by name and fieldname to alter the content of the
main report's textbox.

I don't think this is impossible but can't seem to put the logic/commands in
VBA.

I would also like to manipulate another textbox's visibility on main report
page header but it seems to be unavailable.

Thanks in advance.

Alp

 

[Marshall Barton]

A2K and a main report (just to provide sequential page numbering) that holds
a few subreports.

I have put two hidden fields on each subreport named item_en & item_tr. I
have two fields on the main report page header named tr & en. The main
report used ans a shell for all the subreports is an unbound report. Aim is
to set:
mainreport.tr = item_tr
mainreport.en = item_en
changing with each subreport.

I am trying to get this done with an if then... but just couldn't manage to
refer to the subreport by name and fieldname to alter the content of the
main report's textbox.

I don't think this is impossible but can't seem to put the logic/commands in
VBA.

I would also like to manipulate another textbox's visibility on main report
page header but it seems to be unavailable.

You need to do this from within the subreports.

Use an appropriate (report header section?) Format event in
each subreport:
Parent.tr = Me.item_tr
Parent.en = Me.item_en

The visibility problem may be the same kind of issue, but I
can't tell from what you posted.

 

[Alp Bekisoglu]

Hi Marsh,

Thank you for the advice I'll try that. Never thought of manipulating parent
through child. Should have thought of "real world"

I do have page header in the main report but not in the sub's since they do
not show or I couldn't get them to show up.

Thanks again.

Alp