Publication of a report with multiple filters

Hi All,

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.

Any help would be really appreciated.

Regards,
Tauceef


tauceef (BOB member since 2012-06-19)

for your second query; there are two passes.
you can check documentation of publication and find ‘Profile resolution’.

Also check below for your first query.


link2BOE :india: (BOB member since 2007-07-02)

Hi PT,

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

Please suggest.

Regards,
Tauceef


tauceef (BOB member since 2012-06-19)