Filter Embedded report

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered

Hi Team,

I have two tables Project and Attachments.

Relationship: Project<Attachments

Attachments has following fields:

Upload,description, document type

Now I want to show the related attachment in project using report link.But it has to show only that attachments which has document type Input and Final .

I don't want to show that attachments which has document type Production.

But when I try to make filter in embedded report then it is showing all the attachments in

project which are related or not related to project.

Photo of Rishab

Rishab

  • 0 Points

Posted 5 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
No problem
Create a report of attachments called "Just Final Attachments" ( for all projects).

Then go to your form on the Project record and edit the form properties for the report link field to use that new report
Photo of Rishab

Rishab

  • 0 Points
Thanx for reply, but if I implement the above solution then it will show the all attachments but I want to show related attachment to that project, how can I show only related attachmets to particular project ?
please suggest  me the solution .
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
The report link field which is sitting on the left side of your relationship between projects and attachments will only show records for the project you're viewing. That is the whole point of a report link field. The extra filter you're putting on for final attachments is in addition to the filter for only  attachments related to that project.

I suggest you give it a try!
Photo of Micro Dev

Micro Dev

  • 1,454 Points 1k badge 2x thumb
Is it possible to have additional filters on an Embedded report?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,700 Points 50k badge 2x thumb

For example 

One Product Line has Many SKUs.

But you only want to show SKUs marked as "Active" on the main Product Line form.

So just make a new report with your columns and sort and filter just for "Active" is checked.  No other filters.  Save the report but make it visible to non one (so no one messes with it).

Then set the form property for the embedded report to use that report instead of the default record picker.
Photo of Micro Dev

Micro Dev

  • 1,454 Points 1k badge 2x thumb
That is if its always the same filter. I want the user to be able to filter based on his requirements which can vary.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,700 Points 50k badge 2x thumb
The low tech solution is to teach the users to click the Full Report link at the top of the embedded report and then ensure that you offer them useful Dynamic filters.

Alternatively, it is possible to make a URL formula button to run the report in a new tab.

This conversation is no longer open for comments or replies.