Search code examples
sqlreporting-servicesviewreportingsql-view

How to include a database's views in the SQL Reporting Services Model


I am new to SQL Reporting Services. I need to create a report from a SQL view in my database. When I add the database as a data source and generate a model from that data source, the model includes the database's tables, but not its views.

Is there a way to include the views in the model so I can use them in my report?

Additional Details: Using SQL Server and Reporting Services 2005


Solution

  • A friend pointed out that the problem here is that a model is not necessary for what I want to do. The reason I thought it was necessary is because Report Builder 1.0 requires you to select a model when you create the report. Business Intelligence Development Studio, however, does not (Neither do Report Builder versions 2+).

    I will be making the report in Business Intelligence Development Studio instead.