It is only workaround and it will work in very simple scenarios only.
Now imagine production environment with dynamic values in field you need to cycle through, also nobody mentioned the fact that this workaround will work only if we want to cycle through the field and produce reports into one common location (else it becomes completly unpractical)
Case Study:
What if reports need to be distributed to different folders/emails so SalesRep 1 cannot see SalesRep 2 reports --> for example: (this is the most common usecase for all clients where cyclic reports are used):
- SalesRep 1
- Country Australia (Australia is a recipient filter as this person is reposnsible for this country only)
- Cycle through cities and produce separate reports for each city (Brisbane, Sydney, Darwin (cities are dynamic - they apear depending on client location))
- SalesRep 2
- Country Germany (Germany is a recipient filter)
- Cycle through cities and produce separate reports for each city (Berlin, Munich, Frankfurt cities are dynamic - they apear depending on client location))
How do you workaround above need?
hopefuly there is a workaround for this - as currently i do not have a fully atomated solution for it.
Note. be aware that No of citites may be greater than 250 - some of my clients have limited no of recipients which we can distribute reports to.
any ideas?
cheers
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
.png "itec_pao"){kind=avatar}
