In Part 1 of this series, we talked about SSRS in general and then in Part 2 confirmed SSRS was installed and configured properly. This article will show you how to use VS2012 Business Intelligence Reporting Services Template to deploy a Report to Arvixe. Although this process is the same no matter who is hosting SQL, this article is dedicated to Arvixe implementation. The first thing to do is to launch Visual Studio 2012 and select New Project and then Report Server Project (Figure 1)
A – Name of the Project
B – Leave as the Default
C – This is the name of Solution
D – Specify the Directory to hold this project.
E – Select this Template under Reporting Services
F – Chose Reporting Services.
3. Right Click on Shared Data Sources and select Add New Data Source. (Figure 3)
4. Enter a name for the datasource (my example is datasource1)
5. Click on edit. Once you do this then a dialog like Figure 5 will come up. Enter the following options.
|A||Server Name: This will be the server that your sql database is on. It will probably look like [xxx].arvixe.com|
|B||This user name for the SQL Server that you can find in the Arvixe Control Panel of SQL Server. (Enter password right below)|
|C||If you have configured everything properly then you should see a list of your databases.|
|D||To make sure everything is configured properly you can click on ‘Test Connection’. If everything is correct you should see a screen telling you that the test passed successfully.|
6. Press OK
7. Click on Credentials (This is an important step. Click on Use this user name and password and enter the user name and password from above step.) (Figure 6)
Once you done this then you should then see this.
NOTE: This datasource will be used on your reporting services server.
Build your report using this datasource (outside the scope of this article)
SETTING THE DEPLOYMENT PROPERTIES FOR ARVIXE.
To set up the Deployment properties specifically to Arvixe.
8. Right click on your project (in my case it is DeploySSRS. You should see the following (Figure 8)
Click on Properties (Figure 9)
NOTE: Pay attention to the bolded items.
|OverwriteDataSources||If you want to overwrite the datasource on the server then set this to ‘TRUE’|
|TargetDatasetFolder||Leave this as Datasets|
|TargetDataSourceFolder||This is location will create a folder on the server and place the datasource you created from above. Normally I just leave this alone as well.|
|TargetReportFolder||This is report location to place the report in on the server.|
|TargetReportPartFolder||You can publish parts of a report, such as charts, tables, logos, and other such parts. End-users will have the ability, using Report Builder 3.0 to create reports using the published report parts. This identifies the location (folder) for those parts.|
|TargetServerURL||This is the actual url that you received from Arvixe. This is what they call ‘Report Server Manager’ but it is not the whole url they provide. It is the first part so if you are given the following url http://trout.arvixe.com/ReportServer_SQL_Service/Pages/Folder.aspx?ItemPath=%2fanglertobe then you would enter http://trout.arvixe.com/ReportServer_SQL_Service. This is also the same part as verifying SSRS in part 2 of this series.|
|TargetServerVersion||This is a good way to once again verify that everything is working well. Once you get all of the settings above then you can click on this and ask to verify the version. It will prompt you for login and password. This is the login and password to Reporting Services provided by Arvixe. (See Part 1 for details)|
At this point you should be able to click on deploy and everything should deploy without errors.
Looking for quality web hosting? Look no further than Arvixe Web Hosting!