How to show an embedded report in a report
Good afternoon all. I find this Discussions link that is exactly what I am trying to add to one of my apps I used it to understand how can I do it on my own but I gave up! Some of you will ha...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou can simply do a combined text summary field to combine the child records into one field. You can roll up to 150 children up into a singe field.
1. On the child table make a field which concatenates all the fields together that you need ie the "columns" of the report.
2. Then make a Combined Text Summary field on the relationship.
3. Then make a formula field to convert that to a vertical list
'
SearchAndReplace([Combined Text Summary field], " ; ", " \ n")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
1. On the child table make a field which concatenates all the fields together that you need ie the "columns" of the report.
2. Then make a Combined Text Summary field on the relationship.
3. Then make a formula field to convert that to a vertical list
'
SearchAndReplace([Combined Text Summary field], " ; ", " \ n")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks to all for your supportMark, I will take a look at your suggestionsthe scenario is complexTable A (Class) related to Table B (Period Times)embedded report from table B in Table ATable A (Class) related to Table c ( students )embedded report from table C in Table Athe need isin the embedded report from table C in Table A need to have the column to expand the embedded report from table B in Table AI just to do with javascript but I can't do that anymore--Edson Gonzalez-ChavezData System SpecialistThe Next Step Public Charter School3047 15th Street N.W., Washington, DC 20009email: Edson@nextsteppcs.orgTel. 202-299-5097 Cell: 202-520-2643 Fax: 202-234-0001This holiday season, join our Be The Gift campaign and donate to our scholarship fund and GIVE the gift to GROW and GO to our winter graduates!
- MarkShnier__YouIt stills sounds easy.
1. Roll up the Combined Text of Period Times up to Table A.
2. Use SearchAndReplace to tidy up the appearance.
3. Look up That field down to Table C.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
