Conditionally use ReqFilterFields

Lin · 2006-07-18

I want to have a generic report that allows filtering of a dataitem for certain users and prevents filtering on that dataitem for other users. Can this be done or do I have to use a customised request form and never display the ReqFilterFields tab ?

Thanks

ara3n · 2006-07-18

On prereport. add the following code.

  if Mydataitem.getfilters <> '' then begin
    UserSetup.get(USERID);
    UserSetup.testfield("Allow Filter Report",true);
  end;

Allow Filter Report is a new field in Setup.

Usually Reports suppose to print the filters so that way you can see what filters the user has setup.

Lin · 2006-07-19

Thanks for that but I think you may have misunderstood what I was trying to do. It is difficult to explain. Basically..

I want to have a report that will allow some users to enter filter values for a dataitem but not allow other users to enter filter values (at run time) for a dataitem.

So for a user is of a certain type I want to be able to force the filters into the report by using SETTABLEVIEW and then prevent the filter tab from displaying (or being modified). But if the user is of a different type I would like to force the filters into the report again by using SETTABLEVIEW but allow this user to override the filters by giving them access to the filter tab for the dataitem.

I dont think I am going to be able to do this on the same report. ie I think that you can only control whether the filter tab for the dataitem is to be displayed or not at time of design and that this cannot be changed dynamically when the report is run.

At this point I am heading towards using a request screen.

Thanks

kriki · 2006-07-19

Lin wrote:

At this point I am heading towards using a request screen.

This is the only possibility if you want to use only 1 report for both.
In the OnOpenForm, you can write some code to decide to show a control or not.

Conditionally use ReqFilterFields

Comments

Categories