0

NL to get associated records for main NL, on the same row

Jet Reports Historic Posts

August 20, 2013 08:31

None

Follow

Hi,

I do not think what I would like to achieve is possible, but I will ask the question anyway.

What I would like, is for an NL function to get all rows based on a filter, and display a few fields from that filter. I would then like to put another NL on the same row, and get associated records from another table, for each row in the first table. If I were to do this, all the fields from the first table will replicate down for each associated record. I would like to not have them replicate, and just leave empty spaces until all associated records are displayed.

For example, I could have cells B1 C1 and D1 as fields from the first table, and then E1 and F1 would be fields from associated table record. Lets say that the first record has 4 associated records, that would mean that B1 B2 B3 and B4 are all the same, C1 C2 C3 and C4 are all the same and D1 D2 D3 and D4 are all the same. E1:E4 and F1:F4 would all vary based on associated record.

I would like a way to display fields in B1:D1, but then leave B2:D4 blank, while still displaying associated data in E2:F4.

I have attached a workbook with two table layouts. The one on the left shows how I would like it to look, while the one the right is the closest I have gotten using Rows=2 and moving the second NL down a row.

Appreciate any help and advice.
Eds

• Book2.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 20, 2013 15:47

  I think I've been able to achieve the result you are after by using nested replicators with Rows=2 and conditional hide. Check out the attached sample workbook. Does this work for you?
  
  Regards,
  Hughes

  • Conditional Hide.xlsx
• 0
  
  Jet Reports Historic Posts August 20, 2013 16:00

  Hi Hughes,
  
  That looks to be spot on.
  I will create a report using my actual data, and see what happens.
  
  Thanks for your help as always! :)
  
  Eds

• 0
  
  Jet Reports Historic Posts August 22, 2013 09:27

  Hi,
  
  I have managed to take Hughes example, and expand it to work for three nested NL functions, and have it working almost perfectly.
  What I need to do now, is to set the third NL to only run if the result of the second is something specific.
  
  Using Hughes example workbook, I expanded it to work with a third nested NL, and wrapped it in an if statement, and it worked correctly.
  I have now applied the same method to my working report, but the IF statement is causing the NL to only return the first row, not all of them.
  
  If I remove the if statement, it is returning all rows. Considering the NL function itself is unchanged, is there any reason why it would only return the first row?
  I can't upload an example, as it is all live data.
  
  Thanks
  Eds