Forum Discussion

Data_SystemAnal's avatar
Data_SystemAnal
Qrew Cadet
3 years ago

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 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)
------------------------------

4 Replies

  • 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
    ------------------------------
  • 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
    ------------------------------
    • Data_SystemAnal's avatar
      Data_SystemAnal
      Qrew Cadet
      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!


      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------