SAP Knowledge Base Article - Public

1198959 - Error: "This report is based on a Business View and cannot be viewed. In order to view this report it must be set to a different data source"

Symptom

When attempting to view a report based on a Business View using the Crystal Reports Viewer XI, the following error message appears:

"This report is based 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 does not support viewing reports based on Business Views.

Resolution

The Crystal Reports Viewer XI does not support viewing reports based on Business Views. This includes when a Crystal report is saved with the "Disconnect view security" option. The report datasource must be changed per the instructions in the message received in order to view the report with the Crystal Reports Viewer XI.

See Also

From the Crystal Reports Viewer XI readme file:

"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)."

To obtain the Crystal Reports Viewer XI Release Notes within the application, click Help > Crystal Reports Viewer Help.

To obtain it from our web site

  1. Browse to the Business Objects Product Guide.
  2. Click Crystal Reports Viewer in the All Products drop-down list.
  3. Click BusinessObjects XI Release 2 in the All Releases drop-down list.
  4. Click the PDF icon to download the Crystal Reports Viewer XI Release Notes.

Keywords

crystal reports viewer xi report based Business View cannot viewed must set different data source , 4588708 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2