Report Data Filtering

Hello Dave,

We've discussed this task with one of our customers in an private issue, and there are two solutions for this problem:
1. I do not recommend that you allow end-users to work with the Report Designer. Please review the Action based Permission issue to learn how to disable the Show Report Designer action for certain users. In this case, you can use an approach demonstrated in the How to allow users to create filter via the criteria editor before previewing a report example to allow users to set custom criteria for reported data, and use the following code to filter the report by its owner:

[C#]
public class ViewController1 : ViewController {
    public ViewController1() { }
    protected override void OnActivated() {
        base.OnActivated();
        Frame.GetController<WinReportServiceController>().CustomShowPreview += new EventHandler<CustomShowPreviewEventArgs>(ViewController1_CustomShowPreview);
    }
    void ViewController1_CustomShowPreview(object sender, CustomShowPreviewEventArgs e) {
        e.Report.FilterString = CriteriaOperator.Parse("Owner.Oid=?", SecuritySystem.CurrentUserId).ToString();
    }
    protected override void OnDeactivating() {
        base.OnDeactivating();
        Frame.GetController<WinReportServiceController>().CustomShowPreview -= new EventHandler<CustomShowPreviewEventArgs>(ViewController1_CustomShowPreview);
    }
}

[C#]
public class ViewController1 : ViewController {
    public ViewController1() { }
    protected override void OnActivated() {
        base.OnActivated();
        XtraReport.FilterControlProperties += new FilterControlPropertiesEventHandler(XtraReport_FilterControlProperties);
        Frame.GetController<WinReportServiceController>().CustomShowPreview += new EventHandler<CustomShowPreviewEventArgs>(ViewController1_CustomShowPreview);
        Frame.GetController<WinReportServiceController>().CustomShowDesignForm += new EventHandler<CustomShowDesignFormEventArgs>(ViewController1_CustomShowDesignForm);
    }
    void XtraReport_FilterControlProperties(object sender, FilterControlPropertiesEventArgs e) {
        if (e.Control is XtraReport) {
            e.Properties.Remove("FilterString");
        }
    }
    void ViewController1_CustomShowDesignForm(object sender, CustomShowDesignFormEventArgs e) {
        e.Report.FilterString = CriteriaOperator.Parse("Owner.Oid=?", SecuritySystem.CurrentUserId).ToString();
    }
    void ViewController1_CustomShowPreview(object sender, CustomShowPreviewEventArgs e) {
        e.Report.FilterString = CriteriaOperator.Parse("Owner.Oid=?", SecuritySystem.CurrentUserId).ToString();
    }
    protected override void OnDeactivating() {
        base.OnDeactivating();
        Frame.GetController<WinReportServiceController>().CustomShowPreview -= new EventHandler<CustomShowPreviewEventArgs>(ViewController1_CustomShowPreview);
        Frame.GetController<WinReportServiceController>().CustomShowDesignForm -= new EventHandler<CustomShowDesignFormEventArgs>(ViewController1_CustomShowDesignForm);
    }
}

Thanks,
Anatol