I am using Helical Insight EE 4.0 RC2. I have created report in which dynamic view is being used. The reason for using dynamic view is I want the filter to be applied only in a subquery. If I use the filter directly at the report level it will get applied at the outside, that is why I have used dynamic view and referencing the filter in that subquery.
But now the problem is that report level is working fine in edit mode but in read mode it is giving errors like below.
My filter expression at the report level is something like below in order to bypass the passing of filter values additionally i.e. one more where clause should not get added additionally at the sql of report outside. I only want one filter to be referenced here, not all the others that’s why I have used below