Forum Discussion
BlakeHarrison
5 years agoQrew Captain
The simple answer is Yes, but. The question becomes then if you have the data on your record necessary to have the embedded report show the correct data. The 'but' is that you have to have a Report Link field that is setup to show the Parent records.
Example: You have a Projects (child) table and a Customers (parent) table. On your Customers form, you want the user to be able to see any Projects that are in an Active status, not just that particular Customer's Projects. To do something like this, I would follow these steps:
In your case, you just need to figure out what field would be the appropriate field to use as the appropriate Target when setting up the Report Link field.
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
Example: You have a Projects (child) table and a Customers (parent) table. On your Customers form, you want the user to be able to see any Projects that are in an Active status, not just that particular Customer's Projects. To do something like this, I would follow these steps:
- Create a Formula Text field called 'Projects Report Status' and set the formula to simply be the status you want to display "Active"
- Create a Report Link field called 'Active Projects'
- Set the 'Match the values in this field in this table' selection to our new 'Projects Report Status' field
- Set the Target ('to the values in this field') to the 'Status' field in the Projects table
-
- Add the Report Link field to your form and setup your embedded report as normal
In your case, you just need to figure out what field would be the appropriate field to use as the appropriate Target when setting up the Report Link field.
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
AlexandriaLewis
5 years agoQrew Member
Thank you that worked!!
------------------------------
Alexandria Lewis
------------------------------
------------------------------
Alexandria Lewis
------------------------------