Filter on Data Foundation in Business Views Not Working (CR Server) 1

[Will2012]

Hi

Any advice on the following would be greatly appreciated.

I am using Crystal Reports Professional XI as the designer on my local machine (Running on XP Prof SP1). I have the client tools of CR Server XI also on my local machine, including Business View Manager. The server components (BO Enterprise) are running on Windows 2000 server. The data source is a system DSN ODBC to MS SQL Server 2000.

In Business View manager on my local machine I have created a data connection to a remote MS SQL server 2000 (hosted on the same box as the BO Enterprise server bits). I have created a data foundation based on this data connection which contains some filters. The filters are intended to exclude records based on the content of specific fields, for example:

{MOVEMENTS.MV_SALES}="Y"

I checked (x+2 button) and applied each filter before saving the data foundation. I then created a business element based on this foundation, and a business view containing this business element. All these were saved in the repository on the server. So far so good.

BUT When I create a report using this business view as a data source I get records coming through that should have been excluded by the filters.

If anyone could shed some light on why this might be and how to ensure the filters are successfully applied to the data I would smile!

Many thanks

Will

 

[sfqwfqwefqwefwef]

How was this resolved? I have very similar circumstances- Cr10 using a business view and cannot get filters to function on the view. If I add record selection criteria to each report I can get by, but I need the filtering to take place at the foundation level. I am sure foundation level filtering works fine most of the time- but why not here? My filter is simply fieldname=value. Yet all values pass through the filter.

Thanks in advance.

 

[Will2012]

Hi sfqwfqwefqwefwef

There's a couple of things to do which should ensure the filter works.

In the business view manager open all stages from the data connection, through foundation, element, to business view.

Create the filter at the foundation level. Right click it in the object explorer and ensure that the box is checked to apply it to everyone. Save the foundation - you will be prompted to update the dependents (element and view) - do so. Switch to the element and save this - again update the dependent view, switch to the view and save this.

Apparently the key (according to BO tech support) is having all stages open at the same time while changes are being made.

Let me know if this works for you - it did for me.

Cheers

Will

 

[sfqwfqwefqwefwef]

Thanks. I did not have all the BV items (connection, foundation, elements) open simultaneously- once I insure ALL are open when a filter is applied the filter generates a WHERE clause in the SQL.