Making reference to a group object and using it on a subform (1 Viewer)

biofaku

Member
Local time
Today, 09:30
Joined
May 15, 2020
Messages
66
I am making a report that has it's results filtered using groups. I was trying to use the value from the textbox on the group's header to filter a subreport that is attached on the group's footer. The script was wrote on the Onload event of the subreport, and worked on the report's view, but when I load the printing preview it shows error 2101.
I tried writing the filter on the onload event of the main report, but it does not find the groups's header textbox, and also shows an error, 2455 this time.

Any idea how to achieve this? It would be really useful to my desing being able to filter this unrelated report by the value of this textbox.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:30
Joined
May 7, 2009
Messages
14,156
Create a Master/Child Link Fields on the SubReport.
 

biofaku

Member
Local time
Today, 09:30
Joined
May 15, 2020
Messages
66
Oh, I forgot to mention that the subreport is based on a crosstab query.
arnelgp, when I linked master/child fileds it showed me this error "You can't use a pass through query or a non-fixed column"

Edit: Just sorted it out, I needed to add the columns names on the query, didn't knew that one. THANKS ARNE!

 
Last edited:

Users who are viewing this thread

Top Bottom