Forum Discussion

awood's avatar
awood
Qrew Member
8 months ago

Embedding report in form without relationship?

Hi all,

I am trying to allow site managers to enter information for multiple employees (name, hours worked, hourly rate) and have this calculate an average rate for the site. I do not have access to employee information so I cannot create a separate "employees" table - this information would need to be entered by each manager. 

I am using the site # to pull in information such as the benefits %, which will be read-only and used for calculations. I also want managers to only see information for their own site(s). 

So far I created a grid edit report that has the correct fields and my calculations are working, but the issue I'm running into is that if I want to add my report to a form I have to create a relationship, and in so doing I am forced to link to existing data that is limiting how many entries one manager can make. I would like to be able to add my grid edit report to my form and not have to link it to the larger data environment, so the manager can put as many entries as they want without any limits. 

Is this possible?

 

Forms
  • MikeWestin1's avatar
    MikeWestin1
    Qrew Trainee
    8 months ago

    I don't know if I fully understand the problem you're solving for, but it sounds like you're looking for a report link that would point at some existing data, but in order for this to be useful, the record for which you would be displaying the report data would need a common value with the source of the data you're pointing the report link at. For example, if you have have a table with Site # records, you could point a report link at another data set that also shares common Site # field values. If you do not already have common field values between the table you'd be displaying the report on and the report link endpoint, you could also create a formula to reference the report link against.