AnsweredAssumed Answered

Enterprise Reports child query not using parent id

Question asked by joenineo on Mar 11, 2016
Latest reply on Mar 17, 2016 by Liam Hastings

Hi

 

I have create an enterprise report that has 2 queries.

 

I can pull data from the first and it should pass the id to the child query.

 

When I run the report the first query runs fine and I see all the record that I want but in the child query under each parent row it pulls the same id.

 

eg I want to pull Opportunities and Notes for each Opportunity

 

Name          Date          Best           Worst

Joe Bloggs  12/12/16   £1000         £100

Note Date    Note

10/12/16       Wants to go ahead

11/12/16       Is going ahead

12/12/16       Will close today

 

Tina Bloggs  01/01/16   £5000         £550

Note Date    Note

10/12/16       Wants to go ahead

11/12/16       Is going ahead

12/12/16       Will close today

 

So the notes are the same but the row with the Opportunity Name/Date/Best/Worst has changed, I have even displayed the ID to make sure its different.

 

Any help much appreciated.

Outcomes