Showing Child records instead of Report Link
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 contr...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo 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
------------------------------
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
------------------------------
- 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-1368
- MarkShnier__YouI 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-1368
