Referencing a control on sub-report

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

I have two reports called: "rpt_TRS_DO_Revised_Data"
and "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals". I have embedded
the "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" report into
the "rpt_TRS_DO_Revised_Data". Now I have a child parent
relationship with "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" as
the child sub-report. There is a control on this report
called: "txtIdleTime" which I am trying to reference in a
separate control on the parent report which looks like the
following: =[Embed_IdleTmeAfterJobEnd].[Report]!
[txtIdleTime]. The control for the sub-report is
called: "Embed_IdleTmeAfterJobEnd"

However, when I run the report I keep getting an "Error"
in this control. Any ideas why this is happening? What
would be the better method for getting it to work!

Any ideas provided to correct this issue would be
appreciated.

Thanks,..
 
Thanks, ET.

I have done exactly that, it now works. Now however, when
there are no records to display, the control
shows/displays an #Error# message. How can get around this
#Error# message from showing!

Thanks,...

-----Original Message-----
Try this:

=[Reports]![YourReportName]![YourSubReportName].[Report]!
[YourFieldName]

Regards,

ET Sherman

-----Original Message-----
I have two reports called: "rpt_TRS_DO_Revised_Data"
and "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals". I have embedded
the "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" report into
the "rpt_TRS_DO_Revised_Data". Now I have a child parent
relationship with "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" as
the child sub-report. There is a control on this report
called: "txtIdleTime" which I am trying to reference in a
separate control on the parent report which looks like the
following: =[Embed_IdleTmeAfterJobEnd].[Report]!
[txtIdleTime]. The control for the sub-report is
called: "Embed_IdleTmeAfterJobEnd"

However, when I run the report I keep getting an "Error"
in this control. Any ideas why this is happening? What
would be the better method for getting it to work!

Any ideas provided to correct this issue would be
appreciated.

Thanks,..

.
Click to expand...
.
Click to expand...
 
You should get blank, but without seeing your exact
report/table layout I will not dispute the fact.

Try adding the IsError function to your expression:

=iif(IsError([Reports]![YourReportName]!YourSubReportName].
[Report]![YourFieldName]),"",([Reports]![YourReportName]!
YourSubReportName].[Report]![YourFieldName]))

Regards,

ET Sherman
-----Original Message-----
Thanks, ET.

I have done exactly that, it now works. Now however, when
there are no records to display, the control
shows/displays an #Error# message. How can get around this
#Error# message from showing!

Thanks,...

-----Original Message-----
Try this:

=[Reports]![YourReportName]![YourSubReportName].[Report]!
[YourFieldName]

Regards,

ET Sherman

-----Original Message-----
I have two reports called: "rpt_TRS_DO_Revised_Data"
and "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals". I have embedded
the "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" report into
the "rpt_TRS_DO_Revised_Data". Now I have a child parent
relationship with "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" as
the child sub-report. There is a control on this report
called: "txtIdleTime" which I am trying to reference in a
separate control on the parent report which looks like the
following: =[Embed_IdleTmeAfterJobEnd].[Report]!
[txtIdleTime]. The control for the sub-report is
called: "Embed_IdleTmeAfterJobEnd"

However, when I run the report I keep getting an "Error"
in this control. Any ideas why this is happening? What
would be the better method for getting it to work!

Any ideas provided to correct this issue would be
appreciated.

Thanks,..

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Thanks, Duane.....

-----Original Message-----
PMFJI:
=IIF([Reports]![YourReportName]![YourSubReportName]. [Report].[HasData],
[Reports]![YourReportName]![YourSubReportName].[Report]! [YourFieldName], 0)

--
Duane Hookom
MS Access MVP


Russ said:
Thanks, ET.

I have done exactly that, it now works. Now however, when
there are no records to display, the control
shows/displays an #Error# message. How can get around this
#Error# message from showing!

Thanks,...

-----Original Message-----
Try this:

=[Reports]![YourReportName]![YourSubReportName]. [Report]!
[YourFieldName]

Regards,

ET Sherman


-----Original Message-----
I have two reports called: "rpt_TRS_DO_Revised_Data"
and "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals". I have
embedded
the "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" report into
the "rpt_TRS_DO_Revised_Data". Now I have a child parent
relationship with "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals"
as
the child sub-report. There is a control on this report
called: "txtIdleTime" which I am trying to reference
Click to expand...
in
a
separate control on the parent report which looks like
the
following: =[Embed_IdleTmeAfterJobEnd].[Report]!
[txtIdleTime]. The control for the sub-report is
called: "Embed_IdleTmeAfterJobEnd"

However, when I run the report I keep getting an "Error"
in this control. Any ideas why this is happening? What
would be the better method for getting it to work!

Any ideas provided to correct this issue would be
appreciated.

Thanks,..

.

.
Click to expand...
Click to expand...


.
Click to expand...
 
Thanks, ET....
-----Original Message-----
You should get blank, but without seeing your exact
report/table layout I will not dispute the fact.

Try adding the IsError function to your expression:

=iif(IsError([Reports]![YourReportName]! YourSubReportName].
[Report]![YourFieldName]),"",([Reports]![YourReportName]!
YourSubReportName].[Report]![YourFieldName]))

Regards,

ET Sherman
-----Original Message-----
Thanks, ET.

I have done exactly that, it now works. Now however, when
there are no records to display, the control
shows/displays an #Error# message. How can get around this
#Error# message from showing!

Thanks,...

-----Original Message-----
Try this:

=[Reports]![YourReportName]![YourSubReportName]. [Report]!
[YourFieldName]

Regards,

ET Sherman


-----Original Message-----
I have two reports called: "rpt_TRS_DO_Revised_Data"
and "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals". I have
embedded
the "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals" report into
the "rpt_TRS_DO_Revised_Data". Now I have a child parent
relationship with "rpt_TRS_DO_IdleTimeAfterJobEnd_Vals"
as
the child sub-report. There is a control on this report
called: "txtIdleTime" which I am trying to reference
Click to expand...
in
a
separate control on the parent report which looks like
the
following: =[Embed_IdleTmeAfterJobEnd].[Report]!
[txtIdleTime]. The control for the sub-report is
called: "Embed_IdleTmeAfterJobEnd"

However, when I run the report I keep getting an "Error"
in this control. Any ideas why this is happening? What
would be the better method for getting it to work!

Any ideas provided to correct this issue would be
appreciated.

Thanks,..

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top