refer to parent form data..

  • Thread starter Thread starter piwerek
  • Start date Start date
P

piwerek

Hello :)

i`m stuck. I have a Report which has Subreport. Subreport`s data has to
be conditioned with it`s parent data.. another way, i need to have sth
like this:
(in sql view)
....
.....WHERE (thisReport.someDate)>parent!someDate....
....
this is where statement from Subreport Query.

Let me know if sthing is missunderstood.

ps. i could refer to parent report field, but i CAN`T do sth like this:
WHERE (thisReport.someDate)>Reports!parentReport!someDate <-- this
work, but i can`t use it in my situation.
 
I haven't done this before but could you try a subreport record source wiht
a criteria like:

WHERE [DateField]>Reports!rptYourMainReport!txtStartDate
 
hmm thx for interest, but in my situation i can`t use this condition.
I`ll try to describe my problem. I have 4 reports which have also
subreports. Each of them can be shown alone (each manager can make his
own report), but...
also i had to make one Summary, where all 4 reports are shown as
Subreports (Report for main director). So i have 2 situations:

4 Reports -> each have 2 subreports
1 Report -> 4 Reports -> each have 2 subreports

So what do i have to say is, that i can`t refer like You said, because
in 1 situation it`s good, but in the other before parent report, there
is another one, so parent.parent
 
I'm not sure if this would work but try create a global date variable. Have
code in the parent report set the variable and a function in the criteria of
the subreport's criteria that would retrieve the value.
 
Back
Top