Discussions

 View Only
Expand all | Collapse all

Display more than one report on a single page

  • 1.  Display more than one report on a single page

    Posted 12-07-2018 17:41
    I have a Formula-URL Button. When i click on that button , display more than one Table Report on the same page one below the other and that all Table reports should be in the Grid-Edit mode by default. How to achieve this in QuickBase ?


  • 2.  RE: Display more than one report on a single page

    Posted 12-07-2018 18:22
    Can be done depending on the use-case. Can you present your use-case?


  • 3.  RE: Display more than one report on a single page

    Posted 12-07-2018 18:30
    Grid edit more than one report on the same page? I'm intrigued..


  • 4.  RE: Display more than one report on a single page

    Posted 12-07-2018 18:35
    Me too...About the use-case. As long as they are all related to something in common, it is quite possible. We do that all the time out here. If I have an Employees table (for example) and I have all their skills, projects they are working on, you could typically have all the subreports editable on the employees form. That is one page with multiple grid edit reports. But if they are not related, we can still relate it to some phantom concept. All depends on @murali's use-case.


  • 5.  RE: Display more than one report on a single page

    Posted 05-28-2020 08:27
    I am not Murali, but I want to do the same.

    My use case is this: We monitor certain activity by our Sections throughout the world through a table called Scorecard. My Scorecard table is related to the Section table by Section Name.  I want to display 4 reports when the Section lands on a tab titled Scorecard (the reports are quarterly reports of activity by the Section). Is this doable on a tab, or does it need to be a page? Even if it is only a page, I am interested in learning how to accomplish this.

    Thanks.

    ------------------------------
    Penny Whoolery
    ------------------------------



  • 6.  RE: Display more than one report on a single page

    Posted 05-28-2020 08:46
    You can display multiple reports and charts on a record. Are these reports all based on the same table or are there multiple different tables that hold these reports?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Display more than one report on a single page

    Posted 05-28-2020 08:54
    They are all based on the same table.

    ------------------------------
    Penny Whoolery
    ------------------------------



  • 8.  RE: Display more than one report on a single page

    Posted 05-28-2020 09:10
    You will have a report link field which shows the embedded report of children on the form.  That report link field can be set on the form to display the results right on the form as opposed to just a link to the child records.

    You are free to add that same field many times on the form, and each time just use a different report  to show different reports.  The reports themselves will not be filtered for a particular parent,.  The report link field setup  will ensure that you just get the records for that parent when used on that form.  ie the report link field adds in an extra filter not in the report itself.



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: Display more than one report on a single page

    Posted 05-28-2020 10:22
    This is great and I like the look of just having a link on the page.

    However, when I click on the report link, it displays ALL fields instead of the selected custom fields set up in the report.

    Ex: 



    Any idea why?

    Thanks
    Penny


    ------------------------------
    Penny Whoolery
    ------------------------------



  • 10.  RE: Display more than one report on a single page

    Posted 05-28-2020 10:51
    If you just include a link the report on the form, then it is not so easy to control the target report.  So I suggest that you set the form properties to display the child records on the form.

    Was that you issue - that you were just showing a link to the report and not the actual report on the form?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 11.  RE: Display more than one report on a single page

    Posted 05-28-2020 11:25
    Yes, that was the issue. I understand what is happening, so I will ensure he child fields are displayed. 

    Thank you so much!
    Penny

    ------------------------------
    Penny Whoolery
    ------------------------------