Hello All,
I Have a blocking point preventing me from finishing my report.
I have a query getting a table contains many columns with information about different sites ex(requesting site, requested site, reached site,..)
all of the columns in the main table are brought by SQL query joining the main table with table called Sites, I have for each tab in the report information regarding the requesting site, another tab showing information about the requested site, I've loaded only sites table as it's and created a site filter, but the issue that I can't create a relationship on many columns from the main table to only one column in sites table, I'm able only to create only one relationship between those two tables. but I want the same filter to be synced with all tabs in the report, if the user from the first tab filter for "site 1" and the first tab showing info about requesting site and when the user moves to the second tab I want to keep the sites filter to be also on "site 1" but on the different relation based on requested site. how this can be done?, except for the option that I have to load table sites multiple times with different names and I'll be able to create relationships as I want, but when filtering I want to use only 1 filter object synced with all report tabs with a dynamic relationship
