Discussions

Expand all | Collapse all

How to show an embedded report in a report

  • 1.  How to show an embedded report in a report

    Posted 27 days ago
    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 have the step by step on how to insert a report into another report, I can only see what it looks like but I don't know how to get there.

    I appreciate the support


    Edson Gonzalez-chavez




    ------------------------------
    Data (Administrator)
    ------------------------------


  • 2.  RE: How to show an embedded report in a report

    Posted 27 days ago
    You can't do that anymore unless you know how to build code pages. 

    I recommend that you keep using the standard reports and use links to open another report.

    ------------------------------
    Everett Patterson
    ------------------------------



  • 3.  RE: How to show an embedded report in a report

    Posted 27 days ago
    You 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
    ------------------------------



  • 4.  RE: How to show an embedded report in a report

    Posted 26 days ago
    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
    The Next Step Public Charter School
    3047 15th Street N.W., Washington, DC 20009
    email: Edson@nextsteppcs.org
    Tel. 202-299-5097 Cell: 202-520-2643 Fax: 202-234-0001
    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!





  • 5.  RE: How to show an embedded report in a report

    Posted 26 days ago
    It 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
    ------------------------------