This might be a long shot. Is there a way to show the actual child records in a report instead of a report link? I have a detailed report I need to create but need to have all the related "Grant contracts" listed within an embedded report so the entire thing can be printed in one report. ------------------------------Bethany Hudson------------------------------

No ProblemMake a Combined Text Summary field on the Relationship where 1 Grant Awards has many Grant Contacts.Then to make it look nicer, make a formula text field in Grant Awards like this so they list in a tidy vertical list.SearchAndReplace(ToText([Combined Text Summary Grant Contacts])," ; ", "\n")------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Thanks!But what if I need more than just one field? I need to be able to show the Vendor, Budget, Expenses, etc. for each of the listed contracts. Is that possible?-- Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal Street, Suite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368www.mobilebaynep.comwww.cleanwaterfuture.com

I miss read your original post that I thought you were talking about contacts and not contRacts. but still "np",Just make a formula text field down on the child table to concatenate all your fields into a single field and rol them up.But you may want to reconsider your approach and instead just make the report off the Contracts table and lookup any fields you need from Grants down to Contracts. It would be pretty straightforward to roll up a few text fields but once you start trying to roll up numeric field and label what they are just starting to get pretty messy.I think what you really want as a report of contracts showing certain columns from the grants. ------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

I've tried a few different times that way but no luck. I'm able to get a few important fields rolled into the report (- field), but is there a way to have that field linked to the Related Contracts shown?-- Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal Street, Suite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368www.mobilebaynep.comwww.cleanwaterfuture.com

Are you asking if you can make that appear as a hyperlink to the children?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Showing Child records instead of Report Link

11 Replies

MarkShnier__You
Qrew Legend
3 years ago
No Problem
Make a Combined Text Summary field on the Relationship where 1 Grant Awards has many Grant Contacts.

Then to make it look nicer, make a formula text field in Grant Awards like this so they list in a tidy vertical list.

SearchAndReplace(ToText([Combined Text Summary Grant Contacts])," ; ", "\n")

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- BethanyHudson
  Qrew Trainee
  3 years ago
  Thanks!
  But what if I need more than just one field? I need to be able to show the Vendor, Budget, Expenses, etc. for each of the listed contracts. Is that possible?
  
  --
  
  Bethany Hudson
  Program Administrator
  Mobile Bay National Estuary Program
  118 North Royal Street, Suite 601
  Mobile, AL 36602
  (o) 251-459-8870
  (c) 251-367-1368
  www.mobilebaynep.com
  www.cleanwaterfuture.com
  - MarkShnier__You
    Qrew Legend
    3 years ago
    I miss read your original post that I thought you were talking about contacts and not contRacts.
    
    but still "np",
    
    Just make a formula text field down on the child table to concatenate all your fields into a single field and rol them up.
    
    But you may want to reconsider your approach and instead just make the report off the Contracts table and lookup any fields you need from Grants down to Contracts. It would be pretty straightforward to roll up a few text fields but once you start trying to roll up numeric field and label what they are just starting to get pretty messy.
    I think what you really want as a report of contracts showing certain columns from the grants.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Showing Child records instead of Report Link