Display subform's report in parent form's report

Display subform's report in parent form's report

Requirement  

When the user views a particular record in a report that has subform, the values in the corresponding records are also shown.

Use Case  

An order management application contains two formsCustomers and Orders. The Customer s form is used to store the details of the customers. The Orders form is used by a cashier or an accountant to place an order. Every order is linked to a customer, whose details are entered from a lookup field in the Orders form. The Products form holds the inventory. When a record is clicked, the detailed view of the record will show the customer's other details, such as their phone number or address.

Steps to follow  

1. Create the below forms with the following details:
Form
Form Link Name
Field Type
Field Name
Field Link Name
Customers
Customers
Name
Customer Name
Customer_Name
Email
Email
Email
Phone
Phone
Phone_Number
Orders
Orders
 
Lookup (Customers)
Customer Name
Customer
Date
Delivery Date
Delivery_Date
Subform
  • Single Line
  • Number
  • Currency
  • Currency
Order Details
  • Product Name
  • Quantity
  • Rate
  • Sub-Total
Order_Details
  • Product_Name
  • Quantity
  • Rate
  • Sub_Total
 
2. Select the All Orders report and click Detail View. Select the second layout under Layout.
 
3. Under the Configure Fields slider, click Add Related BlockThis will list all the relationships and subforms of/in the Order form. From the list, select the Order Details subform.
 

This will display the subform's report in the corresponding detailed view of the parent form's report.

See how it works                     

 

Points to note            

  • Lookup forms are automatically added in the detailed view of the report. If lookups are added inside a subform, those records are automatically added in the detailed view of the report. Subforms can be added manually. Please note that by default, two lookup and/or subform blocks are added. Further customization can be achieved using this feature.

  • The detailed view of the related form can be configured according to user requirements. Click on the added block and select the required layout from the options displayed at the top.
  • Additionally, the fields view can also be configured. For example, instead of address, geo - coordinates can also be displayed and this can be configured to be click able. Clicking these will open the map with the corresponding address, enabling calculation for routes, distance, etc. Read more about customizing the detail view here.
  1. Set detail view layout

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  Zoho TeamInbox Resources



                                                                          Zoho DataPrep Resources



                                                                            Zoho DataPrep Demo

                                                                            Get a personalized demo or POC

                                                                            REGISTER NOW


                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • Auto-calculating values on a subform's field

                                                                                                    Requirement Perform statistical operations on the numerical fields in subforms for analysis. Use Case  In an order management application, there are two forms, Order and Product. The Product form lists all the products in the inventory and the Order ...
                                                                                                  • Showing only logged in user's records in a filtered report

                                                                                                    Requirement   Display only the relevant records for the logged in user, based on the customer email, to ensure the security and privacy of the data from other users in the application. Use Case   An order management application has the Order form ...
                                                                                                  • Hotel management

                                                                                                    This app has been published in accordance with Marketplace review process. For pricing details, you can refer to this page. Category - Hospitality Vendor - Zoho Corporation Pricing - Free Overview Say goodbye to thick registry books and run your ...
                                                                                                  • Update an existing record using stateless forms

                                                                                                    Requirement   Use details specified in a stateless form to modify records in the main form. Use Case   In an order management system, a customer has placed an order and wants to cancel it. The administrators allow for cancellation by accepting the ...
                                                                                                  • Add subform rows with dynamic data from another subform

                                                                                                    Requirement             Automatically add rows to a subform and populate it with dynamic data fetched from another subform. Use Case   A form named Orders Database contains customer details and their frequent orders in a subform. We have another ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                      eBooks

                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                      Webinars

                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                      CRM Tips

                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                        Zoho Show Resources