Reporting Services

The following procedure is exposed holding account of a configuration Visual Basic Express-Sql Server express, but it is works, excluding some passages, also for the other versions of Visual basic 2005.
Warning 1: the ReportViewer control is not supported from Windows 98.
Warning 2: this page has been modified on 15 May 2007 .

1. Download SQLEXPR_ADV.EXE from the site of Microsoft to this page after you selected the language. SQLEXPR_TOOLKIT.EXE from this page after you selected the language.
2. If you have problems of installation, uninstall Sql server express and its correlate softwares, and after install first SQLEXPR_TOOLKIT.EXE and next SQLEXPR_ADV.EXE
3. Install the file "Windows Full Install.exe" from here. The file are not other that driver ODBC of Firebird.
4. Start>Settings>Control panel>Administration services>Origin ODBC. You will find the voice Firebird/Interbase (r) driver in the Driver tab. Clic on tab "customer DNS" . Clic on the Add button>Select Firebird driver>it will open the window Setting for ODBC Firebird. In the textbox Name of the source of data (DSN) you write any name for the source of the data. In the Database textbox insert the complete path of the Firebird database on your PC. In the textbox Client DLL insert the path of the library fbembed.dll on your PC.
   
5. After the SQLEXPR_ADV_ITA (EN) installation it has appeared in the directory of the programs of the menù start, between the other, the voice Microsoft Sql Server 2005> Sql Server Business Development Intelligence Studio. Clic on.
   
6. The ambience of project will be opened “Visual Studio 2005”. Up in the bar of the instruments Standards clic on New Project, or in the Initial Page clic on Create Project. Give a name to the new project.
   
7. In explorer solutions select on report folder and right clic Add report. For semplicity and temporarily follow the guided Procedure. In the window select “New data origin”. In the textbox Selection data type name will appear the name of default DataSource1 . If you want it changes let do it. In the combobox Data origin>Type select ODBC . In the field "connection string" insert the following connection string: Dsn=NomeDsnUtenteFirebird; username=sysdba; password=masterkey; dbname=
   PercorsoCompletoDatabase \ vostrodb.gdb (if you want you can change the password of the database). Next. In the window Query Project you will write the query which, for semplicity it will be: select*from VostraTabella. Next. In the window Select type of report select, for semplicity, Table. Next. In the window Planning Table the fields of the table will appear to you, on the left side. Left all as it is. Next. In the window Chose table style you can choose between the types of style listed, but it is clear that if you will not follow the guided procedure you can personalize as you want the styles of the report. Next. In the window Completion guided procedure you may give a name to your report. Therefore the end.
   

Therefore you have created your first one report with the Reporting Services. In the next argument we will see how to use the report with the control reportviewer in VB 2005.