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









                                                                                                        • 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 ...
                                                                                                        • 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 ...
                                                                                                        • 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 ...
                                                                                                          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