[Vtigercrm-developers] important: no restrictions used in emailed reports

[Christoper J Combrink]

A work-a-round could be to setup a cron to execute a complex SQL Query,
generating a CSV file which is then emailed?

This would be pretty cumbersome depending on how many unique reports you're
looking at though.

Regards,

*Christopher J Combrink*
co-founder | COO

*t.* +27 79 673 1888
*w.* wowfingers.com
[image: WoW Fingers>] <http://wowfingers.com/>
UNIT 34 SOMERSET SQUARE, GREEN POINT, 8001
<https://goo.gl/maps/HSmRerNpBbF2>

On Wed, Jun 20, 2018 at 12:39 PM, Alex Hall <ahall at autodist.com> wrote:

> Correct. Users can schedule reports that get emailed to them at the
> schedule they set. It is these reports that don't honor the ACL the rest of
> Vtiger does, and that's the problem. Obviously, we've disabled the entire
> scheduled reports option for now, but it's one aspect of Vtiger that
> everyone really likes to use. I'd like to turn it back on, but van't until
> we can get it to use the same restrictions for the target user that the
> user would have across the rest of the site. The other IT guy at my work is
> currently looking into changing the source to use the same controls that
> non-scheduled reports use, but he's not had any luck so far.
>
> On Jun 20, 2018, at 06:19, Christoper J Combrink <
> christopher at wowfingers.com> wrote:
>
> Alan, he's talking about the scheduled emails/reports, I believe - not the
> export (from within the module) functionality?
> Unfortunately, I've not had a lot of success with the default reporting
> module myself so I can't offer any advice.
>
>
> Regards,
>
> *Christopher J Combrink*
> co-founder | COO
>
> *t.* +27 79 673 1888
> *w.* wowfingers.com
> [image: WoW Fingers>] <http://wowfingers.com/>
> UNIT 34 SOMERSET SQUARE, GREEN POINT, 8001
> <https://goo.gl/maps/HSmRerNpBbF2>
>
> On Wed, Jun 20, 2018 at 11:15 AM, Alan Lord <alanslists at gmail.com> wrote:
>
>> First of all, make sure that the users who you do not want to be able to
>> get the report data, has the "Export" tool turned off in their Profile for
>> each module that the data comes from. i.e. if its Organisations, disable
>> Export on Organisations.
>>
>> The Report will not then allow the user to get the csv as it is an export.
>>
>> IMHO for most users Export should be disabled for everything anyway.
>>
>> HTH
>>
>> Al
>>
>> On 19/06/18 19:03, Alex Hall wrote:
>>
>>> Hello all,
>>> We have all our sales reps, and their manager, on Vtiger. We have
>>> restrictions for different groups, so reps can't see other reps' data, but
>>> managers can. This works, even in reports. The problem is reports that get
>>> emailed.
>>>
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20180620/dc5fe667/attachment-0001.html>