SAP Knowledge Base Article - Public

1185812 - Error: "Business View Report... This report file is base on a Business View and cannot be viewed...use the 'Set Datasource Location...' operation."

Symptom

In Crystal Reports Viewer XI, you attempt to open a report based upon a Business View, and receive an error message:

"Business View Report. This report file is base on a Business View and cannot be viewed. In order to view this report it must be set to a different data source. To change the report data source please open it in the Crystal Reports designer application and use the 'Set Datasource Location...' operation."

Cause

The Crystal Reports Viewer XI application does not support viewing reports based on Business Views.

Resolution

The Crystal Reports Viewer XI application does not support viewing reports based on Business Views. From the Crystal Reports Viewer XI Release Notes:

"Types of reports that will not load in the viewer

"When you try to open one of the following types of reports, you will receive an error message:

  • Reports without saved data that require data to format.
  • Reports that use Business Views as a data source.
  • Reports that use universes as a data source.
  • Reports that use Crystal Dictionaries as a data source.
  • Reports that use Crystal Queries as a data source.
  • Reports that depend on UFLs.
  • Reports that are successfully using "Perform Grouping on Server". (That is, the generated report SQL contains a "group by" clause.)
  • Reports that have cross-tab objects in which a formula is used to produce print-time side effects (such as a manual running total)."

Keywords

Crystal Reports Viewer XI Business View Report cannot view different data source support Dictionaries Queries UFL universes cross-tab formula produce print-time side effects manual running total Perform Grouping on Server , 1917100 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2