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 support
Mark, I will take a look at your suggestions
the scenario is complex
Table A (Class) related to Table B (Period Times)
embedded report from table B in Table A
Table A (Class) related to Table c ( students )
embedded report from table C in Table A
the need is
in the embedded report from table C in Table A need to have the column to expand the embedded report from table B in Table A
I just to do with javascript but I can't do that anymore
--
Edson Gonzalez-Chavez
Data System Specialist
This 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!
The Next Step Public Charter School
3047 15th Street N.W., Washington, DC 20009
email: Edson@nextsteppcs.orgTel. 202-299-5097 Cell: 202-520-2643 Fax: 202-234-0001
- 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
------------------------------