Embedded reports: not showing correctly

Question

I have two tables: Jobs < Assignments.Within the Assignments table, I have 4 different reports setup, they all have slightly different columns selected:

Assignments (default)
Assignments - Jobs Form - Add
Assignments - Jobs Form - Edit
Assignments - Jobs Form - View

In the Jobs table I have 3 different fields, all setup as Report Links, where the Source Field is "Jobs:Job ID#" (this is the Unique Record #) and the Target Field is "Assignments:Related Job".

Assignments Add
Assignments Edit
Assignments View

In the Jobs form, I customized the form so that the three fields display the related assignments directly on the job form (i.e. embedded), and I based each one off of the corresponding Assignments report, e.g. the Jobs field "Assignments Add" points to the "Assignments - Jobs Form - Add" report from the Assignments table.I also changed the "Display when this form is used for" to the corresponding purpose: View for view, Add for add, and Edit for Edit.I check the "Editable" box for Add and Edit, but left it unchecked for View.My goal is that depending on which mode I am in  (add, edit, view), I will have the corresponding Assignments table Report show embedded in the Jobs form.It works for View, but for Add and Edit I am just getting the default Assignments report, with all of the columns.I can't figure out why it is not showing the correct report for the Add and Edit modes.Any thoughts or suggestions?​​​------------------------------Andrewandrew.fry25@gmail.com------------------------------

MarkShnierYou · Accepted Answer

OK, so you meantI just tested it and yes, the correct reports are now showing in the different modes (add, edit, & view).That was a good clue, that this is only a Grid edit problem.Can you check if you have Multiple forms, and if so, in Forms Usage, you have globally for all Roles or for some Roles to set a certain form to be used for Grid Edit?   Or less likely but possible, to have done an override for the reports you are using to force a certain from for Grid Edit?  When you do that it performs as advertised, it will use that form as the definition of the fields to show in Grid Edit.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

MarkShnierYou · Answer

To help debug .. if you uncheck Editable does the correct report display?

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

Sign up

Login to the community