I have a report multiple queries, in which some of my queries are having two filters applied:
Location Company = “abc” OR
Impacted Company = “abc”
I have created a publication in which where there are only on filter I can select the same how should I apply the Personalization in case where there are two filter applied like above?
This is irrespective of above: we have few clients for which we need to run the report for multiple clients, I can add multiple rows which will send multiple reports but I don’t want that, I have to send a single report with data of all those clients.
Thanks for your reply, this is exactly I want but this link works for enterprise users I want to have this for Dynamic recipients.
Is there any reference you have for that?
I don’t know if my first issue was clear, let me explain it in more details:
I have a report with 12 queries(data source). In some of the queries I have filter like below:
Company = “Prompt”
or
Location Company = “Prompt”
which means I have compare both the companies for these queries but I can’t find this option anywhere to have an OR in between when selecting the report field(s) and dynamic recipient mapping under Personalization tab in the Publication.
I want both the things implemented in single publication i.e. sending the report to a client for multiple companies and having OR in between Company and Location Company