SteveKrupp
5 years agoQrew Member
Can I filter a Report Link with multiple filters?
I have a database with several different tables. It's setup linking like this: Jobs < Bids > Creators. So jobs can have multiple bids, and creators can have multiple bids.
On each job I have several Ratings. The first is "Awareness", the second is "Customer Relations", etc. Each Creator has the exact same ratings as are on the Job, ("Awareness", "Customer Relations", etc). What I'm trying to do is create a report link which filters the creators based upon the rating each creator has, in relation to the rating requirements which the job has.
The problem I'm running into is that with a report link I can only match one creator rating to the job rating. And it must be an exact match.
What I'm trying to do is make it so that I can display a report on each job, with a filter which only displays the creator if every one of their ratings are equal or higher than the job requirements.
So if "Awareness" requirement is 3 stars or higher, but Creator 1 only has an "Awareness" of 2.5, he won't show up, even if all other skills are higher than the requirement.
Is there any way I can do an embedded report like the report link does?
------------------------------
Steve Krupp
------------------------------
On each job I have several Ratings. The first is "Awareness", the second is "Customer Relations", etc. Each Creator has the exact same ratings as are on the Job, ("Awareness", "Customer Relations", etc). What I'm trying to do is create a report link which filters the creators based upon the rating each creator has, in relation to the rating requirements which the job has.
The problem I'm running into is that with a report link I can only match one creator rating to the job rating. And it must be an exact match.
What I'm trying to do is make it so that I can display a report on each job, with a filter which only displays the creator if every one of their ratings are equal or higher than the job requirements.
So if "Awareness" requirement is 3 stars or higher, but Creator 1 only has an "Awareness" of 2.5, he won't show up, even if all other skills are higher than the requirement.
Is there any way I can do an embedded report like the report link does?
------------------------------
Steve Krupp
------------------------------