15 September 2014

Business Intelligent Development Studio is needed for create SQL Report. This feature is exist in installer Microsoft SQL Server --> Client Components --> Business Intelligence Development Studio.
Choose as list to be installed when installing SQL Server. We also can only install Business Intelligent Development Studio. Click Next and continue installation as usual.
(This sample is using SQL Server 2005 Developer)

If successful, Business Intelligence will be included on list Project Type while add new project in Visual Studio 2005.
We can use this facilities without installing Visual Studio 2005. Menu program will be displayed sub menu SQL Server 2005.
Extension file SQL Reporting is.rdl.
Business Intelegence SQL Server used for .rdl editor, but we can't edit it dirreclty by double clicking its rdl file.We have to include rdl file in a report project.

Click here if you like this article.

Related Article:

  1. Installing Business Intelligence SQL Server 2005
  2. Creating Report with SQL Server Reporting (Wizard)
  3. Creating Report with SQL Server Reporting (without wizard) | Part 1
  4. Creating Report with SQL Server Reporting (without wizard) | Part 2
  5. Design Layout Report
  6. Creating Parameter for Filtering
  7. Stored Procedure as Report Data Source
  8. Parameter Data List from Database Query
  9. Creating Report Group
  10. Create Sequence Number Using RowNumber Function
  11. Uploading Report FIle (.rdl) to Report Server
  12. Remove Report Page Break/Page Break 
  13. Query to Generate Subscription List 
  14. Direct Printing to Printer