How to filter a subreport to now display the parent
Posted on 2012-04-09
I have a subreport that works great, but I'm refining the report bit by bit
I want to filter the subreport so that it filters out records that display in the parent record.
So the report is like this:
Position (=Accounting Director) (Position Candidate Id = 14)
Candidate (=John Doe) (Candidate Id = 12)
(subreport = Candidates Other positions)
Sales: Sales manager (Position Candidate Id = 23, Candidate Id = 12)
Marketing: Marketing Director (Position Candidate Id = 34, Candidate Id = 12)
Accounting: Accounting Director (Position Candidate Id = 14, Candidate Id = 12)
So I don't want the Accounting Director to show up in the subreport, since it's the same as the parent record, so the filter would be "where main_report.position_candidate_id <> subreport.position_candidate_id"
not sure of the syntax or where to put this
The subreport links by CandidateId and that works great.